Learn finance, banking, risk, data science and fintech

## Financial Modelling: Excel Shortcuts You Must Know

In the previous lesson, we learned about how to setup excel for productivity. We will now look at the important and commonly used shortcuts in excel that can speedup your financial modelling work. General F2 – Edit Cell F4 – Repeat Last Action Ctrl + Z – Undo Last Action Ctrl + O – Open

## Financial Modelling: Setup Excel for Productivity

This article is a part of our blog posts on how to build simple, readable and better financial models. The objective is to teach you how to be more productive, make lesser errors and make it easy for others to use the financial models build by you. The first step in building a successful financial

## Stock Market Functions (SMF) Add-in – Get Financial Data in Excel

Over the past couple of days I’ve been looking for various tools that could help us extract stock markets data in excel. I’ve earlier talked about the MarketXLS excel add-in which is also a very powerful add-in. Today I wanted to highlight the SMF Add-in which I came across just a few days back. I

## Excel: How to Sort Data Using a Custom Sort Order

If you have some data in your spread sheet you can use the sort function to sort this data in either ascending order or descending order very easily. Let’s say you have a list of 100 books under three categories – Fiction, Management, and Self-help. You can sort the books alphabetically by each category. Excel

## Excel: How to Move to First or Last Row in a List

This is a common problem faced when you are dealing with a large list. You are currently in the beginning of the list and quickly want to go to the last record just to check on the total number of records available. You can simply scroll down the list but that’s not a very efficient

## FRM Exam Study Plan in Excel

FRM is a difficult exam with a huge list of readings prescribed by GARP. FRM Part 1 alone has 52 readings for teh current syllabus. Along with a job and With limited time to study it is important that you keep track of your studies and have a study plan to ensure that you finish

## CFA Study Plan in Excel (For Level 1)

One thing that I’ve noticed CFA candidates talk about is about how huge the CFA syllabus is and how difficult it can get to keep track of what you’ve studied, what’s pending and how much time you should be devoting to your studies. I couldn’t agree more. For the current CFA Level 1 syllabus, there

## Formula to Check if a Cell Contains #N/A

Sometimes you will have a formula in a series of cells and in some of those cells there is an error and the cell displays #N/A. #N/A indicates “Not Applicable” or “Not Available”. #N/A can come in for a variety of reasons. In my case, I encountered it while using the VLOOKUP formula where the

## How to Delete Blank Rows Using Excel VBA?

Here is a simple problem, you have a set of data in an excel sheet, but there are many empty rows. What you want to do is delete these empty rows without changing the order of data or disturbing anything else. If the order of the rows/data did not matter, removing empty rows was simply

## Why take Excel Training?

Sales figures of a cement depot, student admissions month on month in a training center, cost, budget and sales projections in a retail outlet, movement of brands in a multi-brand cloth store all have one thing in common. Capturing, monitoring and analyzing data sets. The days of going with one’s gut are pretty much over.