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

Jun 19 2007

Match Formula in Excel

The Match Formula in Excel is an easy way to have excel look through an array of values and return the relative position if the match is found. The difference between this and the lookup functions (eg. Vlookup) is it return the position of the item and not the item itself. Let’s go ahead and […]

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks