How to track your training records in Excel
So you know who has done what, even if you don't know who they are.
Enroll in Course
- Learn how to set up your data properly from the beginning - so that you can easily answer different questions such as:
- Who is certified in what course?
- Who needs to be reminded about their soon-to- lapse certification?
- How to handle courses that have different expiry dates.
- How much has each department spent and how much have they got left
Every month you spend hours and days trying to figure out who has done what training and if they are up to date or not. You eventually get it done but then you get asked another question and it's back to the drawing board.
You have some Excel skills and you don't want to invest in expensive software but where even to begin? This is where this course can help you..
It will show you how to track your training records using Excel so that you know who needs courses and who doesn't, whose department is compliant with key trainings and who is not.
In this course you will learn the following
Your Instructor
I am an experienced freelance trainer of over 20 years experience. I love Excel and want to help you love it too. I am the author of "Your Excel Survival Kit - Your guide to surviving and thriving in an Excel world". and Get and Transform your Data on BookBoon about how to clean up your data.
I want to help you really get the most out of Excel . I want YOU to become the Excel god/goddess in your office
Course Curriculum
-
Start02.01 Introduction (WIP)
-
Start02.02 Setting up your data in a way you can actually do something with it. (WIP)
-
Start02.03 Creating dropdown lists - to ensure accurate data entry (4:42)
-
Start02.04 Learn how to use Concatenation or another one of those things in Excel that is not as exciting as it sounds (2:19)
-
Start02.05 Meet your new best friend - the Vlookup() function (4:51)
-
Start02.06 Meet Excel tables - a feature that will make formula copying a thing of the past (3:45)
-
Start02.07 Conditional Formatting or how to use colour to make your Excel life easier (3:17)
-
Start02.08 Meet the If function (2:38)
-
Start02.09 Introduction to Pivot Tables or what should now be your Excel super power (4:31)
-
Start02.10 Conclusion to Module 02 (WIP)
-
Start02 Bonus Lesson - Quickly create a source for a dropdown list from an existing list. (1:56)
-
Start04.01 Introduction (WIP)
-
Start04.02 Identifying lists of courses completed by course /city (3:12)
-
Start04.03 Identifying who is up to date with certification (3:22)
-
Start04.04 How to identify whose training is due (4:42)
-
Start04.05 Identify lists of people who have desired certification (3:21)
-
Start04.06 Identify % compliance i.e. what percentage of a department are up to date with their training (2:40)
-
Start04.07 Dealing with mandatory and optional courses (WIP)
-
Start04.08 What to do with multiple instances of the same course for the same person? (WIP)
-
Start04.09 How do I deal with different renewal time frames? (2:32)
-
Start04.10 Total courses done over a year - how to identify (2:43)
-
Start04.11 Identifying who has not done training (2:06)
-
Start04.11 Creating a training budget from this data (5:55)
-
Start04.13 Conclusion to Module 04 (WIP)