Blog • Page 5 of 24 • My Online Training Hub

excel nested if functions what not to do

September 22, 2022

Excel IF Formulas and What Not To Do

We can learn a lot from looking at what others do in Excel, both the good and the not so

September 8, 2022

Excel IMAGE Function

The new Excel IMAGE function enables you to insert images into cells with a formula. From there you can resize

September 1, 2022

Excel VSTACK and HSTACK Functions

Excel VSTACK and HSTACK functions are just two of a raft of new text manipulation functions available to Microsoft 365

August 25, 2022

Excel S-Curve Charts

S-curve charts are a common tool used in project management to track the cumulative costs, hours, sales etc. over time.

Easily Remove Password Protection from Excel Files

August 11, 2022

Easily Remove Excel Password Protection

In most cases you can easily remove Excel password protection if you’ve forgotten the password. However, the likelihood of your

August 4, 2022

Power Query Variables 3 Ways

Power Query variables are a great way to store data that can be used multiple times and can be easily

July 28, 2022

Import Data from a Picture to Excel

New to Windows is the ability to import data from a picture to Excel*. No more typing data manually into

July 21, 2022

Identify overlapping dates and times in Excel

I often get asked how to identify overlapping dates and times in Excel. Excel doesn’t have an ‘overlap’ function, but

July 14, 2022

5 Excel Online Features Better than Desktop

Microsoft are massively investing in Excel Online and as a result there are some features that are now better than

June 2, 2022

Custom Tooltips in Power BI

When you hover your mouse over an element in a visual, like a column in a clustered column chart, a

May 26, 2022

Embedding Excel Dashboards in a Web Page

Embedding Excel dashboards in a web page is a great way to securely share reports. All you need to do

conditional formatting tables and matrices in power bi

May 19, 2022

Conditional Formatting in Power BI Tables and Matrices

Conditional formatting in Power BI visuals allows you to draw attention to, or highlight, data in text or numeric fields

May 9, 2022

Excel Student Performance Dashboard

I've used a range of techniques to build the interactive Excel student performance dashboard below, which are covered in the

delete empty rows and columns using power query

April 21, 2022

Remove Blank Rows and Columns from Tables in Power Query

When you import data to Power Query, it's not unusual to end up with a table containing blank rows and

extracting data from lists and records in power query

April 7, 2022

Extracting Data from Nested Lists and Records in Power Query

You may have data that is contained in lists or records, or even lists inside records, or records inside lists.

March 31, 2022

TEXTSPLIT, TEXTBEFORE and TEXTAFTER Functions

It’s been a long wait, but we finally have some exciting new Excel text functions that are going to make

March 24, 2022

Excel Chart Axis Switch

When working with small multiple charts or panel charts as they’re also known, it’s handy to be able to switch

March 17, 2022

DAX Editor Keyboard Shortcuts

Writing DAX is hard enough. If there were some way to make the experience a little easier wouldn't that be

March 10, 2022

Top 10 Intermediate Excel Functions

Most Excel users know the basic functions like SUM, COUNT, AVERAGE etc. Therefore, in this tutorial I’m going to cover

March 3, 2022

Combine Files With Different Column Names in Power Query

I'm going to look at situations that appear to be fairly common: loading data into Power Query where the source

February 24, 2022

Automatically Email Reminders from Excel with Power Automate

We can automatically email reminders from Excel with Power Automate and there’s no programming required. You don’t even need to

February 10, 2022

5 Pro Excel Dashboard Design Tips

Design can make or break how well your dashboard communicates your message. Unfortunately, there are some common mistakes I see

February 3, 2022

Excel CUBE Functions

Some might say that Excel CUBE functions are the new PivotTables because they allow us to build reports based on

January 27, 2022

Excel Charts with Shapes for Infographics

You can create more interest and give your charts infographic styling when you create Excel charts with Shapes. There’s no

January 20, 2022

Fixing Incorrect Totals in DAX

Typically in Power BI visuals like a matrix or a table, and in pivot tables in Excel, we expect the

January 13, 2022

Introduction to DAX Measures

DAX is the Power Pivot formula language available in both Power BI and Excel. It stands for Data Analysis eXpression.

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

December 2, 2021

Power Query Keyboard Shortcuts to Save Time

Below is a list of time saving keyboard shortcuts that you can use in Power Query, in both Excel and

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