Blog • Page 18 of 24 • My Online Training Hub

March 5, 2014

Excel Designed Minecraft Cake

Each year our sons choose a cake they want me to make for their birthday. Now, I am no baker

February 27, 2014

Create Barcodes With (Or Without) Excel VBA

Barcode Types & Uses There are LOTS of barcode types used for a multitude of things. Various internationally recognised standards

February 18, 2014

6 Ways to Fix Dates Formatted as Text in Excel

If you import data to Excel from another program chances are the dates will come in formatted as text, which

February 12, 2014

Who Needs Word When Excel Has Got Fill Justify Text

They say the true Excel fan has uninstalled Word from their PC, and removed the F1 key from their keyboard

February 7, 2014

Convert Numbers (Currency) to Words With Excel VBA

We get requests now and again asking how to convert numbers to words (or convert currency) e.g. 123.45 becomes One

January 30, 2014

Curse You Excel Cursor

The Scenario You need to change the range referenced by your chart/conditional formatting/named range so you merrily open the Edit

January 23, 2014

Charting Disparate Data in Excel – 3 Solutions and 1 Crazy Mess

Last week we looked at some different ways to plot the same data, with each chart enabling the reader to

January 15, 2014

4 Charts – Same Data. Which do you think is best?

Often when you’re charting data it can be tricky to find the best chart for the job. If you get

January 10, 2014

Mac Excel Keyboard Shortcuts Cover

If you’re frustrated using Excel on a Mac because you don’t know the shortcut keys you’re used to using on

January 6, 2014

Excel TEXT Function – handy but limited…or is it?

At first glance the Excel TEXT function appears quite limited. Its purpose is to convert numbers to text in a

December 11, 2013

Assign a Macro to a Shape or Use a Shortcut Sequence

So you’ve got some code and you want to be able to run it, but opening up the list of

December 4, 2013

Excel Search a Cell for a List of Words

A while back Vernon asked me how he could search one cell and compare it to a list of words.

November 27, 2013

How To Use VBA Code From The Internet

So you’ve found some VBA code on the ‘net that will save you hours and hours of work, but how

November 27, 2013

How To Enable the Developer Tab in Excel

The Developer tab in Excel gives you access to features and tools that help you to write and run macros.

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