Excel PowerPivot 2013

Request more details:

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