Credit/debit card
Company invoice
Pricing ex VAT
- Certificate of completion - Free
- Tutor is available to students
Credit/debit card
Company invoice
Pricing ex VAT
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 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.
Digital certificate - Included
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
A very good knowledge of Excel, including a working knowledge of PivotTables and an understanding of nested functions.
Currently there are no reviews for this course. Be the first to leave a review.
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.