March 1, 2012
SUMIFS Formula Referencing Cells Containing Dates
Formulas containing dates and time in Excel can be frustrating if you don’t understand how they work. And even if
Read More
February 22, 2012
Excel Evaluate Formula Tool
From time to time I get asked the question “what order do formulas evaluate?” The acronym BEDMAS can help you
Read More
February 15, 2012
VLOOKUP Multiple Criteria
I had an email from Bobcat today asking how to lookup data that is spread across multiple columns. Table
Read More
February 8, 2012
Excel Data Validation With Dependent Lists
Using Data Validation to restrict what gets entered in a cell or range of cells is great for standardising your
Read More
February 3, 2012
What If Analysis Using Excel Scenarios
What if my side eBay bike business sold an extra 10%, what if I increased my price by $15 per
Read More
January 27, 2012
Excel AVERAGE, AVERAGEIF and AVERAGEIFS
Let’s say that a baby learning to crawl is an analogy for learning the AVERAGE function in Excel. Then learning
Read More
January 18, 2012
ROUNDUP and ROUNDDOWN with a Twist
Last week I had a question from Dan that I’d never come across before. Dan has a dress shop with
Read More
January 12, 2012
INDEX MATCH With a Twist
My Toughest Excel Challenge So Far! Recently a member contacted me with a VLOOKUP question, but when I further understood
Read More
December 14, 2011
Excel INDIRECT Function
The Excel INDIRECT Function has many applications and perhaps its simplest is to fix a range of cells you want
Read More
December 7, 2011
Excel VLOOKUP Multiple Values
For some of us we use the VLOOKUP function all the time and for the most part is does exactly
Read More
November 30, 2011
Excel LARGE and EOMONTH Array Function
I’m working on a dashboard for a client and I’ve set it up so that they can choose which month
Read More
November 23, 2011
Cool INDEX Function Trick
What say you want to find the percentage increase or decrease for the last value in a list compared to
Read More
November 16, 2011
Excel Average Top 3 Values
You may already know you can find the 3rd highest value using the LARGE function, but what if you want
Read More
November 10, 2011
Excel Advanced Filter Unique Records
Do you ever want to extract a list of unique records from a massive list like the one in column
Read More
November 2, 2011
Excel Conditional Formatting Zebra Stripes
It's ok, no zebras get hurt in this process, it's actually all built in to Excel's Conditional Formatting 🙂 Conditional
Read More
October 25, 2011
Top 5 Mistakes With Reports in Excel
There's a handful of mistakes almost everyone makes when they first use Excel. I know I did. In fact some
Read More
October 21, 2011
Excel Dynamic Text Formulas Trick [FREE VIDEO]
Inserting text into a text box is one cool trick, but being able to have that text update when your
Read More
October 4, 2011
Excel Photo Album of Our New Zealand Trip
We just arrived back from two weeks travelling around New Zealand with 3 other families. While there we managed to
Read More
September 28, 2011
Excel TIME Function
The Excel TIME function combines separate hour, minute and second values and converts them into a time serial number. If
Read More
September 21, 2011
Excel CONVERT Functions
With a family of 4 fussy eaters to feed (well actually, 3 fussy eaters and myself) I do a lot
Read More
September 14, 2011
Excel Paste Shortcut
The other day I was in an Excel forum helping answer some questions. I like to help, because….well, I like
Read More
September 7, 2011
Easy Excel Database Functions
Excel Database functions have been around for donkey's years so it's surprising that not many people know about them. They
Read More
August 31, 2011
Excel Wildcards in your SUMIF, COUNTIF and VLOOKUP
Wildcards *?~....what am I talking about? And no, it's not an expletive. Let’s start with an example. COUNTIF using Wildcards
Read More
August 24, 2011
Excel SEARCH and You Will FIND
In Excel there are two almost identical functions; SEARCH and FIND. The SEARCH and FIND functions allow you to find
Read More
August 17, 2011
Create a Pivot Table Direct From Access
Did you know you can analyse data from an Access database in an Excel Pivot Table without importing the data
Read More
August 10, 2011
Excel Chart Axis Label Tricks
So, you’ve analysed your data and plotted your chart but the axis labels are all skewey (technical term). Let’s look
Read More
August 3, 2011
Excel Chart Secondary Axis
One of the Excel questions I get asked often is; how do I add a secondary axis to my chart?
Read More
July 29, 2011
Save Time with Hyperlinks for Word, Excel and Outlook
If you work in large Excel files, Word documents or even e-mail, you may find it takes a long time
Read More
July 20, 2011
Excel Histogram Charts and FREQUENCY Function
A Histogram, also known as a frequency distribution, is a chart that illustrates the distribution of values that fall into
Read More
July 13, 2011
Excel SUBSTITUTE Function Trick
Each time I write a tutorial I use the Google Keyword tool to find search phrases that are relevant. I
Read More