by admin | Feb 1, 2021 | Case Studies - How To
In this blog post I walk you through a number of different ways to tackle a question. I had a user who had to identify the correct rate for something based on country of origin and product type. You can download the completed file here. Watch the video here to see how...
by admin | Jan 25, 2021 | Case Studies - How To
Recently in a class I had someone who had to track attendance over a number of days training via a bunch of Zoom Emails. This link shows you how you would extract a list of attendee email addresses from your Zoom list. The key is really to get your data in good shape....
by admin | Jan 18, 2021 | Case Studies - How To
This video show you how to create a very simple timetable for vaccinations with names and a dropdown list for timeslots (which can be updated). You can download the completed version here. You can view the video on how I did it...
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 | Nov 2, 2020 | Case Studies - How To
A question that comes up from time to time is how to get your PDF data into Excel. There are of course many online options to do so – just do a quick Google for “convert PDF to Excel” . However in this tutorial and video I want to show you how you...
