The most comprehensive educational resources for finance

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.

Making MSN Stock Quotes Add-in Work in Excel 2010

This post is with reference to the MoneyCentral Stock Quotes Add-in that we had talked about sometime back. Many people have been happily using it with their versions of excel. However, some people complained that they couldn’t use it and most of the time it was because they upgraded to Excel 2010. One of our

Using Excel to Calculate Annuity

An annuity refers to a series of equal cash flows that occur periodically such as monthly or annually. For example, an investment that gives you fixed monthly payments for a specified period. There are two types of annuities, namely, regular annuities and annuities due. In a regular annuity, the first cash flow occurs at the

Calculating EWMA Correlation Using Excel

We had recently learned about how to estimate volatility using EWMA – Exponentially Weighted Moving Average. As we know, EWMA avoids the pitfalls of equally weighted averages as it gives more weight to the more recent observations compared to the older observations. So, if we have extreme returns in our data, as time passes, this

How to Calculate Volatility in Excel?

We know that the prices of different financial assets such as currencies and stocks are constantly fluctuating as traders buy and sell these assets. The variation in the prices over a period of time is called volatility. The volatility tells us about how turbulent the price is and is an indicator of the risk involved.

Stock Quotes in Excel for NSE/BSE

Often times, you will need to get the stock quotes for different stocks in your excel sheet. For example, if you maintain your investment portfolio in an excel sheet, it will be great to supplement your portfolio information with real-time prices for these stocks that you can update at the click of a button. At

Using LINEST() Function in Excel for Multivariate Regression

The LINEST() function calculates the statistics for a line by using the “least squares” method to calculate a straight line that best fits your data, and returns an array that describes the line. Because this function returns an array of values, it must be entered as an array formula. The equation for the line is

Online Excel Training – Beginners and Advanced

Being in the field of finance, Excel is an almost indispensable skill that every professional needs to have. Whether you are in investment banking, corporate finance, or even risk management, your skills at using Microsoft excel can make your life easy and number crunching a breeze. While we are working on an online program on Financial Modeling