Topic: Excel Modelling

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...

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...

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....

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...

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....

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...

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...

Page 2 of 41234