How to Change and Substitute Specific Text in Excel
There could be various reasons why we need to change and substitute certain text in a cell. We have touched…
Complete guide to Excel errors and useful tips and tricks
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.
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.
There could be various reasons why we need to change and substitute certain text in a cell. We have touched…
There are many different ways to compare two columns. And it depends on how we want to do the comparison?…
In this article we will do a step by step guide on how to add up values based on cell…
In Excel we often reference another cell or a range of cells in a function or formula. And we drag…
If you are interested in rounding numbers and decimals in Excel, you've found the right article. In this article, we…
Check boxes in Excel are a useful tool in creating checklists or to-do lists. They are simple to use. Everyone…
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.
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.