Excel Essential Skills Blog Posts

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…

PROBLEM: why does the 0 (zero) disappear in Excel? How do I stop the 0 from disappearing? SOLUTION: learn how to stop zeros…

One of the most frequent requests I receive is to explain how to calculate GST (Goods and Services Tax) using Excel formulas….

Learn how to insert, delete and hide rows or columns in Excel. Once the basic worksheet is completed and tested, it may…

Learn how to copy a worksheet in Excel effortlessly. Duplicating a worksheet is a handy way to replicate your work while retaining…

Once you know how to enter data into an Excel worksheet, you will be setting up tables of data quickly. When you…

Welcome to the exciting world of Excel, your go-to tool for handling data with ease and precision! Our guide, “How to Enter…

“What skills do I need to say I’m proficient in Excel confidently?” It’s a common question, and being unsure of the answer…

Filters within Microsoft Excel are like magic wands as they allow you to sift through vast amounts of data effortlessly. But what…

Excel is famous for its impressive abilities, like handy shortcuts and user-friendly tricks. One of these gems is the Excel double-click feature…

Do you spend hours perfecting the format of a single cell in Excel, only to realise that you need the same formatting…

Have you ever been working in Excel, and your Formula Bar goes missing?! It can be a pain when your Formula Bar…