Excel Data Skills Training2019-08-09T17:48:40-05:00
‘Rev Up Your Data Skills’ Workshop – 2019 ILG National Conference
Jennifer McAlister (Director of Operations) and William Waymel (Director of Audit Services)
You pulled data from the HRIS and Applicant Tracking System. What now? Ensuring your data’s integrity is a crucial step in preparing your AAP or providing it to your vendor. Do you want to learn some techniques for ensuring all hires are on the Applicant Flow Log? In a pickle because you aren’t able to pull accurate promotion data? Do you have repetitive data formatting, merging, or cleanup tasks you’d like to automate? We’ll demonstrate some examples with Excel’s Power Query tool, PivotTables, Vlookup, and other formulas that will make copy and paste seem primitive. Impress your peers and manager while saving yourself time and headaches by upgrading your data skills!
Click the link below to download all data files used in the ‘Rev Up Your Data Skills’ presentation at the 2019 ILG National Conference.