HOME
 

Excel PowerPivot

STL
Course summary
Length: 2 days
Price: 368 - 434 GBP excl. VAT
Language: English
Provider: STL plus
Course type: Open / Scheduled
Next available date: 12/03/2019 09:30 - London
Rating: (76 Reviews)
Course Dates
London
12/03/2019 09:30  (English)
368 GBP
13/05/2019 09:30  (English)
368 GBP
11/06/2019 09:30  (English)
434 GBP
11/07/2019 09:30  (English)
368 GBP
08/08/2019 09:30  (English)
419 GBP
10/09/2019 09:30  (English)
419 GBP

Excel PowerPivot



Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... 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.

Suitability - Who should attend?



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.

Training Course Content



Getting started with PowerPivot

Start Excel and launch the PowerPivot window
Navigating the PowerPivot window
Exploring the PowerPivot tab and field list in Excel

Adding data to PowerPivot

Data sources and types supported in PowerPivot workbooks
Importing data (from pre-prepared file)
Add Data by using Excel Linked Tables

Preparing data for analysis

Working with Tables and Columns
Filtering and Sorting Data
Creating Relationships Between Tables
Creating and Working with calculations

Data; formatting and layout

Creating, deleting a table
Rename a Table or Column
Set the Data Type of a Column
Hide or Freeze Columns
Undo or Redo an Action
Sorting and filtering data in a table

PowerPivot and relationships

Understanding Relationships
Create a Relationship Between Two Tables
View and Edit Relationships
Delete Relationships
Troubleshoot Relationships

Calculations in PowerPivot

Overview of Data Analysis Expressions (DAX) language
Building Formulas for Calculated Columns and Measures
Understanding the Use of Relationships and Lookups in Formulas
Understanding Aggregations in Formulas
Filtering Data in Formulas
Recalculating Formulas

Creating PivotTables, Charts and Reports

Create a PivotTable or PivotChart Report
Create a Reporting Services Report with PowerPivot Data
Create a Measure in a PivotTable or PivotChart
Create and Change the Field Layout in a PivotTable or PivotChart Report
Delete a PivotTable or PivotChart Report
Filter Data using Slicers
Work with Relationships in PivotTables
Change the Display Language

Overview of Key Performance Indicators (KPI's) in PowerPivot

Retail sales KPI case study
Sales per hour, average
Conversion rates
Wage to sales ratio

Expenses



List price £995 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.

Be Inspired! Watch the Video

   

Election Analysis Excel Dashboard

Best STL

Using an Excel Dashboard to analyse and visually display May 2015 UK General Election Poll data from the web.


Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Excel PowerPivot.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.microsofttraining.net


Reviews by course attendees

Nadine Bieshaar; Group Royalties Manager   |   21/06/2016
Most useful topic: Relationships
          (5)
Adam King; Financial Controller   |   21/06/2016
Maybe provide a condensed one-day version?
          (5)
Marta De La Hoz; Royalties Manager UK   |   21/06/2016
Most useful topic: merging files
          (5)
Request information

Find out more about this Excel PowerPivot course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here