January 17, 2013
Excel CONVERT Function
I don’t know about you but I’m forever converting things. In Australia we use the metric system. Our pounds are
Read More
December 12, 2012
Excel Wildcard Quirk Solved
Last week I wrote about using less than and greater than operators with letters like this: =COUNTIF(grade,"<B*") Here’s the post.
Read More
December 5, 2012
Excel COUNTIF Using Text Criteria
Last week Ann emailed me a question and before I had a chance to even look at it she emailed
Read More
November 27, 2012
Excel NETWORKDAYS Function
The Excel NETWORKDAYS function returns the number of whole working days between two date serial numbers, excluding weekends (Saturday &
Read More
November 21, 2012
Excel VLOOKUP Multiple Sheets
This week I had a question from Diedre asking if she can use VLOOKUP to check multiple sheets…. 17 different
Read More
November 15, 2012
Excel Time Calculation Tricks
The past few weeks I have had endless questions about time calculations in Excel. So this week I thought I
Read More
October 31, 2012
Excel Factor 21 Hyperlink Triptych
These Excel Factor tips were sent in by Zoran Stanojevic of Belgrade, Serbia. Words by Mynda Treacy Zoran has prepared
Read More
October 17, 2012
Excel Factor 19 Dynamic Dependent Data Validation
This Excel Factor tip was sent in by Roberto Mensa of Italy. Words by Mynda Treacy. Data validation lists are
Read More
October 10, 2012
Excel Factor 18 Dynamic Hyperlinks and the Magic Hash
This Excel Factor tip was sent in by Jerry Beaucaire of Bakersfield, California. Words by Mynda Treacy Hyperlinks can make
Read More
October 3, 2012
Excel Factor 17 Lookup and Return Multiple Matches
This Excel Factor tip was sent in by Bob Cooke of Lincolnshire, England. Words by Mynda Treacy Last week Bob
Read More
September 22, 2012
Excel Factor 16 Dynamic Lookup
This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Words by Bryon Smedley. Enter your email
Read More
September 19, 2012
Excel Factor 15 The Lazy Lookup
This Excel Factor tip was sent in by Kathy Carmel of Santa Barbara, California. Words by Mynda Treacy. Kathy uses
Read More
September 12, 2012
Excel Factor 14 Interleave Data from Two Columns into One
This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. I have to admit, this problem doesn't come up
Read More
August 29, 2012
Excel Factor 12 Secret EVALUATE Function
This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Suppose you receive a spreadsheet with calculations,
Read More
August 22, 2012
Excel Factor 11 Forecasting Tricks
These Excel Factor tips were sent in by David Kramer of Denver, Colorado, USA. Tip 1: Include or exclude parts
Read More
August 8, 2012
Excel Factor 9 Count Unique Items in a List
This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. There are times when you wish to
Read More
July 25, 2012
Excel Factor 7 In Cell Charts
This Excel Factor tip is from Dr Isaac Gottlieb, professor at Temple University in Philadelphia. Words by Mynda Treacy Excel
Read More
July 13, 2012
Excel Factor 5 Dynamic Print Area
The following Excel Factor entry was sent in by Daniel Ferry, founder of Excel enthusiast blog, Excel Hero. Often an
Read More
July 11, 2012
Excel Factor Entry 4 INDEX and MATCH Two Criteria
The need to look up and match multiple criteria is quite common; however as with most things in Excel there
Read More
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 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 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 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
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