Complete guide to Excel errors and useful tips and tricks

Excel Errors Explained

Excel Errors Explained

Getting errors in Excel? Error messages can be frustrating but they are also extremely useful. And thank goodness they are here. Imagine if we made a mistake and Excel does not tell us about it. We just need to understand what they mean.

Date and Time in Excel

Date and Time in Excel

Dealing with date and time in Excel does not require complicated formula (usually). But it can be tricky and sometimes you just can’t seem to get the right answer in the format you want. We can help you here.

Power Query

Power Query

Can you use Excel without power query? Yes. But can you use Power Query in Excel to simplify and automate any formatting and reporting processes that you do every week or every month? Answer is also yes. It is definitely worth spending time setting up Power Query.

Pivot Tables

Pivot Tables

Pivot Tables in Excel are useful when it comes to summarizing and analyzing a large amount of data. They are often used because they are easy to set up and edit. Pivot tables can help us look at large dataset in various different angles.

Read Our Articles


Using Check Boxes in Excel

Check boxes in Excel are a useful tool in creating checklists or to-do lists. They are simple to use. Everyone…


Calculating Working Days in Excel

In this article, we will examine how to work with and calculate working days in Excel. This includes calculating the…


What is 3D Range in Excel?

3D Range is a useful tool in Excel that makes it easier for us to collate data across different tabs.…

About Us

Excel is not easy to use for beginners. There's too much you can do with it. Too many different formulas. Data can be easily deleted. Cells can easily shift around. But Excel is very useful. It is definitely worth spending time learning how to use it. It is a useful skill and it is so widely used everywhere. My name is Harvey. I've worked in small organisations and also in large companies. Excel is one of those skills I have been able to transfer from job to job. There is always more to learn. Always a better way to do something. Throughout the years we've faced our own problems using Excel. We want to share with everyone the problems we've encountered and how we've overcome them. We are keen to keep adding onto this website so we can make this website more complete.

Contact Us

We are always looking to keep improving the content here and we always welcome any feedback you may have. If you have any suggestions for our website or if you have any Excel questions you would like us to cover, please let a message below.  

For all enquiries and feedback, please send us an email using the form below: