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 MoreNovember 16, 2011
You may already know you can find the 3rd highest value using the LARGE function, but what if you want
Read MoreNovember 10, 2011
Do you ever want to extract a list of unique records from a massive list like the one in column
Read MoreNovember 2, 2011
It's ok, no zebras get hurt in this process, it's actually all built in to Excel's Conditional Formatting 🙂 Conditional
Read MoreOctober 25, 2011
There's a handful of mistakes almost everyone makes when they first use Excel. I know I did. In fact some
Read MoreOctober 21, 2011
Inserting text into a text box is one cool trick, but being able to have that text update when your
Read MoreOctober 4, 2011
We just arrived back from two weeks travelling around New Zealand with 3 other families. While there we managed to
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 14, 2011
The other day I was in an Excel forum helping answer some questions. I like to help, because….well, I like
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 MoreAugust 17, 2011
Did you know you can analyse data from an Access database in an Excel Pivot Table without importing the data
Read MoreAugust 10, 2011
So, you’ve analysed your data and plotted your chart but the axis labels are all skewey (technical term). Let’s look
Read MoreAugust 3, 2011
One of the Excel questions I get asked often is; how do I add a secondary axis to my chart?
Read MoreJuly 29, 2011
If you work in large Excel files, Word documents or even e-mail, you may find it takes a long time
Read MoreJuly 20, 2011
A Histogram, also known as a frequency distribution, is a chart that illustrates the distribution of values that fall into
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 29, 2011
If you find yourself opening the same workbooks each day when you start work, or when you do a particular
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 8, 2011
Importing data to Excel from other programs and sources enables you to further analyse and generate reports or dashboards from
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 19, 2011
I often create Excel workbooks that contain a series of sheets for each region (or product, month, or sales person)
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 More