May 25, 2011
Excel UPPER LOWER and PROPER Functions
Sometimes when you import text from another source it may not be formatted in the case you want. For example
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 MoreApril 8, 2011
In Excel 2007 the graphics features are vastly improved. Not only have you got some instant designer quality flow charts
Read MoreApril 6, 2011
Excel’s RAND and RANDBETWEEN functions aren’t very well known, but they can be quite handy. RAND Function RAND is a
Read MoreApril 1, 2011
Ever had a spare $10,000 to put in a term deposit? If you did you might wonder what it would
Read MoreMarch 30, 2011
You’re not likely to hear about Excel’s Camera tool on a training course and you certainly won’t find it on
Read MoreMarch 16, 2011
In my last tutorial I showed you Excel's T function, today we’re looking at the other one-letter function; the Excel
Read MoreMarch 11, 2011
Did you know there are only two functions in Excel that consist of one character? They are T and N.
Read MoreMarch 7, 2011
Often data imported into Excel from another system isn’t quite in the format we want. Text can be split across
Read MoreFebruary 23, 2011
If you work in Excel with data imported from other databases you’ll often find it doesn’t import it in the
Read MoreFebruary 19, 2011
In my last tutorial I showed you how to insert a Subtotal using the Subtotal tool. If you’ve read that
Read MoreFebruary 11, 2011
The dashboard in your car is one of the key tools you use to monitor how it’s running, so it’s
Read MoreFebruary 4, 2011
The Subtotal tool in the Outline group on the Data tab of the ribbon automatically inserts subtotal formulas and grand
Read MoreFebruary 1, 2011
A little while ago I showed you how to do a lookup to the left using the INDEX and MATCH
Read MoreJanuary 28, 2011
Excel Filters are right at home with large tables of data. You can use them to limit the data displayed
Read MoreJanuary 21, 2011
An Excel Pivot Table is one of the most powerful productivity tools available, but some common data layout mistakes can
Read MoreJanuary 12, 2011
Imagine examining hundreds of rows of raw data in Excel in an attempt to find a pattern or trend. You’d
Read MoreJanuary 7, 2011
Here are some easy solutions to Excel cell formatting frustrations that I get asked about all the time. Enter your
Read MoreDecember 17, 2010
Calculating time in Excel can be very frustrating, especially when all you want to do is sum a column of
Read MoreDecember 13, 2010
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
Learning how to customise a cell format in Excel allows you to not only format your data the way you
Read MoreDecember 3, 2010
In this tutorial, we'll dive into the powerful Excel INDEX and MATCH functions, which are essential for manipulating and analyzing
Read MoreNovember 30, 2010
Quite often we want to see a running total or running balance column for our data. There are a few
Read MoreNovember 26, 2010
The Excel HLOOKUP formula is just like the VLOOKUP formula, only the table you are looking up is laid out
Read MoreNovember 24, 2010
The OFFSET function is one of Excel’s best kept secrets. Probably because it’s quite tricky to explain, and can be
Read MoreNovember 21, 2010
Creating Excel drop down lists, or Data Validation Lists as they're formally known, enables you to control the value entered
Read More