How to Track Training Records With Excel

Written by terri h. weisser
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Track Training Records With Excel
Tracking training records can be accomplished using Microsoft Office Excel. (books and apple. image by mashe from

You have been asked to start keeping track of training events for your company. Regardless of the size of your organisation, accurate training records are essential and a benefit to everyone. Microsoft Office Excel is an easy and efficient way to track training information. By taking advantage of workbook functionality you are provided the flexibility to organise the records the way you need them, when you need them.

Skill level:
Moderately Easy

Things you need

  • Microsoft Excel -- any version
  • Training data to be tracked

Show MoreHide


    Set Up Training Record Workbook

  1. 1

    Click the "File" drop-down menu then "New" and select "Blank Workbook" to create an empty workbook.

  2. 2

    Across row "1", starting in cell "A", enter headings for the information you need to track.

  3. 3

    Enter training information--one new row for each training event and each person to track. (For example, if Bob Smith attended two training classes, there would be two rows of information for him.)

  4. 4

    Click the "File" drop-down menu then "Save" to save your work. (Remember to do this periodically while entering training records.)

  5. 5

    Click the "Data" drop-down menu then "Sort" to organise your training records based on your requirements. NOTE: Be certain to select the radio button for "My data range has Header row."

  6. 6

    Save the organised workbook.

Tips and warnings

  • The information to track will vary with each situation, but some recommendations include last name, first name, e-mail address, phone number, training course, training date and next training date. If you are tracking training events for employees, you may want to include additional information such as manager, department, extension, training cost and training location.
  • The "Sort" step can be performed multiple times and as often as needed. Why is this helpful? Sort the list by the next training date to create reminder e-mails. Sort the list by manager to notify of completed training. The possibilities are endless and you are only limited by your creativity.
  • When using the "Sort" feature, remember that you can always select the "Undo" option if the sort did not produce the desired results. Just save your work frequently and work with the data until you have it organised in the best format to suit your needs.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.