Get your free Microsoft Excel 2013 Mortgage Calculator (Amortization Table)
- Comments Off
If you are like many Americans you have at one time or another had the need to calculate mortgage payments. In the past these calculations were done on paper, using a calculator. But in recent years you have been given the option of doing them online or in a workbook such as Excel. Now […]
Excel ? IF Statements, LOOKUPS & INDEX/MATCH. When to choose which one? – Part One.
- Comments Off
This article will focus on the appropriate use of IF statements, and also show you when it’s better to move into more robust formulas like LOOKUP, VLOOKUP, HLOOKUP & INDEX/MATCH. IF statements are one of the core formula models you can use in Excel, and they can be very powerful with regards to their […]
Free Excel Training
- Comments Off
Would you like to receive the same Microsoft Excel training that clients pay $250 an hour for, for free? No, really. Here are 10 free training videos on Microsoft Excel (See the links below). If your company was to hire us to do a webinar on Microsoft Excel formulas and functions, Pivot Tables, POWER Tips […]
Insert the current date in Excel – Keyboard Shortcut
- Comments Off
There are so many useful keyboard shortcuts in Microsoft Excel. Most of us have heard of ‘Ctrl‘ ‘Z‘ for undo. Perhaps ‘Ctrl‘ ‘C‘ for copy, or ‘Ctrl‘ ‘V‘ for paste. But one of the most useful ones I personally use is ‘Ctrl‘ ‘;‘ to enter the current date. Why type ‘01/15/2015‘ when you can hit two […]
Change Case of Text in Excel
- Comments Off
One question I get all the time is how to change the case of text in Excel. Some applications require case-specific text to make a match with its data. Or you may just want to clean up your data to make it consistent across the document. Excel provides three quick formulas to accomplish the text-case […]