Warning: Declaration of ET_Theme_Builder_Woocommerce_Product_Variable_Placeholder::get_available_variations() should be compatible with WC_Product_Variable::get_available_variations($return = 'array') in /home/customer/www/xsit.nl/public_html/wp-content/themes/Divi/includes/builder/frontend-builder/theme-builder/WoocommerceProductVariablePlaceholder.php on line 8
Excel Power Pivot | Access IT Training

Power Pivot

Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Sed molestie, velit ut eleifend sollicitudin, neque orci tempor nulla, id sagittis nisi ante nec arcu.

Course description

Level:   Advanced 
Duration:   1 day

This course takes a look at the free PowerPivot add-in for Microsoft Excel 2016. Its aim is for all users of PowerPivot to get a good grasp of how its features are set and how it works. It covers interface features, techniques for manipulating PowerPivot data, how to create PowerPivot reports, the structure of DAX functions, and ways to distribute PowerPivot data.  

Getting Started with PowerPivot 

This initial lesson shows students how to: explore the PowerPivot application, import data from sources, refresh data, and create linked tables.

Manipulating PowerPivot Data 

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.

Creating PowerPivot Reports 

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.

Using DAX Functions in PowerPivot 

Here, students will learn how to: manipulate PowerPivot data using DAX functions, extract data from tables using functions, and work with time dependent data. 

Distributing PowerPivot Data 

This course wraps up with a look at how to protect reports and how to save reports in different file formats.

Page Break 

Lesson Plan 

Lesson 1: Getting Started with PowerPivot 

  •  Enable and Navigate 
  •  Import Data from Various Data Sources 
  •  Refresh Data from a Data Source 
  •  Create Linked Tables 

Lesson 2: Manipulating PowerPivot Data 

  •  Organize and Format Tables 
  •  Create Calculated Columns 
  •  Sort and Filter PowerPivot Data 
  •  Create and Manage Table Relationships 

Lesson 3: Creating PowerPivot Reports 

  •  Create PivotTables 
  •  Create PivotCharts 
  •  Create PowerViews 
  •  Filter Data Using Slicers 
  •  Present PivotTable Data Visually 

Lesson 4: Using DAX Functions in PowerPivot 

  •  Manipulate PowerPivot Data Using DAX Functions 
  •  Extract Data from Tables Using Functions 
  •  Work with Time Dependent Data 

Lesson 5: Distributing PowerPivot Data 

  •  Protect Reports 
  •  Save Reports in Different File Formats 




Duis egestas aliquet maecenas erat eros, fringilla et leo eget, viverpretium. Quisque sed augue tincidunt, posuere dui tempor, dapibus nisi. Donec vel lectus sapien. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas.

Free Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Premium Courses

Duis egestas aliquet aliquet. Maecenas erat eros, fringilla et leo eget, viverra pretium nulla. Quisque sed augue tincidunt, posuere dui tempor.

Ready to get started?

Get in touch, or create an account

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!