Welcome to Excel for Financial Analysts post. Many of you might be wondering why this post? Why a separate excel post for how to use Excel in financial analysis? What’s so special about it?
In this post, we will learn how to use keyboard shortcuts for Excel navigation. We will cover some of the very basic shortcuts in excel, most of which we are already aware of plus a few more keys for navigation
This is third post in the series, Excel for Financial Analysis. In this post, we will see how to edit individual cells in excel.
In previous article we saw how to edit/delete individual cells. In this post,we will see how to insert/delete a row or column.
In this post, we will see very important features- hide, unhide and group in excel. Hide and Group in excel feature is useful when you have really huge data that spans over too many rows and columns, and you want to do away with some rows and columns and want to… Read More →
In this post, we will see how to freeze panes and how to zoom in and out of data in excel. Freezing Panes is especially important when you have really huge data. Like shown in the figure below, where the data size is large and you need to scroll… Read More →
In this post, we are going to see Sensitivity Analysis in Excel. Discounted Cash flow is probably the commonest ways of valuation of a company. This method involves amongst other things analyzing the impact of factors like cost of equity or change in risk-free rate on the price of a… Read More →
In this article, I’m going to explain how to calculate one of the most famous ratios, among financial analysis, to measure risk in Microsoft Excel: the Sharpe Ratio. According to Investopedia: “The Sharpe ratio tells us whether a portfolio’s returns are due to smart investment decisions or a result of… Read More →