Microsoft Excel 2016 – Power Pivot

4.5
4 reviews
  • A lot to cover in 2 days but will help me on my project.
    |
  • Additional examples where a fresh approach to most courses that I have been on.
    |
  • Trainer had vast knowledge, even covered some data analytics.
    |

Short course

Inhouse

£ 201-500

Description

  • Type

    Short course

  • Level

    Beginner

  • Methodology

    Inhouse

  • Duration

    2 Days

  • Start date

    Different dates available

Microsoft’s Power Pivot and business intelligence tools allow you to effectively mine large amounts of data. In this advanced Microsoft Excel training course, you gain the knowledge and skills to import and merge large amounts of data, summarise and aggregate data, present strategic data, provide better business insights, and empower informed decision-making.

Facilities

Location

Start date

Inhouse

Start date

Different dates availableEnrolment now open
Different dates availableEnrolment now open
Different dates availableEnrolment now open
Different dates availableEnrolment now open

About this course

Transform and present sophisticated data to provide Business Intelligence (BI)Actualise a data model from multiple sourcesShape and filter tables to prepare for analyses by fixing common issuesMine and expose hidden information with Data Analysis eXpressionsCommunicate business and data insights with dashboards

Excel Users wanting to learn more about data mining.

Working knowledge of Excel 2016.

Our courses are authored by content-area experts with a great deal of training experience. Topics are broken down into small chunks, which are explained, demonstrated with sample files or applications, and then practiced with hands-on exercises.

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.5
excellent
  • A lot to cover in 2 days but will help me on my project.
    |
  • Additional examples where a fresh approach to most courses that I have been on.
    |
  • Trainer had vast knowledge, even covered some data analytics.
    |
100%
4.8
excellent

Course rating

Recommended

Centre rating

Grencell

4.5
03/03/2018
What I would highlight: A lot to cover in 2 days but will help me on my project.
What could be improved: .
Would you recommend this course?: Yes

Grencell

4.5
02/03/2018
What I would highlight: Additional examples where a fresh approach to most courses that I have been on.
What could be improved: .
Would you recommend this course?: Yes

Grencell

4.5
01/03/2018
What I would highlight: Trainer had vast knowledge, even covered some data analytics.
What could be improved: .
Would you recommend this course?: Yes

Grencell

4.5
28/02/2018
What I would highlight: Interesting 2 days, very knowledgable instructor.
What could be improved: .
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2018

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 6 years

Subjects

  • Excel
  • Microsoft Excel
  • Import
  • Microsoft excel training
  • MS Excel
  • Microsoft Office
  • Spreadsheets
  • VBA
  • Data Analytics
  • Data handling

Teachers and trainers (1)

Bright  Solutions

Bright Solutions

Trainer

Course programme


#text-block-10 { margin-bottom:0px; text-align:left; }

Lesson 1:
Getting Started with PowerPivot

PowerPivot

The PowerPivot Window

The PowerPivot Ribbon Interface

PowerPivot Worksheets

Activity 1-1

PowerPivot Data Sources

Data Feeds

The Table Import Wizard

Data Types

How to Import Data From Various Data Sources

Activity 1-2

Data Refresh

Connections

How to Refresh Data from a Data Source

Activity 1-3

Linked Tables

How to Create Linked Tables

Activity 1-4

Summary

Review Questions

Lesson 2:
Manipulating PowerPivot Data

PowerPivot Tables

Managing Tables

How to Organize and Format Tables

Activity 2-1

Calculated Columns

PowerPivot Formulas

How to Create Calculated Columns

Activity 2-2

Sort Options

Filter Options

How to Sort and Filter PowerPivot Data

Activity 2-3

Table Relationships

Types of Relationships

The Create Relationship Dialog Box

The Manage Relationships Dialog Box

The Diagram View

How to Create and Manage Table Relationships

Activity 2-4

Summary

Review Questions

Lesson 3:
Creating PowerPivot Reports

PivotTables

Flattened PivotTables

The PowerPivot Field List Pane

Creating Key Performance Indicators

How to Create a PivotTable

Activity 3-1

PivotCharts

PivotChart Types

How to Create PivotCharts

Activity 3-2

Customize the Ribbon

Power Views

Activity 3-3

Slicers

How to Filter Data Using Slicers

Activity 3-4

Sparklines

Types of Sparklines

The Sparkline Tools – Design Contextual Tab

Conditional Formatting

Conditional Formats

How to Present PivotTable Data Visually

Activity 3-5

Summary

Review Questions

Lesson 4:
Using DAX Functions in PowerPivot

Measures

DAX Functions

DAX Variables

Aggregate Functions

How to Manipulate PowerPivot Data Using DAX Functions

#text-block-11 { margin-bottom:0px; text-align:left; }

Activity 4-1

Filter Functions

How to Extract Data From Tables Using Functions

Activity 4-2

Time Intelligence Functions

Create a Date Table

How to Work with Time Dependent Data

Activity 4-3

Summary

Review Questions

Lesson 5:
Distributing PowerPivot Data

Workbook Protection

Worksheet Protection

How to Protect Reports

Activity 5-1

File Formats

How to Save Reports in Different File Formats

Activity 5-2

Summary

Review Questions

Lesson Lab 1-1

Lesson Lab 1-2

Lesson Lab 2-1

Lesson Lab 2-2

Lesson Lab 3-1

Lesson Lab 3-2

Lesson Lab 4-1

Lesson Lab 5-1

Appendices

Keyboard Shortcut Quick Reference Sheet


Microsoft Excel 2016 – Power Pivot

£ 201-500