Blog • Page 17 of 24 • My Online Training Hub

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

September 23, 2014

Change the Color of Words in Text

One of our students (hi Leah 🙂 ) sent me a question last week asking how she could change the

September 15, 2014

Excel Custom Data Validation to Limit Entries

In this tutorial we're going to look at how Santa is using Excel Custom Data Validation to limit the number

September 8, 2014

Excel Pivot Tables Year on Year Change

PivotTables are a treasure trove of features and one that has been brought out of the dungeons in more recent

September 1, 2014

Deleting Rows in Excel Containing Blanks Returned by Double Quotes

We should all be using Go To Special to quickly remove rows containing blanks, but if those blanks are returned

August 26, 2014

Text to Columns with an Excel Formula

If you reformat data brought into Excel from an external source regularly then you’ve most likely come across Excel’s Text

August 12, 2014

Excel Slicers – Everything You Need to Know

Excel Slicers are a professional way to enable users to easily and intuitively interact with your reports, filtering data in

August 5, 2014

Excel Formula to Spread Income or Costs Over Months

WARNING: this tutorial contains some advanced formula concepts which may incur the following side effects: Negative side effects: Headache, urge

July 22, 2014

Fix Excel Chart Axis with a Ghost Series

Below is a set of Panel Charts. In this case they’re actually 4 separate charts aligned close together. Comparing one

July 15, 2014

3 Steps to Easy Bullet Graphs in Excel

Bullet graphs were developed by data visualisation expert Stephen Few to address the need for visually rich displays of data

July 8, 2014

Excel Protect Ranges with Different Passwords

Did you know you can set different passwords to protect specific ranges of your Excel worksheets? It’s called Allow Users

June 18, 2014

Protect and Unprotect All Sheets in a Workbook

I recently had a client who has a requirement to protect and unprotect a lot of sheets. This was something

June 18, 2014

Customize the Ribbon in Excel

You can customize the Ribbon in Excel so that you add your own tabs and icons to run commonly used

June 16, 2014

Plot Excel Data on a Map

If you don’t have Excel 2013 then this post will be a bit like window shopping with an empty wallet.

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