Information Technology
Excel 2016-2019 Analyzing Data with Tables and Pivot Tables (half-day)
This Quick Study option is designed to be a half-day edition of a course which focuses solely on the skills users need to be productive immediately in Microsoft Excel. We have listened carefully to customer feedback on the content and designed this course to best suit the main topics of interest. Lesson examples are relevant and extraneous content gone.
1 Day
3 Hrs
1 Lesson
Agenda
- Sorting and filtering data in Tables, Advanced filtering, using structured references, naming tables and using the Quick Analysis button
- Creating a PivotTable, working with PivotTables, rearranging PivotTables, using slicers to filter PivotTable data, adding fields to a PivotTable, create a Pivot Chart and apply filters
- Easily create a Dashboard for a visual representation of key metrics that allow you to quickly view and analyze your data in one place.
FREE
Interested in course?
Course Type: Instructor Led