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...

READ MORE

Weighted Average Cost of Capital of a company 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) expect from investing their money...

READ MORE

The last few years have been anything but dull. The economic cycle has turned for good, the technological disruptions are happening at a faster pace than ever, the money is getting poured into electric cars, self-driving cars, artificial intelligence like anything. Gives you a clear picture of...

READ MORE

The day we enter corporate world, we assume that the days of learning are over and implementing the learnings are here. But the reality is far from true. It’s actually the other way around. The day you enter corporate world, the time is ripe for you to unlearn a lot of theoretical concepts and...

READ MORE

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? But what if you are working with a humongous dataset with 20 or 40 may be 100...

READ MORE

Please log-in to provide your comments!

READ MORE

The Learning Hour*: Week 12 – Negotiation based valuation approach There are various methodologies that are used in the real world to value any company. Some of them are highly complex and technical like the Discounted Cash Flows approach, while some are simple but not very technical like the...

READ MORE

The Learning Hour* - Week 8: Using the DATES functionality in Excel 1. A date in Excel is also a number Every date on an Excel sheet can be converted into its corresponding number. For example, the number 1 represents the date January 1, 1990 Let us see how we can find that: Let us say we...

READ MORE

The Learning Hour* - Week 7 : Data Analyst vs Data Scientist Data is the new oil and a lot of new job profiles revolve around it. This is a trend that is hard to reverse in the near future. There are two job profiles in this domain that seem to cause some bit of confusion in our minds. Most...

READ MORE

There are a lot of technological innovations happening in the world today that will radically change how the workplaces of the future will look like. One school of thought is a completely decentralized work-place where every individual will be seen offering their expertise or skill as a...

READ MORE