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

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

Power BI Organizational Data Types in Excel allow you to store attributes about your data in a single cell. This

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

September 17, 2020

Excel Custom Number Format Conditions

Custom number format conditions allow you to specify a different format based on the size of a number. In this

August 27, 2020

Import Data from a Picture to Excel Mobile

A new feature in the Excel mobile app (iPhone and Android) is the ability to take a photo of your

August 13, 2020

Import Data from a PDF to Excel

Office 365/Microsoft 365 users can now import data from a PDF to Excel using Power Query*. It’s super handy for

August 11, 2020

Plan v Actual Excel Dashboard

Reporting on plan v actual variances can be a very dry topic and often the audience for these reports are

July 30, 2020

Excel PivotTable Profit and Loss

Creating an Excel PivotTable Profit and Loss statement is surprisingly easy. And because it’s a PivotTable you can team it

July 16, 2020

Dynamically List Excel Sheet Names

Navigating workbooks with lots of sheets can be tedious. In this tutorial I’m going to show you how to dynamically

July 9, 2020

Label Specific Excel Chart Axis Dates

When you have data that spans a long period of time that you want to plot in a chart, the

June 25, 2020

Excel Functions that Return References

Using a formula to return a reference to a range of cells allows us to generate a reference on the

June 18, 2020

Excel STOCKHISTORY Function

With the new Excel STOCKHISTORY function we can finally get historical price data for stocks, bonds, funds, crypto and foreign

5 Secret Features of the Excel INDEX Function

June 11, 2020

5 Excel INDEX Function Secrets

The Excel INDEX function is a treasure trove of functionality, but most of us only know one way to use

May 13, 2020

Gather Data with Excel Forms

Excel Forms are super useful if you collate data manually, for example via email or PDF forms. Or even if

April 30, 2020

Visio for Excel Free Add-in

Office 365 users now have access to the Visio for Excel free add-in enabling you to create Excel flow charts

April 16, 2020

Excel LET Function

The Excel LET function* enables you to declare variables and intermediate calculations inside of a formula. It’s like the DAX