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…
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,…
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…
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…
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…
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…
Remove spaces in Excel cell before and after text
Need to learn how to quickly remove spaces in Excel? Extra spaces can appear in your worksheet for lots of different reasons…
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…
Remove spaces Excel TRIM function misses
Want to learn how to remove spaces in Excel that even the TRIM function can’t get rid of? Here are two easy…
Excel – Using VLOOKUP to compare two lists
If you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two…
Excel – How do I merge cells within a range that is formatted as a Table?
Question: When I use Excel “Format as Table” to format a range, the Merge & Center button is greyed out and becomes…