Excel Combine, Analyse, Report

Discover posts that introduce the more advanced features of Excel that assist you in referencing and reporting on large data lists.

Become super confident preparing data, creating reports and charts using these fabulous tools.

Excel Combine, Analyse, Report

How to Compare Two Lists in Excel Using XLOOKUP

If you’ve ever tried to compare two lists in Excel and ended up scrolling up and down, highlighting rows, and still feeling…

Read More How to Compare Two Lists in Excel Using XLOOKUP
Excel Combine, Analyse, Report

Excel SUBSTITUTE Function: Replace Text and Clean Up Data Easily

If you’ve ever found yourself spending far too much time fixing typos, updating codes, or cleaning up data in Excel, you’re not…

Read More Excel SUBSTITUTE Function: Replace Text and Clean Up Data Easily
Excel Combine, Analyse, Report

Trim Function Not Working in Excel? Fix It Without Formulas

Have you ever used the TRIM formula, pressed Enter, and nothing happened? If the Trim function isn’t working in Excel, you’re not…

Read More Trim Function Not Working in Excel? Fix It Without Formulas
Excel Combine, Analyse, Report

Use TRIM with SUBSTITUTE Function in Excel to Remove Spaces the TRIM Function Misses

Have you ever used the TRIM function in Excel, only to find that it didn’t remove all the spaces and isn’t working as…

Read More Use TRIM with SUBSTITUTE Function in Excel to Remove Spaces the TRIM Function Misses
Excel Combine, Analyse, Report

How to add 0 in front of a Number in Excel

Are you struggling to add 0 in front of a number in Excel, only to see it disappear? This is a common…

Read More How to add 0 in front of a Number in Excel
Excel Combine, Analyse, Report

How to Remove Space Before and After Text in Excel

Do you need to remove extra spaces in an Excel cell? Extra spaces can appear in your worksheet for many different reasons,…

Read More How to Remove Space Before and After Text in Excel
Excel Combine, Analyse, Report

5 Quick And SUPER EASY Ways To CLEAN DATA In EXCEL

Cleaning messy data in Excel is essential for accurate analysis and efficient workflow. Whether you’re dealing with extra spaces, incorrect formatting, or…

Read More 5 Quick And SUPER EASY Ways To CLEAN DATA In EXCEL
Excel Combine, Analyse, Report

Excel Filter Not Working? 5 Reasons Why

Excel filter not working? Don’t worry. I’ve got you covered! Filtering is a fantastic tool for analysing data, but it can be…

Read More Excel Filter Not Working? 5 Reasons Why
Excel Combine, Analyse, Report

Find and Delete Duplicate Rows in Excel

Unlocking the ability to find and delete duplicate rows in Excel is not just a time-saver; it’s a game-changer. However, it can…

Read More Find and Delete Duplicate Rows in Excel
Excel Combine, Analyse, Report

How to do a VLOOKUP with multiple criteria in Excel

There are times when you want to return a match for a VLOOKUP based on multiple criteria. For example, we may have customers…

Read More How to do a VLOOKUP with multiple criteria in Excel
Excel Combine, Analyse, Report

How Change Case in Excel

In this blog we will cover how to change the case of your text in Excel with or without a formula. If…

Read More How Change Case in Excel
Excel Combine, Analyse, Report

Excel – Using VLOOKUP to compare two lists

If you’re using Microsoft 365, XLOOKUP is now the better and more flexible option than VLOOKUP, and I highly recommend learning it…

Read More Excel – Using VLOOKUP to compare two lists