Excel PowerPivot Course 100015
Power Pivot is an add-in you can use to perform powerful data analysis in Excel. The add-in is built into certain versions of Excel, but by default, it’s not enabled.
Excel PowerPivot Course 100015 – Explore the PowerPivot 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 PowerPivot data, and create and manage table relationships.
After building your table data learn how to: create PivotTables and PivotCharts, filter data using slicers, and present PivotTable data visually. Then, manipulate PowerPivot data using DAX functions, extract data from tables using functions, and work with time-dependent data.
Wrap up with a look at how to protect reports and how to save reports in different file formats.
Excel PowerPivot Course 100015 Outline
Lesson 1: Getting Started with PowerPivot
- A: Enable and Navigate
- B: Import Data from Various Data Sources
- C: Refresh Data from a Data Source
- D: Create Linked Tables
Lesson 2: Manipulating PowerPivot Data
- A: Organize and Format Tables
- B: Create Calculated Columns
- C: Sort and Filter PowerPivot Data
- D: Create and Manage Table Relationships
Lesson 3: Creating PowerPivot Reports
- A: Create PivotTables
- B: Create PivotCharts
- C: Create PowerViews
- D: Filter Data Using Slicers
- E: Present PivotTable Data Visually
Lesson 4: Using DAX Functions in PowerPivot
- A: Manipulate PowerPivot Data Using DAX Functions
- B: Extract Data from Tables Using Functions
- C: Work with Time Dependent Data
Lesson 5: Distributing PowerPivot Data
- A: Protect Reports
- B: Save Reports in Different File Formats
Do not hesitate to Contact Us or Live Chat if you have questions or concerns about Excel PowerPivot Course 100015
05/03/2021 (Live Virtual) $350, 06/07/2021 (Live Virtual) $350, 07/12/2021 (Live Virtual) $350, 08/09/2021 (Live Virtual) $350, 09/06/2021 (Live Virtual) $350, 10/04/2021 (Live Virtual) $350, 11/08/2021 (Live Virtual) $350, 12/13/2021 (Live Virtual) $350
Train Your Team
Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!Request Group Quote
Register - Choose Date