|
|
Need help or advice?
We'll call during UK business hours
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
906 Excel events in the next 12 months, live dates & pricing here |
Who is this course for?
This course is suitable for any existing Excel user who has to manipulate, analyse and report on massive amounts of data. Types of PowerPivot Course London attendees have varied from business analysts, commercial directors, finance teams, client service/revenue managers to the Office for National Statistics.
Prerequisites
A working knowledge of Excel to our Excel Advanced level, including PivotTables course.
Objectives
- At the end of this 2 day course delegates will have the skills required to start using PowerPivot.
- The course will show delegates how to leverage their existing PivotTable knowledge in Excel with PowerPivot.
- Enable delegates to better understand how PowerPivot might be applied back in their workplace.
Course Syllabus
Getting started with PowerPivot Start Excel & launch the PowerPivot window Adding data to PowerPivot Data sources and types supported in PowerPivot workbooks Preparing data for analysis Working with Tables and Columns Data; formatting and layout Creating, deleting a table PowerPivot and relationships Understanding Relationships | Calculations in PowerPivot Overview of Data Analysis Expressions (DAX) language Creating PivotTables, Charts & Reports Create a PivotTable or PivotChart Report Overview of Key Performance Indicators (KPI's) in PowerPivot Retail sales KPI case study |
|
|||||||||
| Version | Date | Location | Places available |
Book | Next place rate (£) | List price |
|||
|---|---|---|---|---|---|---|---|---|---|
| Pay by Card |
Pay by Invoice |
||||||||
| 2010 | Mon 8 + Tue 9 Jul 2013 | Limehouse | 9 |  |
£695 | £705 | £995 | ||
| 2010 | Tue 10 + Wed 11 Sep 2013 | Southwark | 10 | |
£640 | £650 | £995 | ||
| 2010 | Thu 10 + Fri 11 Oct 2013 | Bloomsbury | 10 | |
£995 | £995 | £995 | ||
| 2010 | Mon 11 + Tue 12 Nov 2013 | Limehouse | 10 | |
£640 | £650 | £995 | ||
| 2010 | Mon 16 + Tue 17 Dec 2013 | Southwark | 10 | |
£995 | £995 | £995 | ||
| 2010 | Tue 14 + Wed 15 Jan 2014 | Bloomsbury | 10 | |
£640 | £650 | £995 | ||
| 2010 | Thu 20 + Fri 21 Feb 2014 | Bloomsbury | 10 | |
£640 | £650 | £995 | ||
| 2010 | Wed 12 + Thu 13 Mar 2014 | Limehouse | 10 | |
£640 | £650 | £995 | ||
| 2010 | Tue 13 + Wed 14 May 2014 | Southwark | 10 | |
£640 | £650 | £995 | ||
| 2010 | Mon 14 + Tue 15 Jul 2014 | Limehouse | 10 | |
£640 | £650 | £995 | ||
What you get
 |
Training is held in our modern, comfortable, air-conditioned suites Modern-spec IT, fully networked with internet access |
"What do I get on the day?" |
Learning tools |
 Breaks and timingCourses start at 9:30am. |
 In-course handbookContains unit objectives, exercises and space to write notes |
 RefreshmentsAvailable throughout the day:
|
 Reference materialAvailable online. 100+ pages with step-by-step instructions |
 LunchLunch is provided at a local restaurant or pub. Browse the sample menus: |
 24 months access to Microsoft trainersYour questions answered by Microsoft qualified trainers online. |
Training Formats & Services
|
Some reasons why thousands of businesses trust us
|
Some of our clients:
|
