Excel Data Cleanup Training Overview
This Microsoft Excel Data Cleanup training course teaches attendees how to clean data in Excel using Text to Columns, text case formatting, Flash Fill, and more. Participants also learn how to automate data cleanup using Power Query.
Location and Pricing
This course is taught as a private, live online class for teams of 3 or more. All our courses are hands-on, instructor-led, and tailored to fit your group’s goals and needs. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for online corporate training, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Use techniques for data transformation
- Master Excel's Text to Columns feature
- Use Flash Fill effectively
- Create macros to automate data cleanup tasks
- Learn the basics of Power Query
Prerequisites
All students must have some familiarity with Excel.
Outline
Expand All | Collapse All
Introduction
- The importance of efficient data cleanup
Text to Columns
- Understanding and using the Text to Columns feature
- Splitting and organizing data effectively
Flash Fill
- Introducing and utilizing Flash Fill
- Automatic pattern recognition for data entry
Macro Recording
- Basics of macro recording in Excel
- Automating repetitive data cleanup tasks
Power Query Introduction
- Overview of Power Query functionality
- Importing, cleaning, and transforming data using Power Query
Conclusion
- Recap of key points
- Q&A and troubleshooting
Training Materials
All Excel training attendees receive a short reference handout covering the topics in the class.
Software Requirements
All attendees need a full installation of Office 365, including Excel.
