Excel is a life skill for any finance or accounting professional. I know ... Continue reading
Excel Modelling
Alternative to MSN Stock Quotes Add-in i …
This discussion happened with the intent to find the best Alternative to MSN ... Continue reading
How to Show Negative Numbers in Brackets …
In accounting and financial models sometimes you will want to show negative ... Continue reading
Create Financial Dashboards Using Excel …
Microsoft Excel has always been the spreadsheet software of choice for ... Continue reading
Stock Evaluation Spreadsheet …
Our user Jim Grant has created a very useful stock evaluator spreadsheet and ... Continue reading
Stock Portfolio Tracker in Google Docs S …
One of the best ways to manage your money is to use a spreadsheet program ... Continue reading
Get Stock Quotes in Excel: New Excel Add …
Excel is the most commonly used tool by people to manage and keep track of ... Continue reading
Excel: How to Sort Data Using a Custom S …
If you have some data in your spread sheet you can use the sort function to ... Continue reading
Excel: How to Move to First or Last Row …
This is a common problem faced when you are dealing with a large list. You ... Continue reading
How to Magnify a Selection in Excel? …
Sometimes an excel sheet may contain a large amount of data but you may be ... Continue reading
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 ... Continue reading
How to Delete Blank Rows Using Excel VBA …
Here is a simple problem, you have a set of data in an excel sheet, but ... Continue reading
Why take Excel Training? …
Sales figures of a cement depot, student admissions month on month in a ... Continue reading
Making MSN Stock Quotes Add-in Work in E …
This post is with reference to how to get stock quotes in excel using the ... Continue reading
Using Excel to Calculate Annuity …
An annuity refers to a series of equal cash flows that occur periodically ... Continue reading
Calculating EWMA Correlation Using Excel …
We had recently learned about how to estimate volatility using EWMA – ... Continue reading
How to Calculate Volatility in Excel? …
We know that the prices of different financial assets such as currencies and ... Continue reading
Stock Quotes in Excel for NSE/BSE …
Often times, you will need to get the stock quotes for different stocks in ... Continue reading
Using LINEST() Function in Excel for Mul …
The LINEST() function calculates the statistics for a line by using the ... Continue reading
Online Excel Training – Beginners …
Being in the field of finance, Excel is an almost indispensable skill that ... Continue reading