Computer Tutoring Logo
Est. 2002
Menu Button

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.
I would like to receive training special offer emails
I would like to be notified about free software hints and tips

Testimonials

Smurfit Kappa SSK

"Pace, content and interaction with trainer was very good" "Good pace & data examples useful" "Will definitely help with my work"

Fontus Health Limited

"An enjoyable day and Simon was very professional and approachable."

Microsoft Excel 2010 PowerPivot Training Course Beginners

In this Excel PowerPivot training course you will make use of the PowerPivot 2010 add-on to import data from various sources and create a dynamic report. You will become familiar with the PowerPivot application and import data as well as learning how to manipulate data in a PowerPivot worksheet. Create reports using PowerPivot data and use DAX functions in PowerPivot. Lastly distribute PowerPivot data.

Other Excel training courses

Course Duration: 1 Day

Course Outline

Getting Started with Microsoft Excel 2010 PowerPivot

  • Explore the PowerPivot Application
  • Import Data from Various Data Sources
  • Refresh Data from a Data Source
  • Create Linked Tables

Manipulating PowerPivot Data

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

Creating Reports

  • Create a PivotTable
  • Create PivotCharts
  • Filter Data Using Slicers
  • Present PivotTable Data Visually

Using DAX Functions

  • What's the difference between DAX and normal functions?
  • Manipulate PowerPivot Data using DAX Functions
  • Extract Data from Tables Using Functions
  • Work with Time Dependent Data

Distributing PowerPivot Data

  • Protect Reports
  • Save Reports in Different File Formats

Beginners PowerPivot Prices from:

If you are interested in this course but want to know the price beforehand then use the the following form to calculate how much.

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

No. Students:

First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

I would like to receive training special offer emails
I would like to be notified about free software hints and tips





Microsoft Excel 2010 PowerPivot Training Course Beginners