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

January 6, 2022

5 Excel SUM Function Tricks

I know you’re probably thinking that everyone knows how to use the SUM function, but I’m willing to bet that

November 25, 2021

Toggle Top N with Slicers

Power Pivot course member, Peter, asked if it was possible to toggle the top n with a Slicer for a

November 18, 2021

Interactive Personal Finance Dashboard

Manage and monitor where your money goes with this personal finance dashboard. Even if you’re not interested in building your

October 21, 2021

Hash Sign in Excel Formulas

If you’ve worked with dynamic array formulas*, you’ll have noticed that they’re able to spill the results to multiple cells.

September 30, 2021

10 Common Excel Mistakes to Avoid

I’ve received a lot of Excel files from our members over the years and I see the same mistakes time

September 16, 2021

Cool New Features in Excel for Microsoft 365

In this tutorial I’m going to highlight some cool new Excel features that might have slipped under your radar, a

August 26, 2021

Dynamic Dependent Data Validation

Before we had the luxury of dynamic array functions, creating dependent data validation lists typically required using multiple tables and

July 22, 2021

Auto Refresh PivotTables

In this tutorial we’re going to look at the options we have available to auto refresh PivotTables in Excel without

July 15, 2021

Power Pivot Running Total

In this tutorial we’ll look at how to create a Power Pivot running total that allows you to see the

July 8, 2021

Secret Power Query Function List

Hidden inside both Excel and Power BI is a secret Power Query function list that you can bring up while

June 16, 2021

Show Items with no Data in PivotTables

Show Items with no Data in PivotTables is a handy setting that allows you to show items in the PivotTable

May 20, 2021

Non-financial Excel Dashboards

Dashboards give a visual snapshot of your business performance. They typically show data spread over time and grouped by category.

May 5, 2021

Share and Collaborate in Excel

We’ve been able to share and collaborate in Excel files simultaneously with our co-workers for quite some time. However, recently

April 27, 2021

Secrets to Building Excel Dashboards in Under 15 Minutes

Building Excel Dashboards doesn't need to be a slow process. When your data is structured correctly you can use the

April 21, 2021

Power BI Organizational Data Types in Excel

UPDATE: Organization Data Types will be retired in Microsoft Excel effective July 31, 2025. Instead, we recommend customers switch to

April 7, 2021

Excel Workbook Protection

When you spend days crafting your latest report, the last thing you need are well meaning users messing with your

March 25, 2021

Change Type Using Locale with Power Query

One of the most common issues I help people fix is data imported to Excel or Power BI using Power

March 18, 2021

Get Data from OneDrive or SharePoint with Power Query

Nowadays many of us are saving our files to the cloud using OneDrive for Business or SharePoint Online. Unfortunately, it’s

March 4, 2021

Recursive LAMBDA Functions

The new Excel LAMBDA function that we looked at last week also enables us to write custom recursive LAMBDA functions.

February 25, 2021

Excel LAMBDA Function

The new Excel LAMBDA function allows you to define your own custom functions using Excel’s familiar formula language. That means

February 11, 2021

Excel Pyramid Charts

Excel pyramid charts are easy to build using bar charts or Conditional Formatting, but there are a few rules you

February 4, 2021

Personal Stock Portfolio Dashboard

Keeping track of your share trading is easy with this personal stock portfolio dashboard. It uses the latest Excel tools*

January 21, 2021

Highlighting Periods in Excel Charts

Shading or highlighting periods in Excel charts can help users more quickly interpret them and identify patterns. In the chart

December 10, 2020

Stacked Bar Excel Waffle Charts

Last week we looked at building Excel waffle charts using Conditional Formatting. This week we’re looking at building Stacked Bar

December 3, 2020

Excel Waffle Charts with Conditional Formatting

Excel Waffle Charts are a popular way to visually display parts to a whole. You can think of them as

November 19, 2020

Force Excel Slicers to Single Select

There’s no built-in way we can force Excel Slicers to single select, but we can use some crafty tricks to

November 10, 2020

Excel Dashboards vs Power BI Dashboards

One of the most common questions I get is: Should I be using Power BI to build dashboards instead of

November 3, 2020

How to Build Power BI Dashboards

Demand for data visualisation skills is showing no signs of slowing. There are many BI tools available, and this can

October 15, 2020

Introduction to Power Query

What’s the big deal about Power Query? Talk to those who have used it and they’ll tell you how amazing

October 1, 2020

Power Query Custom Data Types

You may already be familiar with Excel Data Types for geography and stocks, but with Power Query Custom Data types