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

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

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

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

June 6, 2018

Office 365 vs Perpetual Licences

From time to time I get asked which Microsoft Office licence* should I get; Office 365 subscription, or the one-time

May 16, 2018

Excel Mini Charts

Excel mini charts are a great alternative to Sparklines. Mini charts are just regular charts made really small. You might

May 8, 2018

Excel Multi-colored Line Charts

Excel multi-colored line charts are a little gimmicky, after all we don’t need color to tell if a line is

May 3, 2018

Excel 3D Maps

Excel 3D Maps in 2016, or Power Map as it’s known in Excel 2013, enable you to visualise data in,

April 25, 2018

Excel PivotTable Quick Explore

With PivotTable Quick Explore we can filter and drill down in PivotTables and Pivot Charts without the field list exposed.

April 4, 2018

Relative Named Ranges

Excel Named Ranges is a vast topic that includes some simple techniques that we all can and should use to

March 22, 2018

Excel ADDRESS Function

The Excel ADDRESS Function returns a cell address for specified row and column coordinates. Optional arguments allow you to specify

March 14, 2018

Excel Online PivotTables

Inserting PivotTables in Excel Online is now possible. It’s still in its infancy with many features you may be used