Formula Archives

10 Essential Techniques on How to Enter Data in Excel

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

Excel round formulas are essential tools for achieving precision in spreadsheet calculations. They are vital to use to ensure accuracy. Excel, the…

When it comes to performing calculations and analysis in Excel, numerous functions can save you time and effort, one of which is…

If you’re an Excel user, you’ve probably encountered the dreaded #DIV/0 error at some point. This error occurs when you attempt to…

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

Being able to create a formula in Excel is fundamental to being able to use Excel well.Writing an Excel formula is much…

There are many areas within business reporting where we are looking for the average of a selection of results. A good example…

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

Are you wanting to learn how to subtract in Excel? First of all, if you are looking for the subtraction function in…

It can be frustrating when you’re trying to type a zero in front of a value or a number in Excel and…

Post updated 18 October 2019 by Sharyn Baines A common request I receive is to please explain how to calculate GST at…

If you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two…