
Data wrangling with Excel
Wednesday, October 17, 2018
6 p.m. – 8 p.m.
Wallis Annenberg Hall (ANN), Digital Lounge
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
This program is open to all eligible individuals. USC Annenberg operates all of its programs and activities consistent with the University’s Notice of Non-Discrimination. Eligibility is not determined based on race, sex, ethnicity, sexual orientation, or any other prohibited factor.