April 8, 2011
Microsoft Excel Shapes & SmartArt
In Excel 2007 the graphics features are vastly improved. Not only have you got some instant designer quality flow charts
Read More
April 6, 2011
Excel RAND and RANDBETWEEN Functions
Excel’s RAND and RANDBETWEEN functions aren’t very well known, but they can be quite handy. RAND Function RAND is a
Read More
April 1, 2011
How to Calculate Interest on Savings in Excel
Ever had a spare $10,000 to put in a term deposit? If you did you might wonder what it would
Read More
March 30, 2011
Microsoft Excel Camera Tool
You’re not likely to hear about Excel’s Camera tool on a training course and you certainly won’t find it on
Read More
March 16, 2011
Microsoft Excel’s N Function
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
March 11, 2011
Microsoft Excel’s T Function
Did you know there are only two functions in Excel that consist of one character? They are T and N.
Read More
March 7, 2011
How to Join Text Together in Excel Using CONCATENATE and &
Often data imported into Excel from another system isn’t quite in the format we want. Text can be split across
Read More
February 23, 2011
Excel Text to Columns to Correct Date Formats
If you work in Excel with data imported from other databases you’ll often find it doesn’t import it in the
Read More
February 19, 2011
Excel Group and Outline Data
In my last tutorial I showed you how to insert a Subtotal using the Subtotal tool. If you’ve read that
Read More
February 11, 2011
Excel Dashboard Reports
The dashboard in your car is one of the key tools you use to monitor how it’s running, so it’s
Read More
February 4, 2011
How to Insert Subtotals in Excel
The Subtotal tool in the Outline group on the Data tab of the ribbon automatically inserts subtotal formulas and grand
Read More
February 1, 2011
Excel VLOOKUP to the Left Using CHOOSE
A little while ago I showed you how to do a lookup to the left using the INDEX and MATCH
Read More
January 28, 2011
How to Use Excel Filters
Excel Filters are right at home with large tables of data. You can use them to limit the data displayed
Read More
January 21, 2011
Excel Pivot Table Video Tutorial
An Excel Pivot Table is one of the most powerful productivity tools available, but some common data layout mistakes can
Read More
January 12, 2011
How to Use Excel Conditional Formatting
Imagine examining hundreds of rows of raw data in Excel in an attempt to find a pattern or trend. You’d
Read More
January 7, 2011
Excel Cell Formatting Tips & Tricks
Here are some easy solutions to Excel cell formatting frustrations that I get asked about all the time. Enter your
Read More
December 17, 2010
Calculating Time in Excel
Calculating time in Excel can be very frustrating, especially when all you want to do is sum a column of
Read More
December 13, 2010
Make Excel Speak What You Type
There’s a little known tool in Excel that will convert your text into speech and read your worksheet to you.
Read MoreDecember 7, 2010
Excel Custom Cell Formats
Learning how to customise a cell format in Excel allows you to not only format your data the way you
Read More
December 3, 2010
INDEX MATCH Functions in Excel
In this tutorial, we'll dive into the powerful Excel INDEX and MATCH functions, which are essential for manipulating and analyzing
Read More
November 30, 2010
Excel Running Total Formula
Quite often we want to see a running total or running balance column for our data. There are a few
Read More
November 26, 2010
Excel HLOOKUP Formulas Explained
The Excel HLOOKUP formula is just like the VLOOKUP formula, only the table you are looking up is laid out
Read More
November 24, 2010
Excel OFFSET Function Explained
The OFFSET function is one of Excel’s best kept secrets. Probably because it’s quite tricky to explain, and can be
Read More
November 21, 2010
Excel Drop Down Lists
Creating Excel drop down lists, or Data Validation Lists as they're formally known, enables you to control the value entered
Read More
November 8, 2010
How to Round Numbers in Excel Using 3 Rounding Functions
It’s common practice in Excel to format decimal places to get the desired rounding of numbers. But the problem with
Read More
November 1, 2010
Excel Pivot Tables Explained
Excel Pivot Tables are one of the most powerful tools at our disposal, and once you understand how they work,
Read More
October 27, 2010
Excel Named Ranges Explained
Named Ranges in Excel are an essential tool for simplifying and enhancing the functionality of spreadsheets. They allow you to
Read MoreOctober 7, 2010
Get Your Own Interactive Google Map FREE
Have you ever wanted your very own interactive Google Map dotted with locations relevant to your business? You might want
Read More
October 6, 2010
Excel SUBTOTAL Formula Explained
If you think SUM is handy, wait til you meet SUBTOTAL. SUBTOTAL has so many tricks up its sleeve you’ll
Read More
October 2, 2010
Excel IF AND OR Functions Explained
Excel IF AND OR functions on their own aren’t very exciting, but mix them up with the IF Statement and
Read More