
Analyzing big data with Excel
Wednesday, February 20, 2019
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 into usable information, create summary calculations and automate your work to save time and be more productive, and gain insight from trends you otherwise couldn’t see.
- Importing Data Sets 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
Instructed by Chris Murphy.
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.