Microsoft Excel for Office 365/2021: Data Analysis with PivotTables

Description

In this course, you will use the advanced PivotTable functionality in Excel to analyze your raw data.

 

You will:

  • Prepare data for PivotTable reporting and create PivotTables from various data sources.
  • Analyze data by using PivotTables.
  • Work with PivotCharts.

Lesson 1: Preparing Data and Creating PivotTables

Topic A: Prepare Data

Topic B: Create a PivotTable from a Local Data Source

Topic C: Create a PivotTable from Multiple Local Data Sources

Topic D: Create a PivotTable from an External Data Source

 

Lesson 2: Analyzing Data by Using PivotTables

Topic A: Summarize PivotTable Data

Topic B: Organize PivotTable Data

Topic C: Filter PivotTable Data

Topic D: Format a PivotTable

Topic E: Refresh and Change PivotTable Data

 

Lesson 3: Working with PivotCharts

Topic A: Create a PivotChart

Topic B: Manipulate PivotChart Data

Topic C: Format a PivotChart

Similar courses

This is a mixed version class, appropriate for anyone using Excel 2016/2019/2021/2023, as well as Office 365 subscribers with automatic updates from Microsoft. Attention will be given to nuances between the program versions as applicable for the students in each class. For those using 2013 and earlier, please contact your Learning Consultant before enrolling in class.

More Information

Doing data analysis work is about more than learning a software program (Excel, Power BI, Tableau, etc.) - you need to understand the concepts and theory too. This one day course gets you up to speed (and can be useful either before or after your software classes).

More Information

This is a mixed version class, appropriate for anyone using Excel 2016/2019/2021/2023, as well as Office 365 subscribers with automatic updates from Microsoft. Attention will be given to nuances between the program versions as applicable for the students in each class. For those using 2013 and earlier, please contact your Learning Consultant before enrolling in class.

More Information

This class is designed for people new to using AI tools, such as ChatGPT - Gemini - or Copilot, in the workplace. People with experience using these tools for their job functions may find some of the content covered to be beginner or overview level. PLEASE NOTE - students in this class will create ChatGPT, Gemini, and/or Copilot accounts - and should have access to an email account and cell phone in order to move through the various vendors' multi-factor authentication processes during account set-up.

More Information

This class is designed for people new to using AI tools, such as ChatGPT - Gemini - or Copilot, in the workplace. People with experience using these tools for their job functions may find some of the content covered to be beginner or overview level. PLEASE NOTE - students in this class will create ChatGPT, Gemini, and/or Copilot accounts - and should have access to an email account and cell phone in order to move through the various vendors' multi-factor authentication processes during account set-up.

More Information