merger merger

Welcome to your new course portal!

On October 15th, moved to - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show as: Mobile

Excel PowerPivot

Course summary
2 days
Corporate Training for Teams
STL courses

Excel PowerPivot

Courses never cancelled. 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.

STL virtual classroom training

We all have to accept our preferred face-to-face method just isn't an option right now. However, virtual classroom training that we have developed offers some benefits which can make it seem less of a compromise and more of a viable interim training solution. 

Our virtual classroom training is delivered by the same team responsible for achieving industry leading customer satisfaction ratings with face-to-face training, so rest assured you are in safe hands.

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 PowerPivotStart Excel and launch the PowerPivot windowNavigating the PowerPivot windowExploring the PowerPivot tab and field list in ExcelAdding data to PowerPivotData sources and types supported in PowerPivot workbooksImporting data (from pre-prepared file)Add Data by using Excel Linked TablesUsing Power QueryPreparing data for analysisWorking with Tables and ColumnsFiltering and Sorting DataCreating Relationships Between TablesCreating and Working with calculationsData; formatting and layoutCreating, deleting a tableRename a Table or ColumnSet the Data Type of a ColumnHide or Freeze ColumnsUndo or Redo an ActionSorting and filtering data in a tablePowerPivot and relationshipsUnderstanding RelationshipsCreate a Relationship Between Two TablesView and Edit RelationshipsDelete RelationshipsTroubleshoot RelationshipsCalculations in PowerPivotOverview of Data Analysis Expressions (DAX) languageBuilding Formulas for Calculated Columns and MeasuresUnderstanding the Use of Relationships and Lookups in FormulasUnderstanding Aggregations in FormulasFiltering Data in FormulasRecalculating FormulasCreating PivotTables, Charts and ReportsCreate a PivotTable or PivotChart ReportCreate a Reporting Services Report with PowerPivot DataCreate a Measure in a PivotTable or PivotChartCreate and Change the Field Layout in a PivotTable or PivotChart ReportDelete a PivotTable or PivotChart ReportFilter Data using SlicersWork with Relationships in PivotTablesChange the Display LanguageOverview of Key Performance Indicators (KPI's) in PowerPivotRetail sales KPI case studySales per hour, averageConversion ratesWage to sales ratio


Prices from £742. Promotional rates often available the further ahead you book. Contact us for quote.

Be Inspired! Watch the Video

Provider: STL

STL - Microsoft Training

STL - Helping businesses deliver productivity and efficiency gains

Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....

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


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


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

 Show phone number

Request Information

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


There are no reviews available yet.

U.K. L&D Report: 2019 - 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's second annual U.K. L&D Report!


Learn more

Be Inspired - watch the videos

Similar Courses