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

November 17, 2016

Excel COUNT MATCH Array Formula

Last week I received the following question from André: “I need a formula that will count how many values in

October 18, 2016

Excel IFS Function

This tutorial is applicable to Excel 2019 onward and with a Microsoft 365 license. In Excel 2019 there are a

October 18, 2016

Excel SWITCH Function

This tutorial is applicable to Excel 2019 onward. New in Excel 2019 is the SWITCH function. It looks up a

October 14, 2016

Excel Expression Definition

A couple of days ago I sent out a survey about the name of an argument in one of the

October 7, 2016

When to say No to Excel Nested IFs

In Excel 2007, Microsoft thought it would be a good idea to increase the number of times you can nest

September 28, 2016

Excel Styles

Using Excel Styles in your workbooks can not only make formatting them quicker and easier, but also result in more

September 7, 2016

Excel PivotTable Show Values As

The Excel PivotTable Show Values As menu has a load of handy instant calculations you can use. For example you

September 1, 2016

Excel Table Running Total Formula

There are a few ways to approach a running total formula, but Excel Tables require something special, or you're likely

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

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

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

January 27, 2016

Transpose Data in Excel

There are 3 ways you can transpose data in Excel (not including VBA). Download the workbook and follow along Enter

January 20, 2016

Excel Multi-cell Array Formulas

Excel Multi-cell array formulas are a single formula which returns multiple values and is entered into multiple cells. Hence ‘multi’