01 Introduction
02 What you need to know in Excel before we get started
-
02.01 Introduction (WIP)
-
02.02 Setting up your data in a way you can actually do something with it. (WIP)
-
02.03 Creating dropdown lists - to ensure accurate data entry (4:42)
-
02.04 Learn how to use Concatenation or another one of those things in Excel that is not as exciting as it sounds (2:19)
-
02.05 Meet your new best friend - the Vlookup() function (4:51)
-
02.06 Meet Excel tables - a feature that will make formula copying a thing of the past (3:45)
-
02.07 Conditional Formatting or how to use colour to make your Excel life easier (3:17)
-
02.08 Meet the If function (2:38)
-
02.09 Introduction to Pivot Tables or what should now be your Excel super power (4:31)
-
02.10 Conclusion to Module 02 (WIP)
-
02 Bonus Lesson - Quickly create a source for a dropdown list from an existing list. (1:56)
04 Getting some answers out of our data or let's start having fun
-
04.01 Introduction (WIP)
-
04.02 Identifying lists of courses completed by course /city (3:12)
-
04.03 Identifying who is up to date with certification (3:22)
-
04.04 How to identify whose training is due (4:42)
-
04.05 Identify lists of people who have desired certification (3:21)
-
04.06 Identify % compliance i.e. what percentage of a department are up to date with their training (2:40)
-
04.07 Dealing with mandatory and optional courses (WIP)
-
04.08 What to do with multiple instances of the same course for the same person? (WIP)
-
04.09 How do I deal with different renewal time frames? (2:32)
-
04.10 Total courses done over a year - how to identify (2:43)
-
04.11 Identifying who has not done training (2:06)
-
04.11 Creating a training budget from this data (5:55)
-
04.13 Conclusion to Module 04 (WIP)
05. Keeping it going...
Webinars
