Excel PowerPivot 2013

Course Description

PowerPivot is a powerful data exploration tool based on in-memory computing technologies that provides unmatched analytical performance to process billions of rows almost instantaneously. In this one day Microsoft Excel 2013 PowerPivot Training course, students will learn how to use PowerPivot to import and manipulate data, create PowerPivot reports, use DAX functions, create key performance indicators (KPI) and use slicers and hierarchies to enhance the visualization of data. Exercises accompany each lesson to enhance the learning process. The courseware covers the buttons on the PowerPivot tab and accompanying tabs for creating and editing tables and charts. The power in PowerPivot is the ability to import data from multiple sources. The course provides examples using an Access database, copy and paste, text file and Excel file. In addition, calculated fields and columns are defined and used to enhance your PivotTable
1 day
€350.00
10 Aug, 20 Oct, 08 Dec
14 Jul, 20 Sep, 22 Nov

Prerequisites

Participants should be familiar with Excel 2013 to Intermediate or Advanced level

Introduction to PowerPivot 2013

Explore the PowerPivot Workspace
Manage Data Model button
Calculations Group
Slicer Alignment Group
Tables
Detect Relationships
Settings

Building Data Models

Create Data Models
Manage Data Model
Clipboard
Get External Data
Refresh
PivotTable
Formatting
Sort and Filter
Find/Calculate/View

Create a PivotTable and PivotChart

Determine Chart or Table
Create a PivotTable
PivotTable Fields
Analyze
Design
Layout/Style
Create a PivotChart
Fields
Show/Hide
Location
Format
Insert Shapes
WordArt Styles
Arrange/Size

Use DAX in PowerPivot

DAX Operators
Text Functions
Logical Functions
Statistical/Aggregation Functions
Informational Functions
Math and Trigonometric Functions
Filter Functions
Time Intelligence Functions
Define Calculated Columns
Define Calculated Fields
Implicit/Explicit Fields

Enhance PivotTables & PivotCharts

Define key Performance Indicators (KPIs)
Define Slicers
Slicer Tools Options
Define Hierarchies
Create Hierarchies

Advanced ExcelExcel 2013Microsoft ExcelMIcrosoft Excel 2013MS Excel