May 28, 2024
Data Analytics in Excel
In a world where data analytics is becoming the cornerstone of business decisions, the demand for skilled data analysts has
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
May 14, 2024
Data Visualization in Excel
Ever felt overwhelmed by a massive spreadsheet filled with data, wondering how to make sense of it all? In today's
Read More
May 7, 2024
Excel for Beginners
Excel is the key to unlocking limitless opportunities. It's a skill that can elevate your career, manage your finances like
Read More
April 30, 2024
Microsoft Word Formatting Tips
Ever felt held back with Word documents that just look too plain, almost like they're stuck in the past? You
Read More
April 16, 2024
Microsoft Copilot for Finance
Reconciliations, variance analysis and debtor management are time consuming tasks finance professionals juggle on a regular basis. But did you
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
March 26, 2024
Advanced Excel PivotTable Tips & Tricks
There's no denying PivotTables are time-savers! They're one of Excel's most powerful tools, but they have a lot of cool
Read More
March 19, 2024
Excel Skills Employers Want
Believe it or not, more than half the job listings across a wide range of industries identify Excel as an
Read More
March 12, 2024
Power BI Tutorial for Excel Users
Ever felt like you're wrestling with spreadsheets, trying to make sense of overwhelming data, only to end up with static
Read More
March 5, 2024
How to Clean Data in Excel
Sending out a report that contains errors is embarrassing. I know, I've done it! You present a report to management,
Read More
February 13, 2024
Interactive Excel Dashboards in 3 Steps
Excel Dashboards may appear intimidating at first glance, but by mastering three simple steps, you'll be crafting interactive dashboards like
Read More
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
January 23, 2024
Quick and Easy Data Analysis in 10 Minutes
In today's data-driven landscape, mastering the art of data analysis is an essential skill that can open doors. Join us
Read More
January 16, 2024
Excel + ChatGPT Integration to Solve Any Problem
No matter whether you're an Excel newbie or an expert, be prepared to revolutionize how you work in Excel with
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
January 2, 2024
Personal Budget in Excel
With the cost-of-living crisis affecting everyone, it's essential to get control of your finances. Having a personal budget can be
Read More
December 19, 2023
Copilot in Excel
Imagine having a tool that transforms the way you work, a tool so powerful it's valued at a minimum of
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
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 28, 2023
Import Data From Web to Excel
We now have a new, improved way to import data from the web to Excel. Just like in Power BI,
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
October 31, 2023
Custom Sort Excel Slicers
Slicers are a fantastic tool to get a filtered view of your data and visuals. But by default, they get
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
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
August 25, 2023
Interactive Python Charts in Excel
One of the best uses for Python in Excel is creating the amazing charts available through Python libraries like Seaborn
Read More