(Online Delivery) Microsoft Excel for Office 365/2021: Data Analysis with PivotTables

Description

Overview:

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with Microsoft® Excel® and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, 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.

This material will benefit users of any current Office version. The classroom environment setup is based on Excel for Office 365.

Course Objectives:

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. 

Target Student:

Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.

Course Prerequisites:

To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables. You can obtain this level of skill and knowledge by taking the following Logical Operations courses:

  • Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1
  • Microsoft® Excel® for Office 365™ (Desktop or Online): Part 2

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

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

Microsoft 365 for the Web (with Teams, SharePoint, and OneDrive). This is the best starting point for understanding how these three Microsoft products work together for the best possible organizational collaboration.

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). Please note - this is NOT a class that focuses on Microsoft Excel, Power BI, or any other software. Microsoft Excel will likely be used in class to illustrate core concepts, but the class is not designed to help students use software.

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 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

This class is a terrific "beginner" level class to help users become familiar with Office 365 web apps. Specifically, this course will help someone understand how to use Teams, OneDrive, and SharePoint in their workflows - as well as when to use each specific web app.

More Information

So what about all those "other" Office 365 web apps. Are you using them? This one day course gives an overview on Teams, Planner, Forms, Stream, Sway, and a preview of Power Automate.

More Information

So what about all those "other" Office 365 web apps. Are you using them? This one day course gives an overview on Teams, Planner, Forms, Stream, Sway, and a preview of Power Automate.

More Information