Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back


Category

ICT

Course type

Microsoft

Cost per individual

£195 +VAT
Public course

Cost per course

£550 +VAT
Client site, max 10 individuals

Duration

1 Day

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Book course

This course is intended for users who need to perform complex analysis of single and multiple data sets in order to present and manipulate data using Pivot Tables and Pivot Charts.

Objectives:

At the end of the course users will be able to use multiple data sources and produce calculations in PowerPivot and manage Pivot Table and Pivot Chart outputs with slicers.

Prerequisites:

An advanced understanding of working with Excel including using Functions and Formulas. A sound working knowledge of Pivot Tables and Related Databases is desirable but not essential.

Download Outline (PDF)

Pivot Table Revision
  • Creating a Pivot Table
  • Presenting Data using Pivot Charts
  • Filtering Pivot Data with Interactive Slicers
Getting Started & Connecting to Data Sources
  • Introducing Power Pivot
  • Working in the Power Pivot Screen
  • Using the Table Import Wizard
  • Filtering Data on Import
  • Creating Queries to Import Data
  • Adding Data with Copy & Paste
  • Linking Table Data
Related Data Sources
  • Related Data Sources
  • Creating Additional Queries
  • Merge & Append Queries
  • Creating Relationships in Power Pivot
  • Managing Relationships
  • Working in Diagram View
  • Defining Hierarchy Groups
  • Producing Related Data Outputs
  • Adding Queries to the Data Model
  • Manipulating the Data Model
Working with Power Pivot Formulas
  • Creating Calculated Columns
  • Using Power Pivot Functions
  • Producing Measures & KPI’s
  • Creating Perspectives

Book a course

Fill in your information to book this course. The information you provide on this booking form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.

Booking Form

Please select a date and location from the dropdown to add attendees

There are not enough spaces at this location for this many attendees. Please remove 0 attendees before continuing.

spaces remaining

If you just wish to enquire about this course click here