Excel PowerPivot Course 100015

Course 100015

Excel PowerPivot Course 100015


To customize this class, call 800-453-5961 or click here to contact us

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

Additional information

dates

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


$350.00

Clear
Number of Seats: