Excel PowerPivot

STL
4.3
3 reviews
  • Bond was thorough in his content and that supported into the better instruction of the course
    |
  • I have just gone through a PowerPoint Course and realized that it was extremely useful.
    |
  • Truly delighted in the preparation. The educator was energetic, useful and was sufficiently adaptable to concentrate on particular topics of student intrigue. Incredible scene and fascinating course content. Extremely relevant and will support extraordinarily with everyday employment prerequisites.
    |

Course

In London

£ 501-1000

Description

  • Start date

    Different dates available

Rated excellent on Trustpilot!

Microsoft PowerPivot is an add on for Excel that provides Business Intelligence functionality & reporting within the familiar environment of Excel.

PowerPivot provides the real power to crunch & analyse data on a scale previously unimaginable with pivot tables.

Now it is possible to process millions of rows of data in Excel enabling deeper business insight and shorter decision making cycles.

This course is also offered as inhouse. STL may go to your premises or you can visit our venue in London.

Facilities

Location

Start date

London
See map
12 Bloomsbury Square, WC1A 2LP

Start date

Different dates availableEnrolment now open
London
See map
2nd Floor, Cruising Association House 1 Northey Street, E14 8BT

Start date

Different dates availableEnrolment now open

About this course

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.

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.

A very good knowledge of Excel, including a working knowledge of PivotTables and an understanding of nested functions.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.3
fantastic
  • Bond was thorough in his content and that supported into the better instruction of the course
    |
  • I have just gone through a PowerPoint Course and realized that it was extremely useful.
    |
  • Truly delighted in the preparation. The educator was energetic, useful and was sufficiently adaptable to concentrate on particular topics of student intrigue. Incredible scene and fascinating course content. Extremely relevant and will support extraordinarily with everyday employment prerequisites.
    |
100%
4.3
fantastic

Course rating

Recommended

Centre rating

Trevor

5.0
08/08/2016
What I would highlight: Bond was thorough in his content and that supported into the better instruction of the course
What could be improved: Nothing.
Would you recommend this course?: Yes

Anonymous

4.5
29/07/2016
What I would highlight: I have just gone through a PowerPoint Course and realized that it was extremely useful.
What could be improved: Everything OK.
Would you recommend this course?: Yes

Rowan

3.5
11/03/2015
What I would highlight: Truly delighted in the preparation. The educator was energetic, useful and was sufficiently adaptable to concentrate on particular topics of student intrigue. Incredible scene and fascinating course content. Extremely relevant and will support extraordinarily with everyday employment prerequisites.
What could be improved: Nothing bad.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • MS Excel
  • PowerPivot
  • Excel
  • Adding data
  • Sorting Data
  • Tables
  • Calculations in PowerPivot
  • Data Analysis Expressions
  • Charts
  • Reports
  • Key Performance Indicators

Course programme

Getting started with PowerPivot

Start Excel & 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 & 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




















Additional information

We include hot restaurant lunch in all training courses. In addition to that, our courses are never cancelled.

Excel PowerPivot

£ 501-1000