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
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
August 1, 2023
Excel Progress Circle Charts
Progress charts are a powerful way to track milestones and showcase achievements. However, there’s no built-in way to create Excel
Read More
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