Excel PowerPivot
- 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.
What to expect
- Courses never cancelled .
- Restaurant lunch .
- Last minute rescheduling .
- 24 month delegate support forum .
- And more... .
Upcoming start dates
Choose between 50 start dates
Upcoming start dates
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 windowNavigating the PowerPivot window
Exploring the PowerPivot tab and field list in Excel
Adding data to PowerPivot
Data sources and types supported in PowerPivot workbooksImporting data (from pre-prepared file)
Add Data by using Excel Linked Tables
Using Power Query
Preparing data for analysis
Working with Tables and ColumnsFiltering and Sorting Data
Creating Relationships Between Tables
Creating and Working with calculations
Data; formatting and layout
Creating, deleting a tableRename 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 RelationshipsCreate a Relationship Between Two Tables
View and Edit Relationships
Delete Relationships
Troubleshoot Relationships
Calculations in PowerPivot
Overview of Data Analysis Expressions (DAX) languageBuilding 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 ReportCreate 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 studySales per hour, average
Conversion rates
Wage to sales ratio
Expenses
List price £995, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.
Request information - obligation free
Customer Outreach Award
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.
Reviews by course attendees
Average rating 4.7
Based on 186 reviews.
Write a review!
5/5
Melinda
18 Jan 2023
5/5
Christopher
18 Oct 2022
Most useful topic: PowerQuery
STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
Ads
Not sure of the level of knowledge everyone else had going into the course so maybe it was because I had used pivot tables before but felt that could have done some more advance...