Blog • Page 18 of 24 • My Online Training Hub

June 9, 2014

Excel Paste Special Operations

Copying and Pasting are two of the most common tasks you’ll perform in Excel. This is especially true for me

June 5, 2014

Sorting in Excel PivotTables

My second Excel love is PivotTables (VLOOKUP is still my number 1). PivotTables make short work of summarising data and

May 27, 2014

Writing Excel Formulas Efficiently

Struggling with Excel formulas can turn simple tasks into time-consuming challenges, leaving you frustrated and behind on work. Fortunately, a

May 20, 2014

Create Hyperlinked List of Files in Subfolders

I wrote a macro a few weeks ago which created a list of files with hyperlinks to those files, but

May 14, 2014

Interactive Excel Web App Dashboard

Warning: this is a long post. Get supplies so you don’t dehydrate or suffer from low blood sugar levels before

May 6, 2014

Is Your Line Chart Lying?

Charts are great at revealing trends, patterns and relationships in your data. We love how they enable us to glean

April 29, 2014

Conditional Formatting PivotTables

Conditional Formatting in PivotTables has its ups and downs. Unfortunately I find them mostly ‘downs’ but let’s not dwell on

April 22, 2014

Excel Chart Templates

If you find yourself repeatedly spending a few minutes customising your chart colours, formatting the title, legend, axis labels etc.

April 16, 2014

Create Hyperlinked List of Files in a Folder Using VBA

So you have a load of PDF's, or scanned documents, or some nice pictures of your stamp collection*, and you

April 9, 2014

Macro Enabled Excel Templates

What You Can Do With Macro Enabled Templates This is up to you. Using a template allows you to design

April 9, 2014

Trusted Locations

If you want Excel to stop asking you if you want to enable macros every time you open a macro

April 1, 2014

Unhide Multiple Worksheets in Excel

I’m sure most of us have experienced frustration at Excel’s refusal to allow us to unhide multiple worksheets. This is

April 1, 2014

Create a Personal Macro Workbook PERSONAL.XLSB

When you create a macro in Excel, by default, the macro works only in the workbook that contains it. But

March 25, 2014

Display Missing Dates in Excel PivotTables

Q: How do you get the PivotTable to show the missing dates in your data? A: Not as easily as

March 21, 2014

Excel Custom Number Formats

One of the most useful features in Excel are custom number formats yet they remain largely underused. In my Excel

March 12, 2014

Excel 3D Financial Reports

Last week I wrote about how I used Excel to design a Minecraft cake. The response to that post was

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.