Topic: Excel Modelling

Most Important Excel Skills for Finance

Excel is a life skill for any finance or accounting professional. I know many people in finance for whom MS Excel is at the core of everything they do. Probably if it was not for Excel, their job wouldn’t exist. In this article, I will highlight some of the most...

Alternative to MSN Stock Quotes Add-in in Excel

Note: Finance Train’s users now get a 25% exclusive discount on the purchase the stock quotes in excel add-in. Initial Email by Roger: All of you that use this on a regular basis will already know that this quit working about 4 days ago. I emailed Manish to ask...

Create Financial Dashboards Using Excel PowerPivot

Microsoft Excel has always been the spreadsheet software of choice for organizations around the world to perform financial analysis and generate all kinds of reports. In fact you can safely say that most banks and financial institutions will stop functioning if excel...

Stock Evaluation Spreadsheet

Our user Jim Grant has created a very useful stock evaluator spreadsheet and has shared it with the Finance Train Community. You can download the spreadsheet from the link below: Stock Evaluator Spreadsheet The spreadsheet is created using the Stock Quotes in Excel...

Stock Portfolio Tracker in Google Docs Spreadsheet

One of the best ways to manage your money is to use a spreadsheet program such as Excel or Google Docs to create a personal portfolio tracker. For people who are used to Excel, there was a great plugin called MSN MoneyCentral Stock Quotes Add-in which worked great for...

New Excel Add-in to Get Stock Quotes in Excel

Note: Finance Train’s users now get a 25% exclusive discount on the purchase the stock quotes in excel add-in. Excel is the most commonly used tool by people to manage and keep track of their stock portfolios. One of the most critical tasks to manage a portfolio...

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

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

How to Magnify a Selection in Excel?

Sometimes an excel sheet may contain a large amount of data but you may be using only a small range of cells. You may want to display this range of cells as large as possible. Follow the following steps to do magnify a selection of cells in excel. Select the desired...

Page 1 of 41234