Jun 29 2015

Get your free Microsoft Excel 2013 Mortgage Calculator (Amortization Table)

  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 […]

Feb 10 2015

Excel ? IF Statements, LOOKUPS & INDEX/MATCH. When to choose which one? – Part One.

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 […]

Feb 4 2015

Free Excel Training

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 […]

Jan 15 2015

Insert the current date in Excel – Keyboard Shortcut

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 […]

Mar 2 2012

Change Case of Text in Excel

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 […]

Page 1 of 612345...Last »

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks