July 4, 2012
Excel Factor Entry 3 Re-format Data Using Formulas
Importing data into Excel from other systems rarely goes without the need to fix formatting before you can even use
Read More
June 27, 2012
Excel Factor Entry 2 – AutoFilter
If you use Excel Filters then you’ll love this time saving tip. This tip was sent in by Mohammed Mustafa
Read More
June 20, 2012
Excel Factor Entry 1 – Reverse PivotTable
How to Create a Reverse PivotTable - this is genius. This tutorial was sent in by Bryon Smedley of Bristol,
Read More
June 20, 2012
Calling All Excel Enthusiasts – Excel Factor Competition
Got a cool Excel trick you're proud of? I thought it'd be fun to hold an Excel Factor competition. Think
Read More
June 6, 2012
Secret Excel DATEDIF Function
Want to calculate the number of months between two dates? One little known way is to use the secret Excel
Read More
May 29, 2012
Excel COUNT Coloured Cells
From time to time I get asked; “how can I count cells formatted in a particular colour”. Aka 'color' if
Read More
May 24, 2012
Find the Last Value in a Column
The other day a member emailed me the following question: “I created a check book in Excel 2010 and I
Read More
May 16, 2012
Funky Shapes and Fills in Excel Comments
Did you know you can jazz-up your Excel Comments using Shapes, or even insert a Picture that conveys your message?
Read More
May 10, 2012
List Sheet Tab Names with Excel VBA
As I promised last week, today’s tutorial is a dead easy macro that will allow you to extract a list
Read More
May 2, 2012
Excel 3D SUMIF Across Multiple Worksheets
No, no, no, no, no I’m not talking about the latest 3D animated movie. I’m talking about how you can
Read More
April 25, 2012
Force Excel to Open on a Specific Sheet
A few weeks ago one of our members, Perrin asked; “Is there a way to force a workbook to always
Read More
April 19, 2012
Excel RANK, RANK.AVG and RANK.EQ Functions
No prizes for guessing what the Excel RANK functions do and I’ll cover them in a moment. But first you
Read More
April 10, 2012
Invest $x at 4.75% for 5 Years to Make $15,000
I received an email from Stacey a few weeks ago asking: “Which formula would I use to find the initial
Read More
April 3, 2012
Excel Go To Special is Very Special Indeed!
I can’t believe I haven’t already written a tutorial about Excel’s Go To Special feature. It is one of my
Read More
March 27, 2012
Excel EOMONTH Function
Continuing on from last week’s EDATE function, today we’re looking at the Excel EOMONTH function. If you use Excel to
Read More
March 20, 2012
Excel EDATE Function
If you need to calculate due dates for projects or payments then Excel’s EDATE function will make life easy for
Read More
March 13, 2012
Excel MIN IF Array Formula
A few weeks ago Karine asked me if there was a way she could find the minimum value for
Read More
March 7, 2012
Calculate How Long to Make $1m with NPER
James wrote to me and asked: if he buys shares worth $2000 and gets 4% return, how many times does
Read More
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