Blog • Page 19 of 24 • My Online Training Hub

November 20, 2013

Excel Hyperlink Buttons

I like to use Excel hyperlink buttons in my Excel workbooks to help with navigation. I link them to a

November 13, 2013

No, you’re not going mad, it’s just Excel’s Implicit Intersection

For many years there has been something kooky going on in my Excel worksheets. It was this strange phenomenon that

November 7, 2013

Favourite Excel Shortcuts

Sometimes it’s the little things that make a big difference so today I’m going to share with you a few

October 30, 2013

Excel Tabular Data Format

Today I want to share with you an Excel secret. It’s so powerful that when you know this your Excel

October 23, 2013

Excel Football Dashboard Extreme Makeover

Phil plays 6 a-side football (soccer) in a Supa-Oldie league. They’re all over 35 and that’s considered supa-old in football!

October 16, 2013

30 Chants for Better Excel Charts

I see the same innocent mistakes with Excel charts and data presentation over and over again. And a lot of

October 14, 2013

VBA to Create PDF from Excel Worksheet Then Email It With Outlook

Real World Scenario One of my customers (thanks Tony) creates invoices in Excel for his clients and at the end

October 9, 2013

Return the First and Last Values in a Range

I’ve been asked many times how to find either the cell reference of the first or last value in a

October 2, 2013

Excel Average IF Excluding Outliers

I stumbled upon an interesting question the other day, which was; ‘how do I find the average of a range

October 1, 2013

Merge Excel Worksheets with VBA

The Scenario Let’s say that you have a lot of sheets in your workbook and you want to merge all

September 25, 2013

Excel Find Partial Text Strings

This is a guest tutorial written by Ruthie Ward of Idaho, USA. I wanted to find a partial match to

September 18, 2013

Filter Excel Pivot Tables by Values

This is a guest tutorial written by Bryon Smedley of Bristol, Tennessee. If you’ve ever used Pivot Tables in Excel,

September 11, 2013

Finding Missing Numbers in a Range Using VBA

The Problem You have a sequence of numbers, and you want to find the numbers that are missing from that

September 11, 2013

Excel Formula – List Missing Numbers in a Sequence

A little while ago I received an email from Deborah asking what formula she can use to list missing numbers

September 4, 2013

Extract Text from a Cell using MID Formulas

Last week we looked at how to use Excel’s Text to Columns tool to extract the domain name from a

August 28, 2013

Extracting Text Strings Using Excel’s Text to Columns

The Easy Way In this example I’m going to show you how you can extract the domain name from a

August 21, 2013

Calculate Elapsed Days, Hours and Minutes in Excel

I had an email from Steve a little while ago asking how he could display the number of elapsed days,

August 14, 2013

Excel Test if a Range Contains Text, Numbers or is Empty

I received an email from Bill this week asking how he can check if a range of cells contains text

August 7, 2013

Excel Quintile Chart

One of my Excel Dashboard course members, Mark Maher, emailed me wanting to know if a chart that Stephen Few

August 2, 2013

Excel Pivot Tables to Extract Data

I regularly get asked: “What formula can I use to extract a list or subset of data from a master

July 23, 2013

Tour de France Excel Dashboard

Since Phil is somewhat of a cycling fan I have been subjected to late night TV of le Tour. Personally

July 18, 2013

Excel Formulas Not Working?

Excel Formula Help is Here Excel formulas can be frustrating to understand, especially when you start nesting functions. If you've

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