Microsoft PowerPivot

Insight IT Training
Course summary
1 day
Next available date: Dates are available all year and you choose the dates you want. - United Kingdom
Corporate Training for Teams

Course description

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Excel provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

Outcome / Qualification etc.

Each trainee will receive a Certificate of Attendance after the course.

Training Course Content

Course Content

Lesson 1: Getting Started with PowerPivot

Topic 1A:;Explore the PowerPivot Application

Topic 1B:;Import Data from Various Data Sources

Topic 1C:;Refresh Data from a Data Source

Topic 1D:;Create Linked Tables

Lesson 2: Manipulating PowerPivot Data

Topic 2A:;Organize and Format Tables

Topic 2B:;Create Calculated Columns

Topic 2C:;Sort and Filter PowerPivot Data

Topic 2D:;Create and Manage Table Relationships

Lesson 3: Creating PowerPivot Reports

Topic 3A:;Create a PivotTable

Topic 3B:;Create PivotCharts

Topic 3C:;Filter Data Using Slicers

Topic 3D:;Present PivotTable Data Visually

Lesson 4: Using DAX Functions in PowerPivot

Topic 4A:;Manipulate PowerPivot Data Using DAX Functions

Topic 4B:;Extract Data from Tables Using Functions

Topic 4C:;Work with Time Dependent Data

Lesson 5: Distributing PowerPivot Data

Topic 5A:;Protect Reports

Topic 5B:;Save Reports in Different File Formats


The prices quoted are a total cost. Each person will receive free ongoing post training support (if needed), copies of the Evaluation Forms completed by the trainee(s) for your records, and a comprehensive and user-friendly reference manual. And all of our costs such as travel, expenses and accommodation are included as well.

Get Inspired! Watch the Video

About provider

Insight IT Training - Customised IT and Business Skills Training

Insight IT Training - Customised IT and Business Skills Training, Tailored to Your Company

A family-run business established in 1998, Insight IT Training is a specialised provider of customised IT, Programming and Business Skills courses for companies across the UK. As an exclusive provider of private (in-company) solutions, Insight IT Training are dedicated to...

Read more and show all courses with this provider

Request info

Fill out your details to find out more about Microsoft PowerPivot.

  Contact the provider

  Get more information

  Register your interest

Contact info

Insight IT Training

Heath Farm, Wythall
b47 6aj Birmingham Worcestershire

 Show phone number

Request information

Find out more about this Microsoft PowerPivot course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here