June 22, 2011
Excel VLOOKUP with Dynamic Column Reference
If you ever work with large tables of data and you want to insert a VLOOKUP formula that dynamically updates
Read More
June 15, 2011
Excel Array Formula
Knowing Excel array formulas will catapult you to ‘Guru Status’ in your office and I'll do my best to make
Read More
June 1, 2011
Excel TRIM Function Removes Spaces From Text
If you import data from another program it often comes in with additional spaces either at the beginning, end or
Read More
May 25, 2011
Excel UPPER LOWER and PROPER Functions
Sometimes when you import text from another source it may not be formatted in the case you want. For example
Read More
May 11, 2011
Excel CEILING and FLOOR Functions
In Australia we did away with 1 and 2 cent coins years ago. So all prices, where paid in cash,
Read More
April 30, 2011
Excel CHOOSE Function
The Excel CHOOSE function is not much use on its own, but when you nest it with other functions it
Read More
April 20, 2011
Excel MIN MAX SMALL and LARGE Functions
The MIN, MAX, SMALL and LARGE functions in Excel are fairly straight forward, but I’d like to show you a
Read More
April 13, 2011
Standard Deviation in Excel
Updated April 27th 2023 Standard Deviation in Excel is super easy to calculate, and we have separate functions for the
Read More
April 6, 2011
Excel RAND and RANDBETWEEN Functions
Excel’s RAND and RANDBETWEEN functions aren’t very well known, but they can be quite handy. RAND Function RAND is a
Read More
April 1, 2011
How to Calculate Interest on Savings in Excel
Ever had a spare $10,000 to put in a term deposit? If you did you might wonder what it would
Read More
March 16, 2011
Microsoft Excel’s N Function
In my last tutorial I showed you Excel's T function, today we’re looking at the other one-letter function; the Excel
Read More
March 11, 2011
Microsoft Excel’s T Function
Did you know there are only two functions in Excel that consist of one character? They are T and N.
Read More
March 7, 2011
How to Join Text Together in Excel Using CONCATENATE and &
Often data imported into Excel from another system isn’t quite in the format we want. Text can be split across
Read More
February 4, 2011
How to Insert Subtotals in Excel
The Subtotal tool in the Outline group on the Data tab of the ribbon automatically inserts subtotal formulas and grand
Read More
February 1, 2011
Excel VLOOKUP to the Left Using CHOOSE
A little while ago I showed you how to do a lookup to the left using the INDEX and MATCH
Read More
December 17, 2010
Calculating Time in Excel
Calculating time in Excel can be very frustrating, especially when all you want to do is sum a column of
Read More
December 3, 2010
INDEX MATCH Functions in Excel
In this tutorial, we'll dive into the powerful Excel INDEX and MATCH functions, which are essential for manipulating and analyzing
Read More
November 30, 2010
Excel Running Total Formula
Quite often we want to see a running total or running balance column for our data. There are a few
Read More
November 26, 2010
Excel HLOOKUP Formulas Explained
The Excel HLOOKUP formula is just like the VLOOKUP formula, only the table you are looking up is laid out
Read More
November 24, 2010
Excel OFFSET Function Explained
The OFFSET function is one of Excel’s best kept secrets. Probably because it’s quite tricky to explain, and can be
Read More
November 8, 2010
How to Round Numbers in Excel Using 3 Rounding Functions
It’s common practice in Excel to format decimal places to get the desired rounding of numbers. But the problem with
Read More
October 6, 2010
Excel SUBTOTAL Formula Explained
If you think SUM is handy, wait til you meet SUBTOTAL. SUBTOTAL has so many tricks up its sleeve you’ll
Read More
September 29, 2010
Excel Nested IF’s Explained
Did you know we can use a nested IF formula to extend the number of logical tests and therefore, possible
Read More
September 25, 2010
Excel’s IFERROR Puts an End to Messy Workarounds
Before the introduction of the IFERROR function in Excel 2007, if you wanted to hide errors displayed by some formulas
Read More
September 24, 2010
Excel Absolute References $ – The Missing Link
Excel Absolute References are the backbone of ALL formula writing enabling you to copy and paste formulas with ease. Enter
Read More
September 22, 2010
Excel VLOOKUP – Sorted List Explained
In my previous Excel VLOOKUP formula tutorial I mentioned that there are two ways you can use a VLOOKUP but
Read More
September 20, 2010
Excel VLOOKUP Formulas Explained
The Excel VLOOKUP formula is my favourite! Perhaps because it was one of the first formulas I mastered. It gave
Read More
September 13, 2010
Excel COUNTIF and COUNTIFS Formulas Explained
In this tutorial we’re looking at the COUNTIF and COUNTIFS Formulas, and we'll take a look at a couple of
Read More
September 10, 2010
Excel SUMIF and SUMIFS Formulas Explained
SUMIF extends the capabilities of the basic SUM function by allowing you to tell Excel to only SUM items that
Read More
August 25, 2010
Excel IF Statement Explained
In this tutorial we’re going to explain how to use the Excel IF function (also known as IF Statement), and
Read More