
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 MoreMarch 1, 2012
Formulas containing dates and time in Excel can be frustrating if you don’t understand how they work. And even if
Read MoreFebruary 22, 2012
From time to time I get asked the question “what order do formulas evaluate?” The acronym BEDMAS can help you
Read MoreFebruary 15, 2012
I had an email from Bobcat today asking how to lookup data that is spread across multiple columns. Table
Read MoreFebruary 8, 2012
Using Data Validation to restrict what gets entered in a cell or range of cells is great for standardising your
Read MoreJanuary 27, 2012
Let’s say that a baby learning to crawl is an analogy for learning the AVERAGE function in Excel. Then learning
Read MoreJanuary 18, 2012
Last week I had a question from Dan that I’d never come across before. Dan has a dress shop with
Read MoreJanuary 12, 2012
My Toughest Excel Challenge So Far! Recently a member contacted me with a VLOOKUP question, but when I further understood
Read MoreDecember 14, 2011
The Excel INDIRECT Function has many applications and perhaps its simplest is to fix a range of cells you want
Read MoreDecember 7, 2011
For some of us we use the VLOOKUP function all the time and for the most part is does exactly
Read MoreNovember 30, 2011
I’m working on a dashboard for a client and I’ve set it up so that they can choose which month
Read MoreNovember 23, 2011
What say you want to find the percentage increase or decrease for the last value in a list compared to
Read MoreNovember 16, 2011
You may already know you can find the 3rd highest value using the LARGE function, but what if you want
Read MoreSeptember 28, 2011
The Excel TIME function combines separate hour, minute and second values and converts them into a time serial number. If
Read MoreSeptember 21, 2011
With a family of 4 fussy eaters to feed (well actually, 3 fussy eaters and myself) I do a lot
Read MoreSeptember 7, 2011
Excel Database functions have been around for donkey's years so it's surprising that not many people know about them. They
Read MoreAugust 31, 2011
Wildcards *?~....what am I talking about? And no, it's not an expletive. Let’s start with an example. COUNTIF using Wildcards
Read MoreAugust 24, 2011
In Excel there are two almost identical functions; SEARCH and FIND. The SEARCH and FIND functions allow you to find
Read MoreJuly 13, 2011
Each time I write a tutorial I use the Google Keyword tool to find search phrases that are relevant. I
Read MoreJuly 6, 2011
If you just want a quick count of the number of items in a list or a range of cells
Read MoreJune 22, 2011
If you ever work with large tables of data and you want to insert a VLOOKUP formula that dynamically updates
Read MoreJune 15, 2011
Knowing Excel array formulas will catapult you to ‘Guru Status’ in your office and I'll do my best to make
Read MoreJune 1, 2011
If you import data from another program it often comes in with additional spaces either at the beginning, end or
Read MoreMay 25, 2011
Sometimes when you import text from another source it may not be formatted in the case you want. For example
Read MoreMay 11, 2011
In Australia we did away with 1 and 2 cent coins years ago. So all prices, where paid in cash,
Read MoreApril 30, 2011
The Excel CHOOSE function is not much use on its own, but when you nest it with other functions it
Read MoreApril 20, 2011
The MIN, MAX, SMALL and LARGE functions in Excel are fairly straight forward, but I’d like to show you a
Read MoreApril 13, 2011
Updated April 27th 2023 Standard Deviation in Excel is super easy to calculate, and we have separate functions for the
Read MoreApril 6, 2011
Excel’s RAND and RANDBETWEEN functions aren’t very well known, but they can be quite handy. RAND Function RAND is a
Read MoreApril 1, 2011
Ever had a spare $10,000 to put in a term deposit? If you did you might wonder what it would
Read MoreMarch 16, 2011
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