Data wrangling with Excel

Understand how you can use Excel’s powerful tools to transform raw data, create summary calculations and automate your work in Excel to save time and be more productive. This workshop assumes experience with Excel basics.

By the end of this workshop, you’ll learn:

• Importing Data from Text Files and Web Pages
• Cleaning Excel Data with Flash Fill, Functions and Wizards
• Linking Data Across Worksheets and Workbooks
• Creating 3-D Formulas and Functions to Summarize Data
• Using Advanced PivotTable and Pivot Chart Tools to Analyze Multiple Data Sets
• Creating Macros to Automate Excel Tasks

RSVP