Bytes

Sort Function for Data Analytics in Excel

In our last blog, we discussed the new Unique function in Excel. In this blog, we will discuss about the newly introduced Sort Function, which is also useful for analyzing large data sets.

PowerPoint Presentation Tips

I have a presentation tomorrow! I need to pitch my ideas to investors! Need to present some report in office today. Have a business proposal meet....

Filter Function for Data Analytics - with Examples

The Filter function is a newly introduced function in Microsoft Excel 365. It is not available in earlier versions of excel. In earlier versions, Filtering of large data sets was done manually.

Financial Analytics for Business Performance

Financial analytics in the current business panorama has emerged as a valuable tool for every company be it small medium or large. 

Procrastination: Biggest Obstacle to Your Learning

Okay, so you’re preparing for a job interview at a private bank coming Monday, which is why you’ve signed up for The Financial Analyst Skills Training (FAST) online course from SKILLFIN LEARNING.

 

Skills vs. Degrees/Certification: What Matters In Today's Era?

There’s a lot of talk about skills vs. degrees or skills vs. certifications. Frankly, that’s a bit of a false choice.

You need a graduate degree at least to be considered for any role in the banking, consulting, financial services 

Finance For Non-Finance Professionals - What Should You Know?

Let’s say you’re an IT professional or a mechanical engineer. Do you really need to pick up finance skills?

Yes, you do.

Just because you’re a non-finance professional is no excuse for you not to learn finance.

Financial Analyst Career Prospects – What to Expect?

Noticed those smartly dressed men and women on CNBC, Bloomberg and Fox Business? They are financial analysts, and among the best paid professionals in the industry. So you want to become a financial analyst too? Great! Here’s what you can expect.

Continuous Learning: Why Is It Important for Millennials?

Millennials are the best educated generation ever. Most young people these days have a college degree; many have a Masters in their chosen field, some have an MBA and a few even have PhDs.

An average Millennial by the time he or she is 32, will have been in at least four different jobs.

Why Should Entrepreneurs Learn Business Finance?

Financial literacy is absolutely essential for entrepreneurs and business founders. Most entrepreneurs are aware of this, but as a survey by Intuit Canada shows, there is a big gap between what entrepreneurs should know about finance and what they really know.

Basics of Financial Statements

Have you ever seen a Financial Statement of a company and left wondering what is it all about?

For professionals who don’t come from an accounting or finance background, it can be quite overwhelming as such.

Excel productivity hack - Navigating between sheets

In one our earlier blogs, we discussed how to create an Index/TOC sheet in an Excel workbook.

Don’t recall? No worries, read it again here.

Got it now. Great!

Pre-money vs Post-money valuation

As an Entrepreneur, you often have to negotiate on your company valuation.

This is especially true when you are looking to raise new funding from investors.

To get your funding, you need to mutually agree on the potential valuation of your company.

Visualization Charts in Excel

Microsoft Excel can be a great tool for visualization purposes. There are some very powerful charts functionalities inbuilt in Excel, that can be used to depict numbers visually.

Let us look at some of those interest charts that are already available to use at the click of a button.

Weighted Average Cost of Capital

When we want to do valuation of any company using the Discounted Cash Flows valuation, we need to calculate a cost of capital.

The cost of capital is simply the expected return that investors (both debt and equity) 

Excel Automation: Creating an Index sheet in a Workbook

You may have worked on an Excel workbook with just 3 or 4 worksheets in them.

In those workbooks, navigating between worksheets is relatively easy.

Right?