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
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
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 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
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
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
Read More
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.
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 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
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