April 20, 2023
Project Management Dashboard Dynamic Periods
One of my most popular tutorials has been my Excel Project Management dashboard with nearly 2M views to date. However,
Read More
April 5, 2023
Securely Share Excel Files
In today's world, where remote work has become increasingly common, the need to securely share files with multiple people has
Read More
March 30, 2023
Interactive Excel Check Boxes
Excel check boxes are a type of form control that can be added to a spreadsheet with just a few
Read More
March 23, 2023
Power Query if Statements incl. Nested ifs, if or, if and
Power Query if statements, nested if, 'if or' and 'if and' statements are a bit different to writing IF formulas
Read More
March 9, 2023
Hacks for Working in Multiple Excel Files
When working in multiple Excel files we can waste a lot of time flitting back and forth between them. In
Read More
March 2, 2023
Picture Fill Excel Charts
When building reports, it's important that people not only understand what you're saying but also remember it. Picture fill Excel
Read More
February 23, 2023
AI Aided Excel Formula Editor
Writing Excel formulas is one of the most important tasks to master in Excel, but it can be a mine
Read More
February 16, 2023
ChatGPT for Excel
Everyone’s talking about using ChatGPT for Excel and how it can improve your productivity with claims it’ll make you n
Read More
February 9, 2023
Excel Infographic Tools
In this tutorial I’m going to share with you some hidden Excel chart techniques that will make your reports stand
Read More
February 2, 2023
AI Dashboard Design
Designing dashboards and reports can be a time consuming task, particularly if you’re not artistically inclined. In 60 seconds, AI
Read More
January 26, 2023
Where to Find Free Excel Templates
Excel templates can save you time designing, setting up and standardising forms and reports. There are hundreds of free templates
Read More
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