Microsoft Excel 2016 – Power Pivot
-
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
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
Start date
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.
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.
← | →
Course rating
Recommended
Centre rating
Grencell
Grencell
Grencell
Grencell
This centre's achievements
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
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