Blog • Page 14 of 24 • My Online Training Hub

Clearing Downstream Dependent Data Validation Lists

August 25, 2016

Clear Downstream Dependent Data Validation Lists

Following on from Mynda's post last week on Dependent Data Validation, I've written a little VBA that enhances the functionality.

August 16, 2016

Excel Dependent Data Validation

I’ve written about how to create dependent data validation lists before here; Excel Data Validation with dependent lists, and here;

August 11, 2016

Slicer Controlled Interactive Excel Charts

Slicers are a great tool for easily filtering PivotTables and Pivot Charts, but what if you want to use a

August 3, 2016

Excel Chart Colors

I was reading a health magazine last week and the chart below caught my eye. click image to enlarge (sorry

July 28, 2016

Moving VBA Code and Forms Into PERSONAL.XLSB

After you’ve written some VBA, or created your own form, or you’ve found some useful code on the internet, you

Hide, Delete, Sort Sheets with VBA in Excel

July 21, 2016

Hide, Delete and Sort Sheets With VBA Userform

You have a workbook with lots of sheets and you want to do things like hide sheets, delete some sheets

July 12, 2016

Excel Clipboard

The Excel Clipboard is an extremely useful tool that’s very well hidden. Most of us are familiar with being able

July 5, 2016

Create Regular Excel Charts from PivotTables

PivotTables are a great way to summarise your data, but PivotCharts can be a pain in the, um, neck. PivotChart

June 30, 2016

How to Record a Macro in Excel

Prompted by a couple of questions on our Excel forum I thought I'd write about how to record a macro

June 22, 2016

Power Pivot does VLOOKUP

If you use Excel PivotTables then you’re probably familiar with the need to consolidate data from multiple tables into a

June 15, 2016

Excel Status Bar

In my previous blog post I created a progress bar using a userform. We can use this progress bar to

June 9, 2016

Excel Progress Bar for VBA

If your code runs for any noticeable amount of time, you might find that using some sort of visual feedback

June 1, 2016

Excel Power Query VLOOKUP

Since VLOOKUP is one of the most popular Excel functions it makes sense that one of the first things you

May 25, 2016

Power Query and Power Pivot Definitive Guide

One of the most common questions I get is, what’s the difference between Power Query and Power Pivot and when

May 18, 2016

Parts to a Whole Excel Charts

For many people when they think of a chart that shows parts to a whole, a pie chart is the

May 10, 2016

Interactive Excel Charts

Using interactive Excel charts in your dashboards and reports allows the user to pick and choose what they want to

May 3, 2016

Excel CHOOSE Function Toggle

At first glance the CHOOSE function isn’t very exciting and typically you have to team it up with other functions

April 27, 2016

Maximize Excel Across Multiple Screens

If you want to maximise Excel on a single monitor you can just click on the maximize button That's ok

April 19, 2016

Excel MROUND Function

Excel MROUND function is perfect for rounding numbers to the nearest multiple. For example, last week Brenda said she was

April 11, 2016

Classic PivotTable Default Layout

In Excel 2007 Microsoft thought they’d get clever and impose nested row labels in our PivotTables: If you’re a PivotTable

April 11, 2016

Excel PivotTable Default to SUM instead of COUNT

If you put a field in the values area of a PivotTable and it defaults to COUNT as opposed to

show text, numbers, dates, formulas on sheet

April 6, 2016

Highlight Text, Numbers, Dates and Formulas on a Sheet

Imagine that you are preparing data for a pivot table, and you want to make sure that all the cells

March 29, 2016

Excel Compare Two Lists

A common task in Excel is to compare two lists to identify which items are duplicates, different or missing from

March 21, 2016

Avoid Writing Complex Excel Formulas

There comes a time in many Excel users’ careers where we start to write incredibly complex Excel formulas to summarise

March 15, 2016

Get Started With VBA – 3 Easy Examples

You can create very complicated and powerful VBA routines in Excel, but not all VBA code has to be like

selecting multiple items in data validation list

March 3, 2016

Populating Multiple Cells from Single Data Validation (Drop Down) List

If you want to limit the choices available for the values that can be entered into a cell, you could

February 23, 2016

Excel Alternatives to Radar Charts

I get the fanfare around infographics. They’re used to make information more appealing, grab attention, awaken interest, lessen boredom and

February 17, 2016

Excel Dynamic Text Labels

I use Dynamic Text Labels all the time, whether it’s in a Dashboard report or chart title, and even to

February 9, 2016

Power Query Reformats Ugliest Report Ever

In this tutorial we're going to reformat Excel reports with Power Query. Why? Because external systems can create some pretty

February 1, 2016

Power Query Version Compatibility and Installation

When you know what Power Query is capable of you’ll want to get your hands on it immediately. It’s available