Excel 2016-2019 Analyzing Data with Tables and Pivot Tables (half-day)

Skip to Schedule / Outline
0.5 days - $215

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.

This Course is for…

Students needing a very focused, efficient introduction to Excel Data Analysis

Please note this class is for our business customers and is not approved for consumer education or eligible for veteran benefits. If you are interested in our veteran and individual consumer programs please visit our Career Training page.

Schedule / Enroll
05/09/20249:00 AM - 3:00 PM ET$215.00
  • Course Outline
  • Objectives
  • 1 – Course Outline

    • 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.
  • Develop skills working with Tables, Advanced Filtering, Pivot Tables and Charts.