by admin | Jan 18, 2021 | Excel Path - Step by Step
One of my key ideas for this year is to create a section in my newsletter specifically for Excel newbies – so that people who are new to Excel can use it as a way to get stuck in and start understanding the terminology. If that is you, I would suggest starting...
by admin | Jan 11, 2021 | Personal
I do love a good podcast and one of my absolute favourites is Gretchen Rubin’s Happier. She does it with her sister – Liz Craft – who also has a great podcast called Happier in Hollywood with her writing partner Sarah Fain. One of their key ideas...
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 | Dec 7, 2020 | Excel Path - Step by Step
Filter() is one of the new dynamic array functions in Excel. So what does that mean? If you have used Excel you will know that generally it has made like a single celled organism – create your formula in ONE cell and then copy it down or across. The new range of...
