January 19, 2023
Excel Speedometer Charts
Excel Speedometer charts or gauge charts as they’re also known, have a worse reputation in data visualization circles than the
Read More
January 12, 2023
Top Excel Functions for Data Analysts
A data analyst gathers, cleans, models, analyses, and interprets data. The gathering and cleaning should be done with Power Query.
Read More
December 15, 2022
Advanced Formula Environment
The Advanced Formula Environment (AFE) is part of the Excel Labs add-in and is still in its early stages of
Read More
November 30, 2022
Pro Excel Formula Writing Tips
Excel Formula Writing Tips, Tricks and Tools that will change how you work in Excel Formulas are THE MOST IMPORTANT
Read More
November 17, 2022
Dark Themed Excel Dashboards
If you’re going to build dark themed Excel dashboards, then you need to have some tricks up your sleeve in
Read More
November 10, 2022
Hidden Excel Double Click Shortcuts
Keyboard shortcuts are great, but there are also hidden Excel double click features and shortcuts available for mouse users. Which
Read More
November 3, 2022
Excel Project Management Burn Down and Burn Up Charts
Excel Burn Down and Burn Up Charts are easy to make with line or scatter charts. If you’re familiar with
Read More
October 27, 2022
Excel WeePeople Font Charts
Excel WeePeople font charts enable you to build interesting variations on waffle, bar and column charts, to name a few.
Read More
October 20, 2022
Excel Dot Map Charts
One of the things that makes Excel stand apart from other reporting tools is its immense flexibility. With some tinkering
Read More
October 6, 2022
New Array Shaping Excel Functions
Microsoft recently released 11 new Excel functions for shaping arrays (data). I already covered VSTACK and HSTACK which was super
Read More
September 29, 2022
Custom Excel Dashboard Backgrounds
Custom Excel dashboard backgrounds are super easy to create and can bring a level of polish and professionalism to your
Read More
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
Read More
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
Read More
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
Read More
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.
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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
Read More
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.
Read More