One of the most popular tools to use for data analysis and automation is Excel. But while many people know how to insert a few formulas and create tables in Excel, not many know that this time-honored program allows complex data analysis, the creation of templates and dashboards and many more. In fact, Excel is […]
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 […]
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 […]
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 excess risk. Although one portfolio […]