Microsoft® Office Excel®: Data Analysis with Pivot Tables and Charts

Course Length:                                

3 hours

Course Objectives:

Upon successful completion of this course, you will be able to create and perform advanced database analysis taking advantage of Excel PivotTable functionality.

You will:

  • Prepare Data for Use in a PivotTable
  • Create a PivotTable from a Local, External and Multiple Data Sources
  • Analyze Data Using PivotTables
  • Create and Format Pivot Charts

Target Student:

This course is intended for students who are experienced Excel 2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students who need to construct, update and analyze databases will benefit from this course.

Prerequisites:

To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel 2016. Specific tasks students should be able to perform include: creating formulas and using Excel functions.

Course Content

Lesson 1: Preparing Data and Creating Pivot Tables

  • Prepare Data
  • Create a PivotTable from a Local Data Source
  • Create a PivotTable from Multiple Local Data Sources
  • Create a PivotTable from an External Data Source

Lesson 2: Analyzing Data by Using PivotTables

  • Summarize and Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable

Lesson 3: Working with PivotCharts

  • Create a PivotChart
  • Manipulate PivotChart Data
  • Format a PivotChart
➤