Blog • Page 16 of 24 • My Online Training Hub

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

November 25, 2014

Excel Advent Calendar

Today I’ve got a Christmas treat for you with an Excel Advent Calendar that Phil and I created. Before you

November 19, 2014

Workbook & Worksheet Events in Excel VBA

What Are Events? An Event occurs when certain actions are performed by the user or VBA. For example when you

November 12, 2014

My 2014 Microsoft MVP Summit Experience

I arrived back from the 2014 Microsoft MVP Summit in Seattle on Sunday a little tired but bounding with excitement

October 30, 2014

What the CELL!

Excel’s CELL function doesn’t get a lot of press but it can be handy to know. The CELL Function simply

October 20, 2014

Excel GETPIVOTDATA Function

In its simplest form the Excel GETPIVOTDATA function enables you to extract values from a PivotTable report, but if you’re

October 13, 2014

Excel Chart Makeover

Getting the formatting in your chart right can make the difference between clear, concise information and just a pretty picture.

October 6, 2014

Interactive Excel Formulas

Dynamic formulas are the cornerstone of interactive reports like dashboards. They enable our report recipients to interact with the data,

September 29, 2014

Excel Power Pivot Named Sets

Excel PivotTable Named Sets enable you to pick and choose which columns or rows you want included in your PivotTable