In this short online course you will learn how to use some of the data analysis features and tools in Excel 2016. Topics will include learning the basics of PivotTables; using subtotals in a list of data; setting up data validation rules; using Goal Seek, Solver, and Scenarios.
Prerequisite: Completion of Excel 2016 Getting Started or equivalent knowledge.
Hours: 2 hours
Offered at NO CHARGE to all University of Illinois (Urbana campus) faculty/staff.