Mynda Treacy, Author at My Online Training Hub • Page 8 of 20

September 19, 2019

Excel Data Tables

Excel Data Tables are one of the What-if Analysis tools that we have available to aid our decision making. They

September 12, 2019

Excel CONCAT Function

The Excel CONCAT function, new in Excel 2019, replaces the legacy CONCATENATE function*. It’s a simple function that joins the

August 22, 2019

Segmented Survey Data Chart

Charting survey data can be tricky, and when you want a segmented survey data chart it adds another layer of

August 14, 2019

Year on Year Charts

Year on year charts or data over time is one of the most common data visualisations you’ll see. However, the

August 8, 2019

Excel Bar Chart with Vertical Line

In this post I’m going to show you a way to create an Excel bar chart with a vertical line.

July 16, 2019

Excel PivotTable Field List Tips

The Excel PivotTable field list automatically appears in the task pane on the right-hand side of the Excel window when

July 9, 2019

Referencing the Next Row in Power Query

Unlike Excel, referencing the next row in Power Query, or even the previous row, is not as simple as we

June 25, 2019

Excel Calendar Template Date Formulas Explained

There are many Excel Calendar templates available and if you look at them closely, you’ll see they have some mind-boggling

June 3, 2019

Excel Freeze Panes vs Split Panes

One of my bugbears is opening an Excel workbook that has Split Panes set when it should have Freeze Panes

May 21, 2019

Scrape Data from Multiple Web Pages with Power Query

Previously we looked at scraping data from the web by example, where the website paginated the data. That is, it

May 14, 2019

Power Query Get Data from Web by Example

Getting data from the web is possible with Power Query in both Excel and Power BI. However, Excel is a

May 6, 2019

Include Grand Totals in Pivot Charts

If you work with PivotTables, then you’ve probably found that you can’t include grand totals in Pivot Charts, or subtotals

April 16, 2019

Power Query Approximate Match VLOOKUP

A while ago I wrote about to how perform the equivalent of an Excel exact match VLOOKUP formula with Power

March 28, 2019

Get Data from the Web with Power Query

The ability to get data from the web with Power Query is super handy and Power Query’s user-friendly GUI makes

March 14, 2019

GETPIVOTDATA Function for Power Pivot

The GETPIVOTDATA function divides Excel users. You either love it or hate it, but there are good reasons for learning

March 7, 2019

Show Values as Percentage of Another PivotTable Column Total

Occasionally you may want to show values as percentage of another PivotTable column total. For example, below we want to

Change PivotTable Aggregation Methods using Excel Slicers

February 12, 2019

Change PivotChart Aggregation Methods using Excel Slicers

With disconnected tables in Power Pivot* we can change PivotChart aggregation methods using Excel Slicers. It allows us to create

January 30, 2019

Excel Five Star Rating Chart

Creating an Excel five star rating chart is easy with Conditional Formatting. They’re not limited to stars, you can also

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 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 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 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 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 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 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