July 10, 2013
Excel Form Controls
Written by Alan Murray of Computergaga. Form controls such as option buttons, combo boxes and check boxes allow you to
Read More
June 5, 2013
Excel Combo Box KO’s Data Validation
Data Validation or Drop Down Lists are one of Excel’s greatest features, but I have one gripe with them, and
Read More
April 30, 2013
Excel Tables as Source for Data Validation Lists
I’ve set up a table with some team names that I want to use in a Data Validation list. The
Read More
April 18, 2013
Excel Advanced Filters
To be honest I don’t use Advanced Filters much. I tend to use the regular AutoFilter, or if I need
Read More
April 10, 2013
No More Back and Forth Between Tabs
Moving back and forth between worksheets in a large workbook can be tedious. Of course you can use the shortcut
Read More
February 20, 2013
Excel Surveys (Forms) an Easy Way to Collect Data
Note: Excel Survey is now called Forms. A while back Quiara asked me if there was a way she could
Read More
January 30, 2013
Excel Same Same but Different
Help! Do you use a non-US-English version of Excel? If so, now is your chance to help out the wider
Read More
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