December 19, 2012
Merry Christmas 2012 and Happy New Year 2013
2012 has been an amazing and rewarding year at My Online Training Hub and we’re excited to see what 2013
Read More
November 7, 2012
Excel Factor Voting Roundup
Back in June this year I had an idea to hold an X-Factor style competition where anyone could submit an
Read More
October 24, 2012
Excel Factor 20 Custom Number Format Disguise
This Excel Factor tip was sent in by Marc Joannette of Montreal, Canada. Words by Mynda Treacy. Marc's job involves
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 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
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
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
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
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 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
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
November 10, 2011
Excel Advanced Filter Unique Records
Do you ever want to extract a list of unique records from a massive list like the one in column
Read More
November 2, 2011
Excel Conditional Formatting Zebra Stripes
It's ok, no zebras get hurt in this process, it's actually all built in to Excel's Conditional Formatting 🙂 Conditional
Read More
October 4, 2011
Excel Photo Album of Our New Zealand Trip
We just arrived back from two weeks travelling around New Zealand with 3 other families. While there we managed to
Read More
September 14, 2011
Excel Paste Shortcut
The other day I was in an Excel forum helping answer some questions. I like to help, because….well, I like
Read More
July 29, 2011
Save Time with Hyperlinks for Word, Excel and Outlook
If you work in large Excel files, Word documents or even e-mail, you may find it takes a long time
Read More
June 29, 2011
Save Time with an Excel Workspace
If you find yourself opening the same workbooks each day when you start work, or when you do a particular
Read More
June 8, 2011
Importing Data into Excel
Importing data to Excel from other programs and sources enables you to further analyse and generate reports or dashboards from
Read More
May 19, 2011
Excel Tips for Building Workbooks FAST
I often create Excel workbooks that contain a series of sheets for each region (or product, month, or sales person)
Read More
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
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
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
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 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 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
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
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 More