BLOG
CATALOG
Menu
Multi racial group of people working with Paperwork on a board room table at a business presentation or seminar. The documents have financial or marketing figures, graphs and charts on them. There is a laptop and digital tablet on the table. Multi ethnic group including Caucasian and African American
a stack of orange and white books with text overlay of different training topics related to the professional workforce.
Browse hundreds of training topics to elevate team performance.
a laptop and phone with course training text on the screen.

Learn about PTR’s interactive course workbook for different learning styles.

Professional African-American woman training instructor smiling with overlay text.

PTR instructors are experts at delivering engaging, professional training.

Microsoft Excel: Data Analysis with PivotTables Training Course

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

The need to analyze data and gain actionable insight is greater than ever. This course will teach you to harness the power of advanced PivotTable features and create PivotCharts to gain a competitive edge. You will not only be able to summarize data for analysis but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Learning Objectives »

  • Prepare data and build PivotTables from multiple sources
  • Analyze data by using PivotTables
  • How to work with PivotCharts

Course Agenda

Preparing Data and Creating PivotTables

  1. Organizing Data for Your Workflow
  2. Create a PivotTable from a Local Data Source
  3. Create a PivotTable from Multiple Local Data Sources
  4. Create a PivotTable from an External Data Source

Analyzing Data by Using PivotTables

  1. Summarize PivotTable Data
  2. Organize PivotTable Data
  3. Filter PivotTable Data
  4. Format a PivotTable
  5. Refresh and Change PivotTable Data

Working with PivotCharts

  1. Create a PivotChart
  2. Manipulate PivotChart Data
  3. Format a PivotChart
Multi racial group of people working with Paperwork on a board room table at a business presentation or seminar. The documents have financial or marketing figures, graphs and charts on them. There is a laptop and digital tablet on the table. Multi ethnic group including Caucasian and African American

Microsoft Excel: Data Analysis with PivotTables Training Course

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

The need to analyze data and gain actionable insight is greater than ever. This course will teach you to harness the power of advanced PivotTable features and create PivotCharts to gain a competitive edge. You will not only be able to summarize data for analysis but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Learning Objectives »

  • Prepare data and build PivotTables from multiple sources
  • Analyze data by using PivotTables
  • How to work with PivotCharts

Course Agenda

Preparing Data and Creating PivotTables

  1. Organizing Data for Your Workflow
  2. Create a PivotTable from a Local Data Source
  3. Create a PivotTable from Multiple Local Data Sources
  4. Create a PivotTable from an External Data Source

Analyzing Data by Using PivotTables

  1. Summarize PivotTable Data
  2. Organize PivotTable Data
  3. Filter PivotTable Data
  4. Format a PivotTable
  5. Refresh and Change PivotTable Data

Working with PivotCharts

  1. Create a PivotChart
  2. Manipulate PivotChart Data
  3. Format a PivotChart
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.