Computer Tutoring Logo

Cost Calculator

Training delivery
Number of students?
Laptop hire?
Offsite training?

Course price: £ *
Price per head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live online Face to face
First name:

Last name:

Email:

Tel:

Location:

Number of students:
First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.
I would like to receive software tips and special offers

Microsoft Excel 2013 PowerPivot Training Course Beginners Ipswich

Ipswich Beginners Microsoft Excel 2013 PowerPivot Course Overview

Microsoft Excel 2013 PowerPivot Training Course Beginners training course Ipswich Willis building

With its historic docks, Ipswich combines a rich maritime heritage with modern attractions.

Belstead Road
Ipswich
Suffolk
IP2 9HB

The Belstead Brook Hotel sits in nine acres of tranquil gardens, alongside a willow-lined stream. The original 16th Century hunting lodge is still very much at the heart of the hotel, housing a restaurant, bar and private dining rooms. An ideal place for training the Microsoft Excel 2013 PowerPivot Training Course Beginners.

Alternatively if you live in and around Ipswich and wish to have your training on-site the we can provide all the equipment, included laptops and projector, required. All we ask is that you provide a little space for the trainer to set up.

Apart from Microsoft Excel 2013 PowerPivot Training Course training we conduct many other training courses in Ipswich.


Course Duration: 1 Day

Complete Course Outline

Getting Started with Microsoft Excel 2013 PowerPivot

  • Explore the PowerPivot 2013 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 PowerPivot Data
  • Create and Manage Table Relationships

Creating PowerPivot Reports

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

Using DAX Functions in PowerPivot

  • 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