Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

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

Description

Upon successful completion of this course, you will be able to use Power Pivot along with Excel to analyze data from a variety of sources.

You will:

  • Get started with Power Pivot.
  • Visualize Power Pivot data.
  • Work with advanced functionality in Power Pivot.

Lesson 1: Getting Started with Power Pivot

Topic A: Enable and Navigate Power Pivot

Topic B: Manage Data Relationships

 

Lesson 2: Visualizing Power Pivot Data

Topic A: Create a Power Pivot Report

Topic B: Create Calculations in Power Pivot

 

Lesson 3: Working with Advanced Functionality in Power Pivot

Topic A: Create a KPI

Topic B: Work with Dates and Time in Power Pivot

Similar courses

Microsoft Excel for Office 365 (Desktop or Online): Part 1

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
Data Analysis Fundamentals

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
(Online Delivery) Microsoft Excel for Office 365 (Desktop or Online): Part 1

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

Press enter to see more results