Every proposed project has its own risks. We cannot just accept any project and hope for positive returns. We need to first assure ourselves that the project will provide decent returns for our business. How do we know if a project will provide a good return or not? We use feasibility study. A feasibility study […]
Welcome to our Excel guide on how to construct interactive charts and dashboards.Usually, students of Excel thinks that only the formulas and syntaxes are the most important aspects of learning Excel. But, tell you what, presenting those data are equally important. The users of your crunched numbers will most likely don’t have time to dig […]
Background You were hired as a financial data analyst at a construction company. You were given a table and subsequent instructions on what to do with the data.The table is about vehicle purchase requests from the company’s branches. It includes all cash inflows that can be brought by those assets. *All paragraphs underlined and in […]
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 access only few of them. […]
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 down, in such case you […]
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 company’s share. It is but […]