This one-hour training will equip participants with data wrangling techniques using Excel and will tackle the challenges of messy datasets. Participants will learn how to clean, format, transform, standardize, and organize data in Excel. This class is for beginners: no advanced Excel experience is required but basic familiarity with Excel is expected.
By the end of this training, attendees will be able to:
Trim and transform data using UPPER and PROPER functions
Format dates
Clean data using filters and find/replace functions
Apply basic conditional formatting