by admin | Jan 11, 2021 | Case Studies - How To
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...
by admin | Dec 14, 2020 | Case Studies - How To
This year has been the year of the pivot – so many people have had to pivot in their lives, both personal and professional. Pivot is defined as the action of turning around a point but of course in Excel it invariably means pivot table – which is basically...
by admin | Feb 9, 2016 | Excel Path - Step by Step
As always, I hope you are well. As per my earlier blog post I am going to be offering two segments here: Excel Novice 5 min tip Learn how to print your spreadsheet so that you don’t spend time cutting, pasting, gluing and stapling (awww, the horror!) ....