July 25, 2023
Write Excel Office Scripts with ChatGPT
Excel Office Scripts: The Future of Automation, Replacing VBA Excel Office Scripts have ushered in a new era of automation,
Read More
July 18, 2023
Get Started with Power Query
Efficiencies gained from Power Query can be life changing. I’m not exaggerating. Power Query can reduce time spent gathering and
Read More
July 13, 2023
Excel Date and Time
Everything you need to know about how Excel handles date and time and all the tools you will need. Read
Read More
July 11, 2023
Pro Excel Chart Formatting
Charts provide a visual representation of data, making it easier to understand and interpret large amounts of information quickly. At
Read More
July 6, 2023
12 PivotTable Formatting Tips
One of the downsides of PivotTables is they have a very distinctive look. Some might even say they’re ugly. In
Read More
June 27, 2023
Images in Excel PivotTables
With Microsoft 365 we can now include images in Excel PivotTables, as well as built in data types like Stock
Read More
June 20, 2023
Center Across Selection Macro
Annoyingly, there’s a shortcut for Merge & Center on the Ribbon, but nothing for Center Across Selection which is far
Read More
June 13, 2023
Excel Scroll and Sort Table
Dashboards have limited space which is why an Excel scroll and sort table is super handy. Scroll and sort tables
Read More
June 6, 2023
10 Mistakes to Avoid With Excel Formatting
Excel Formatting Best Practices Proper use of Excel formatting can significantly impact the speed and clarity in which users can
Read More
May 30, 2023
Excel Formula by Example
Excel can now write formulas for you. Simply give it an example or two and it’ll suggest a formula to
Read More
May 9, 2023
Excel Linear Regression
Excel linear regression is easy with the built-in tools. In this tutorial, we'll explore what linear regression is, why it's
Read More
May 2, 2023
How to Improve Excel Performance
Do you find yourself frustrated by sluggish Excel files that take forever to load or recalculate? If so, you're not
Read More
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