Category
ICT
Course Type
Microsoft
Price Per Delegate
£245 +VAT
Public Scheduled Course
Price Per Course
£745 +VAT
On-Site at Customer Premises, Max 10 Delegates
Duration
1 Day
Full/Part Time
Part Time
Provider
Book courseThis 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.
- Creating a Pivot Table
- Presenting Data using Pivot Charts
- Filtering Pivot Data with Interactive Slicers
- 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
- 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
- Creating Calculated Columns
- Using Power Pivot Functions
- Producing Measures & KPI’s
- Creating Perspectives
Enquire about a course
Fill in your information to apply for this course. The information you provide on this application 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.
