title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Microsoft 365 Excel: Power Pivot
Duration
1 Day
Course
VS-mos6004
Available Formats
Classroom Training, Online Training
Course Description
Overview
This course takes a look at the free Power Pivot add-in for Microsoft 365 Excel. Its aim is for all users of Power Pivot to get a good grasp of how works and its feature set. It covers different features of the interface, techniques for manipulating and visualizing Power Pivot data, how to create Power Pivot reports, the structure of DAX functions, and ways to distribute Power Pivot data.Objectives
Topics
Getting Started with Power Pivot
- This initial lesson shows students how to: explore the Power Pivot application, import data from sources, refresh data, and create linked tables.
- Students will then move on to learning how to: organize and format tables, create calculated columns, sort and filter Power Pivot data, and create and manage table relationships.
- In this lesson, students build upon what they have learned by being shown how to: create PivotTables and PivotCharts, filter data using slicers, and present PivotTable data visually.
- Here, students will learn how to: manipulate Power Pivot data using DAX functions, extract data from tables using functions, and work with time dependent data.
- This course wraps up with a look at how to protect data using both workbook and worksheet protection methods. and how to save reports in different file formats.
Related Courses
-
Microsoft 365 Fundamentals
MOC-MS-900T01- Duration: 1 Day
- Delivery Format: Classroom Training, Online Training
- Price: 595.00 USD
-
Microsoft® Office 365™ Online (with Skype® for Business) note: for Office 2013, 2016, or later
LO-091029- Duration: 1 Day
- Delivery Format: Classroom Training, Online Training
- Price: 595.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.