How to Create a List of Dates in Excel – Autofill Days, Weeks, Months, Years
Managing dates efficiently in Excel can significantly boost your productivity. In this blog post, I’ll show you how to create a list…
Excel – Why does the 0 (zero) disappear?
PROBLEM: why does the 0 (zero) disappear in Excel? How do I stop the 0 from disappearing? SOLUTION: learn how to stop zeros…
Quickly Fill Blank Cells With Value Above In Excel
In this blog, we will explore a simple and efficient method to fill blank cells with the value above in Excel. This…
How To Insert And Format Table Of Contents In Microsoft Word
Learning how to insert and format Table of Contents in Microsoft Word is a fantastic way to keep things organised and easy…
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 APPLY FILTER In EXCEL- Essential Skill
Filtering in Excel is a powerful tool that can help you manage and analyse your data more effectively. Imagine having a magic…
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…
How to Apply Multiple Filters to the Same Field in an Excel Pivot Table
Have you ever tried to apply multiple filters to the same field in a Pivot Table, only to find that your first…
How To Calculate GST Using Excel Formulas
One of the most frequent requests I receive is to explain how to calculate GST (Goods and Services Tax) using Excel formulas….
Insert or delete, Hide or Show rows and columns in Excel
Learn how to insert, delete and hide rows or columns in Excel. Once the basic worksheet is completed and tested, it may…