Blog • Page 16 of 24 • My Online Training Hub

July 28, 2015

Excel PivotTable Calculated Items by Position

A while back I wrote about how to create Excel PivotTable Calculated Items using the conventional approach of referencing the

July 23, 2015

Excel Sparklines

Put some spark in your chart! Excel Sparklines were introduced in Excel 2010 and are great for displaying the trend

July 9, 2015

Excel Form Data Validation

When creating Excel userforms it seems like a good idea to check the data going into the form before adding

July 9, 2015

Excel Date Picker

In my previous post about Excel forms the date picker I used was a 32 bit ActiveX control. If mentioning

July 2, 2015

Excel Forms

Excel forms, or Userforms, can be used to collect information from a user, validate it, then enter that data into

June 23, 2015

Excel Named Range Shortcut

An Excel Named Range is a powerful tool and something we should all be using to make our formulas quick

June 17, 2015

Apps for Office In Excel

I want to be clear that when I say apps for Office in Excel, what I am talking about are

June 9, 2015

Customize Default Excel Workbook

Did you know that when Excel opens a new workbook it uses a template called ‘Book’ to create the new

June 2, 2015

Excel Fill Value Down Rows based on Criteria

A few weeks ago one of our members, Kylie, sent me this question: “How can I fill column E

May 26, 2015

Pivot Charts

I’ve always thought after inserting a PivotTable that Excel should ask “would you like a PivotChart with that?”. I think

Highlight Selected Cell In Excel and Preserve Cell Format

May 20, 2015

Highlight Selected Cells in Excel and Preserve Cell Formatting

When you select a cell, or cells, in Excel, the row and column headers change color to indicate what you

May 12, 2015

Excel PivotTable Calculated Items

Inserting Excel PivotTable Calculated Items is a great way to analyse your data and automatically incorporate that analysis in your

May 6, 2015

Excel Slicers for Fiscal Years

There’s no built-in way to create Excel Slicers for fiscal years, however the solution is easily achieved by adding an

May 6, 2015

Excel Slicers for Rolling Periods

Excel Slicers for rolling periods, for example; the last 12 months, requires a column in your source data that looks

April 28, 2015

Create a Single Excel Slicer for Year and Month

In this tutorial we’re going to look at how we can create a single Excel Slicer for Year and Month,

April 20, 2015

Excel Worksheet Protection

Excel worksheet protection is a great way to prevent people accidentally messing up the reports you’ve spent hours creating. However,

April 14, 2015

Excel Chart Vertical Axis Text Labels

In this tutorial we’re going to look at how we can twist Excel’s arm into putting text labels on the

April 1, 2015

Charting Variances in Excel

In my previous life as an accountant one of my main tasks was to analyse budget vs actual variances and

March 30, 2015

Pausing or Delaying VBA Using Wait, Sleep or A Loop

You may want some way of pausing or delaying VBA code execution and you can do this with two functions

March 24, 2015

Excel Quick Analysis

A new feature in Excel 2013 is called Quick Analysis – it’s data analysis made easy, so easy my 6

March 17, 2015

Give me a SIGN, Excel

The Excel SIGN function returns a 1 if the number is positive, a zero if it’s zero and a -1

March 10, 2015

Excel Filters 4 Ways

Filters are one of my most used Excel tools. They’re not fancy, but they sure do earn their keep. I’ve

March 4, 2015

Excel PivotTable FAQ’s

After having thousands of people recently attend our free PivotTable webinar we found there were 3 questions that were asked

Excel PivotTable Expand and Collapse options

February 25, 2015

Excel PivotTable Expand, Collapse and Show Details

Excel PivotTables are a treasure trove of features. One of my favourites is the ability to expand/collapse and drill down

February 19, 2015

Find Missing Numbers, Really Fast

A while ago I wrote a routine using the .Find method to find missing numbers in a sequence. So if

February 4, 2015

Excel PivotTable Calculated Fields

Excel PivotTable Calculated Fields are easy to add but there are a couple of ‘gotchas’ you should be aware of.

January 28, 2015

Skip Dates in Excel Chart Axis

In this tutorial we're going to look at how we can skip dates in the Excel chart axis for those

January 19, 2015

Excel Custom AutoFilter with Wildcards

Excel’s Custom AutoFilter can perform a myriad of tasks that are often overlooked. Just last week we had a question

January 5, 2015

Excel Custom Chart Labels

Using Excel custom chart labels is a great way to create a more insightful chart without having to show a

December 2, 2014

Excel Find Tool

You’ll be Amazed at what you can CTRL+F in Excel Excel’s Find tool is one of the first features you’re