One of the most common tasks faced by accountants and office workers is that of data cleansing i.e. removing the extra blank columns , sub totals, blank rows so beloved of accounts packages but which all need to be removed before any sort of Excel analysis can be done with it. Don’t forget, it then has to be done again the following month – woo-hoo!

Part One – Clean up the file

In this video, you will see how you can clean up a typical accounts file and get it – well maybe not runway ready…but certainly pivot table ready in a lot less time than you would do it manually.

Part Two – New data, same steps, refresh

In this second video – see what we need to do to update the file we created in Part One with new data for the following month.