Blog • Page 10 of 24 • My Online Training Hub

January 24, 2019

Numbering Grouped Data in Power Query

Numbering items within grouped data is easy with an Excel COUNTIF formula, but numbering grouped data in Power Query requires

January 15, 2019

VBA Like Operator

The VBA Like operator allows you to compare strings against a pattern. You can search a string to check if

January 8, 2019

Excel Sorted Dynamic Unique List

I really wanted the title of this post to be “Excel Sorted Dynamic Unique List Ignoring Blanks and Errors”, but

December 13, 2018

Play Audio and Video in Excel

We've had a few forum questions recently asking how to play audio files in Excel. Normally I'd just use my

December 6, 2018

Excel Dynamic Arrays

If you’re familiar with array formulas, then the simplicity of Excel Dynamic Arrays will be a breath of fresh air.

November 30, 2018

Save Chart as Image

You might want to save your charts as images that can then be used in other applications, like email or

November 22, 2018

Quickly Formatting Markers for Dot Plots

Mynda wrote a post about line charts vs dot plots where one of the steps in setting up the dot

November 15, 2018

Excel Power Query Pivot Chart

The options in the Pivot Chart library are limited, which you’ll know if you’ve ever tried to create a Scatter

November 8, 2018

Excel Scatter Pivot Chart

Ok, that title is a lie. There’s no such thing as an Excel Scatter Pivot Chart. It’s like mixing water

November 1, 2018

Excel Line Charts vs Dot Plot

A common chart mistake is to use a line chart for the wrong type of data. An example of that

October 24, 2018

Web Scraping Multiple Pages from Websites

My last post looked at web scraping using VBA, where I loaded a single page and extracted content. In this

October 17, 2018

Web Scraping With VBA

We can use VBA to retrieve webpages and comb through those pages for data we want. This is known as

October 11, 2018

Hide Blanks in Excel PivotTables

There are a couple of ways you can hide blanks in Excel PivotTables. To be clear, the ‘blanks’ I’m referring

October 2, 2018

Excel Data Types

AI powered Excel Data Types will transform the way we work with Excel by enabling a cell to contain much

September 27, 2018

Excel Threaded Comments

There is a new style of comment available in Excel for Office 365 users*. They’re technically called Threaded Comments, but

September 19, 2018

Remove Formatting from a Table

Let's say you have a range that you want to convert to a table Something like this that has fills,

September 11, 2018

Listing and Deleting Custom Styles

If you end up with a workbook that contains custom styles, removing all of these may be a pain depending

September 4, 2018

Excel Hash Interactive Bug Menu

Excel Hash is an Excel competition dreamed up by fellow Excel MVP, Oz du Soleil. It’s based on the popular

August 31, 2018

Using SUBSTITUTE Function to Find and Count Text

The SUBSTITUTE function allows you to change text in a string, or a range of strings, but there is more

August 21, 2018

Excel Chart Titles

Excel Chart titles are often a wasted opportunity to connect with your audience and drive home your message. So, let’s

August 14, 2018

Excel Analyze Data

Understanding your data and creating Excel charts has never been easier with Excel's Analyze Data (previously known as Excel Ideas

August 8, 2018

Excel Waterfall Charts

Excel Waterfall charts are now available to Office 365 users via the Insert > Charts menu. It makes light work

August 2, 2018

Real Time Data Add-In for Excel

Last week I looked at getting real time data into Power BI using PubNub. This week I want to take

July 27, 2018

Real Time Data in Power BI Using PubNub

In this post I'm going to look at getting real time data (RTD) into Power BI using a real time

July 19, 2018

Excel Functions Translator

It’s often difficult enough to figure out the correct Excel functions to use, but it’s significantly harder if you also

July 13, 2018

Using Azure Machine Learning in Excel

In this post I'm going to look at how you can create an Azure Machine Learning experiment to predict diamond

calling vba in an add-in from another vba module

July 3, 2018

Calling VBA in an Add-In From Other VBA Modules

If you've written subs or functions in your own add-in, you can use them in your worksheet as you would

June 25, 2018

Excel Slicer Formatting

Excel Slicers are great, but they’re a bit on the chunky side and that can be a pain when you’re

June 19, 2018

Power Query Consolidate Excel Sheets

Splitting data over multiple sheets is perhaps one of the worst Excel crimes I see. It’s a crime because it

June 12, 2018

Excel Power Query Add Column from Example

The Power Query Add Column from Example feature simplifies a task many of us perform daily. For example, how often