February 13, 2013
Excel Shortcut When Using Dates as Formula Criteria
Working with Dates in Excel can be frustrating because a date criteria in one formula doesn’t always work in another.
Read More
February 6, 2013
Excel Ignore Blanks in Data Validation List
Last week I showed you how you can extract a list that excludes blank cells for use in a data
Read More
February 1, 2013
Excel Remove Blank Cells from a Range
Last week Keith asked how he can ignore blanks in a range referenced by a Data Validation list. I think
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
January 17, 2013
Excel CONVERT Function
I don’t know about you but I’m forever converting things. In Australia we use the metric system. Our pounds are
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
December 12, 2012
Excel Wildcard Quirk Solved
Last week I wrote about using less than and greater than operators with letters like this: =COUNTIF(grade,"<B*") Here’s the post.
Read More
December 5, 2012
Excel COUNTIF Using Text Criteria
Last week Ann emailed me a question and before I had a chance to even look at it she emailed
Read More
November 27, 2012
Excel NETWORKDAYS Function
The Excel NETWORKDAYS function returns the number of whole working days between two date serial numbers, excluding weekends (Saturday &
Read More
November 21, 2012
Excel VLOOKUP Multiple Sheets
This week I had a question from Diedre asking if she can use VLOOKUP to check multiple sheets…. 17 different
Read More
November 15, 2012
Excel Time Calculation Tricks
The past few weeks I have had endless questions about time calculations in Excel. So this week I thought I
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 31, 2012
Excel Factor 21 Hyperlink Triptych
These Excel Factor tips were sent in by Zoran Stanojevic of Belgrade, Serbia. Words by Mynda Treacy Zoran has prepared
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
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