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
September 5, 2012
Excel Factor 13 Handy Tips & Tricks
These Excel Factor tips are from Dr Isaac Gottlieb, professor at Temple University in Philadelphia. Every month Isaac publishes a
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 15, 2012
Excel Factor 10 Conditional Formatting Painting by Numbers
This Excel Factor entry was sent in by Rob Anderson of Oxfordshire, UK. Project planning and other tracking worksheets can
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
August 3, 2012
Excel Factor 8 Highlight Cells Containing Formulas
This Excel Factor tip was sent in by Shannon Hommel of the UK. If you’re setting up a template or
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 18, 2012
Excel Factor 6 Auto Refresh PivotTables
This Excel Factor tutorial was sent in by Bryon Smedley of Bristol, Tennessee. Excel PivotTables are one of the greatest
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 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