Results 1 to 3 of 3

Thread: Best method to create training log?

  1. #1
    Neophyte ExcelHelpNecessary's Avatar
    Join Date
    Jan 2021
    Posts
    4
    Articles
    0
    Excel Version
    2016

    Question Best method to create training log?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm trying to create a staff training log in excel. I've tried various methods and none of them are really getting me 100% to where I want to be.
    My requirements are:

    • Staff List
    • Course List
    • Ability to select staff member from dropdown, a list will appear detailing the courses they have taken
    • Ability to select course from a dropdown, a list will appear detailing the staff members that have taken this course

    Methods I've Tried:

    • VLOOKUP
    • Data Validation
    • Pre-existing template
    • Filters

    I feel like each of these methods is getting me close but I always run into a snag, any ideas or suggestions would be greatly appreciated.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,575
    Articles
    0
    Excel Version
    Office 365 Subscription
    This is what databases are for - I suggest you look at Access, where I'm sure you'll easily find a suitable template.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    288
    Articles
    0
    Excel Version
    2019
    Follow up to Ali's suggestion. Here is a link that I often refer Access Template Lookers to examine. While it does not give you an actual DB, it does provide great schema.

    http://www.databaseanswers.org/data_models/
    and specifically
    http://www.databaseanswers.org/data_...ning/index.htm
    Last edited by alansidman; 2021-01-16 at 05:58 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •