by admin | Feb 8, 2021 | Tracking Training Records in Excel
A while back I had a message from a colleague. She had got a training contract but she wanted to track it on Excel. She needed to be able to see what days her courses were being delivered and by whom and the topic. She had made the – oh so common – mistake...
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 25, 2021 | Excel Path - Step by Step
In this video I show you how you would use plus – + to add up numbers and dates in Excel. Here is a link to the file if you want to practise Choose where you want the answer to goType in =Click on the first cell you want to useType in +Click on the second cell....
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...
