In this short 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, Scenarios and more.
Prerequisite: Completion of Excel 2016 Level 1 or equivalent knowledge.
Hours: 2 hours
Offered at NO CHARGE to all University of Illinois (Urbana campus) faculty/staff.