– webinars that only cost your email address –
Quick snacks to boost your Excel fitness
Your questions answered! I design my Excel snacks to help make your life easier and your spreadsheets work better. You’ve been telling me that you’re hungry for more – so here they are! For this autumn’s menu, I have chosen four key tasks where if you get it right, Excel will work like a dream – and if you don’t, you can waste hours and tears trying to sort things out. If you need to use Excel to track training records, then these will also build some good foundations for my course in October. Plan your diary to ensure you grab your 20-minute snacks from the buffet! So good, you can’t believe they’re free!
|Name of Webinar||Description||Date and Time||Use the link below to register|
|Making data entry easy||
If the entries in your spreadsheet are not consistent, it causes all sorts of problems. Finding items or analysing data becomes a nightmare.
This 20-minute session shows you how to create a dropdown list to ensure consistent accurate data entry
|03 Sept 2021 12.40 pm GMT||Use this link to register|
|Vlookup – a Key Excel superpower||
You need to find out what is in one list but not in the other. Another issue can be that the data you need for this file is in another one but you don’t know how to hook them up together..Vlookup can fix this in minutes.
This 20-minute session will make sure all details are entered correctly/linking data sets together
|10 Sept 2021 12.40 pm GMT||Use this link to register|
|Summarise your data – Learn to Pivot i.e. create a pivot table||
You spend ages trying to find a way to list all the entries in a spreadsheet that have a common quality – not after this snack that will show you how!
This 20-minute session will show you how to automatically generate a list of all up to date trained people.
|17 Sept 2021 12.40 pm GMT||Use this link to register|
|Conditional formatting and “if” function – the happy relationship||
If only I could see immediately which records are up to date, or what is overdue… This snack could have you seeing Green, Amber and Red!
This 20-minute session will show you how to colour code the users who are up to date, out of date and due for renewal.
|24 Sept 2021 12.40 pm GMT||Use this link to register|