April 15, 2025
New Excel Functions for Accountants
Microsoft has recently released a set of game-changing Excel functions that would’ve been a dream come true back in my
Read More
March 25, 2025
Excel Goal Seek
Have you ever tried to tweak numbers in Excel manually to find the right value? Whether it’s figuring out how
Read More
March 4, 2025
The Best Excel Functions for Dynamic References
Imagine you've built an Excel report, and everything looks great. But when you add data for the next month, your
Read More
February 25, 2025
Extract Data from One Sheet to Another
Extracting subsets of data from large datasets is crucial for making informed decisions. However, manually filtering data can be time-consuming,
Read More
February 11, 2025
Excel MOD Function
If like me, you probably never thought you'd use modular arithmetic once leaving high school. Surprisingly, Excel's MOD function brings
Read More
January 28, 2025
Excel Formula Race
When working with large datasets in Excel, some functions and formulas can seriously impact calculation speed. I ran an Excel
Read More
October 21, 2024
Excel TRIMRANGE Function
Get ready for an exciting update - Microsoft have released new features in the beta version of Excel* with the
Read More
October 15, 2024
Excel Formula Checklist
Various studies report that nearly 9/10 spreadsheets contain errors, with the majority a result of human error relating to formulas.
Read More
June 4, 2024
List File Names in a Folder in Excel
Ever heard of the Excel FILES function? If you haven't, you're not alone. This little-known function can list all file
Read More
May 22, 2024
Excel REGEX Functions
Parsing text in Excel with functions like FIND, MID, and SUBSTITUTE can be cumbersome and inefficient, especially for complex tasks.
Read More
April 9, 2024
Modern Excel Functions
These days, knowing basic Excel won't set you apart. You have to keep up with new features that enable you
Read More
January 9, 2024
Excel GROUPBY and PIVOTBY Functions
The GROUPBY and PIVOTBY functions are a significant breakthrough in Excel's toolbox of functions. They let you easily group or
Read More
December 12, 2023
Excel LABS.GENERATIVEAI Function
With AI gradually making its way into every aspect of our lives, working in Excel has become much easier. You
Read More
October 3, 2023
Excel SUMPRODUCT Function
The SUMPRODUCT function is one of Excel's most versatile functions. But now that we have SUMIFS, COUNTIFS, AVERAGEIFS etc. it’s
Read More
September 26, 2023
Excel Formulas to Summarise Monthly Data into Quarters
Back in my accounting days I regularly prepared reports that summarized monthly data into quarters. Back then, we used the
Read More
September 17, 2023
Excel BYCOL and BYROW Functions
Excel BYCOL and BYROW functions fundamentally change the way we write formulas that calculate across columns and down rows. They
Read More
August 22, 2023
How to Use Python in Excel Natively
You can now use Python in Excel natively! Python runs securely in the cloud, and we write Python in Excel
Read More
August 15, 2023
Excel Dynamic Named Ranges
Excel dynamic named ranges bring flexibility and efficiency to your spreadsheets. Unlike static named ranges, dynamic named ranges automatically adjust
Read More
August 8, 2023
Excel Functions for Financial Modeling
Excel functions are the backbone of a financial modeler’s day to day work and as such, it’s essential to have
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
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
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
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 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
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
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