Blog • Page 21 of 26 • My Online Training Hub

July 17, 2013

Excel CLEAN Formula

Ever copy and paste some data from a web page, or import it from another program, and end up with

July 17, 2013

Excel SUBSTITUTE Formula

The Excel SUBSTITUTE function replaces new_text for old_text in a text string. The Excel SUBSTITUTE Function Syntax is: SUBSTITUTE(text,old_text,new_text,[instance_num]) The

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

July 2, 2013

Interactive Excel Chart with Map

Today I’d like to share with you a video tutorial by Isaac Gottlieb on supply-chain decision making from his book

June 30, 2013

Excel ACCRINT Function

The Excel ACCRINT function returns the accrued interest for a security that pays interest periodically. The Syntax is: ACCRINT(issue, first_interest,

June 25, 2013

Excel Bank Reconciliation Formula

This week I had a question from Dominique that took me back to my accounting days. She asked “how can

June 12, 2013

Excel Find Column Containing a Value

Last week I had an email from Mike asking how he can lookup a suburb in a range of columns

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

May 29, 2013

Excel Formulas

Here you'll find a list of common Microsoft Excel formulas and functions explained in plain English, and applied to real

May 28, 2013

Excel Conditional Formatting Gantt Chart

Gantt charts are handy for planning and managing project tasks over time. They give a visual representation of the whole

May 22, 2013

Excel Gantt Chart

Gantt charts are commonly used in project management and while Excel doesn’t have a native Gantt chart in its chart

May 16, 2013

VLOOKUP Multiple Values in Multiple Columns

A few weeks ago David T asked me to help him understand a VLOOKUP formula in a workbook he’d inherited

May 9, 2013

Excel BETWEEN Formula

A little while ago Brendan asked me how he could check if values in a list fall between two limits.

using excel table as data validation source

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

April 25, 2013

Excel Step Charts

I recently came back from a family skiing vacation in Whistler, Canada, which by the way was fantastic. Here we

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

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

April 2, 2013

Excel PivotTable Month Comparison [Video]

In this last tutorial, in my 3 part series on PivotTable tips and tricks, I’m going to show you how

March 26, 2013

Excel PivotTable Grouping

Battling to consolidate monthly figures into quarters, or segment data into numeric bands? Perhaps you're aiming for a bespoke grouping

March 19, 2013

Excel PivotTable Add Percentage of Total Column [Video]

Excel PivotTables make light work of analysing data but there are a few tricks once you get past the basics.

March 13, 2013

World’s Most Accurate Pie Chart

As fun as this chart is, it actually makes a valid point and that is; pie charts are (typically) not

March 6, 2013

Excel Conditional Formatting with Formulas

Excel’s Conditional Formatting tool is diverse with loads of built in rules that you simply point and click to use,

February 27, 2013

Excel PivotTables Unique Count 3 Ways

PivotTables are the Origamists of Excel. Folding and summarising data into almost any shape. I say 'almost' because until Excel

Excel Surveys an Easy Way to Collect Data

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

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.

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

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

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

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

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