Have you ever looked at a spreadsheet and thought “where do I even begin?”
Sometimes it’s a file we inherit from someone else in our org. Other times, it’s a data entry project turned disaster. Either way, our sector is no stranger to the messy spreadsheet.
The problem is that you can spend way too much time manually fixing it all. I certainly have.
But that was before I knew about formulas and how to properly use them. These days, the errors I used to spend hours fixing now only take me a few minutes.
In this 10 minute video, I’ll show you how I use formulas and other functionality to quickly clean a messy spreadsheet file – no matter the size.
For more spreadsheet videos, check out the Youtube channel!