How To Sync Active Directory Users With A Spreadsheet

It's not uncommon for Human Resources to pass on lists of new staff, or changes to existing staff, in the form of a spreadsheet. You could go through these spreadsheets line by line and manually update Active Directory. This may work for small domain, but even then you are human and humans make mistakes. When mistakes do happen, was it because of the data from HR or because you misread it?
Get ready to operate at scale, and reduce the risk of human error, by learning how to synchronize Active Directory user with a spreadsheet using PowerShell.
In this video, Josh will walk you through how to create, and update, users based on information from a spreadsheet. We'll be using Doug Finke's ImportExcel PowerShell module to read our spreadsheet and the New-ADUser and Set-ADUser cmdlets from the Active Directory module.
Prerequisites include:
The Active Directory Module from the Remote Server Administration Tools (RSAT).
Doug Finke's ImportExcel PowerShell Module.