February 6, 2024
10 Excel Productivity Tips for Work
Ever felt like you're spending hours on tasks in Excel that should take minutes? You're not alone. These are my
Read More
January 30, 2024
QR Codes in Excel
Using Excel as a QR Code Generator is quick, easy, and free. 20 years after the first scanning of the
Read More
December 4, 2023
Excel Checkboxes In Cells
New in October 2023, Microsoft introduced Excel checkboxes embedded directly within cells*. This enhancement is set to streamline data interaction
Read More
November 20, 2023
Slicers for Excel Tables
Slicers enable you to quickly and easily toggle filters on and off. They're best known for working with PivotTables, but
Read More
November 7, 2023
Descriptive Statistics in Excel
Descriptive statistics enable you to summarize, organize, and simplify large datasets to derive meaningful patterns and insights. For a long
Read More
September 5, 2023
Built-in Excel AI Tools
Excel has a load of AI tools already built-in that we can use to improve productivity and make our lives
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
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 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 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 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
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
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
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
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 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
September 30, 2021
10 Common Excel Mistakes to Avoid
I’ve received a lot of Excel files from our members over the years and I see the same mistakes time
Read More
September 16, 2021
Cool New Features in Excel for Microsoft 365
In this tutorial I’m going to highlight some cool new Excel features that might have slipped under your radar, a
Read More
August 26, 2021
Dynamic Dependent Data Validation
Before we had the luxury of dynamic array functions, creating dependent data validation lists typically required using multiple tables and
Read More
May 5, 2021
Share and Collaborate in Excel
We’ve been able to share and collaborate in Excel files simultaneously with our co-workers for quite some time. However, recently
Read More
April 7, 2021
Excel Workbook Protection
When you spend days crafting your latest report, the last thing you need are well meaning users messing with your
Read More
September 17, 2020
Excel Custom Number Format Conditions
Custom number format conditions allow you to specify a different format based on the size of a number. In this
Read More
August 27, 2020
Import Data from a Picture to Excel Mobile
A new feature in the Excel mobile app (iPhone and Android) is the ability to take a photo of your
Read More
May 13, 2020
Gather Data with Excel Forms
Excel Forms are super useful if you collate data manually, for example via email or PDF forms. Or even if
Read More
April 30, 2020
Visio for Excel Free Add-in
Office 365 users now have access to the Visio for Excel free add-in enabling you to create Excel flow charts
Read More
April 9, 2020
Searchable Drop Down List in Excel
Creating this searchable drop down list in Excel is so easy I’m wondering why I never thought of it before.
Read More
March 5, 2020
20 Pro Excel Keyboard Shortcuts
This post contains 20 Excel keyboard shortcuts used by Excel pros. I’m not talking about CTRL+Z, and the like, these
Read More
December 11, 2019
Excel Hash 2019 – Dynamic Playoffs Table
Excel Hash is an Excel competition dreamed up by fellow Excel MVP, Oz du Soleil. It’s based on the popular
Read More