April 28, 2026
Advanced Conditional Formatting in Excel Using Formulas
Most Excel users stick to built-in conditional formatting rules. A colour scale here, a “greater than” rule there. But the
Read More
March 31, 2026
Excel Wildcards Explained
You might think you already know wildcards in Excel. Most people use them in COUNTIF or maybe XLOOKUP and stop
Read More
February 17, 2026
Using Curly Braces in Excel Formulas to Unlock Hidden Formula Power
Most Excel users are not aware that curly braces can be used inside functions like DATE, XLOOKUP, and SORT to
Read More
February 3, 2026
Excel IMPORTCSV and IMPORTTEXT Functions Explained
Microsoft Excel has introduced two powerful new functions that completely change how you can import CSV and text files into
Read More
January 27, 2026
Excel Functions That Will Transform Your Work
Excel has released a huge wave of new functions over the past couple of years. If you have not kept
Read More
August 19, 2025
Excel COPILOT Function
20% OffMicrosoft Copilot Essentials CourseClick Here -->> Excel is now a whole lot smarter. Imagine typing a plain-English question right
Read More
August 5, 2025
Excel LET Function
Have you ever written a long Excel formula that broke the moment you changed a single value? The LET function
Read More
June 17, 2025
Excel Table Absolute Structured References
Excel Tables are brilliant for structured data and dynamic formulas, but if you’ve ever copied a formula across columns and ended
Read More
June 10, 2025
Excel Formula Symbols
Ever seen strange symbols like #, @, { }, or ~ pop up in Excel formulas and wondered what they
Read More
June 3, 2025
Excel IF AND OR Functions Explained
Excel’s IF function is one of the most powerful tools in your spreadsheet arsenal. Combine it with AND or OR,
Read More
May 27, 2025
Excel SUM with OR Criteria
Ah, SUM - the first Excel function most of us learn. It’s great for adding up columns and rows, but what if
Read More
May 13, 2025
Outdated Excel Functions (and What to Use Instead)
Excel is always evolving, and so should your formulas. While classic functions like VLOOKUP, MATCH, and OFFSET were once essential,
Read More
April 29, 2025
How to Calculate Percentages in Excel
Ever Googled“how to calculate percentages in Excel”? You’re not alone. We all learned percentages in school — but Excel adds
Read More
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