This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
How to track your training records in Excel
01 Introduction
01.01 Introduction (WIP)
01.02 How this course is structured
01.03 Who this course is for and who it is not for
01.04 What you need to be successful in this course (4:21)
01.08 Meet your data!
01.09 Conclusion - let's get going! (WIP)
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...
05.01 Introduction (WIP)
05.02 Protecting your formulas (2:55)
05.03 Password protecting your file (2:22)
05.04 Giving a Powerpoint presentation with your data (WIP)
05.05 Maintaining your records (WIP)
05.06 Conclusion (WIP)
Webinars
01 Planning and preparing
02.09 Introduction to Pivot Tables or what should now be your Excel super power
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock