Microsoft Office > Managing Data in Excel 2013 (Professional Edition) Power Pivot

Managing Data in Excel 2013 (Professional Edition) Power Pivot

Course Objectives

Become familiar with the PowerPivot application.
Develop data model while importing data from multiple sources.
Manipulate data in a PowerPivot worksheet.
Create reports using PowerPivot data.
Use DAX functions in PowerPivot.
Define KPIs (Key Performance Indicators).
Use slicers to enhance data visualization.

Target Audience

This course is intended for students with a sound working knowledge of Microsoft Excel 2013 and general computing proficiency, including those who will be using Excel to make business decisions.
Before attending this course, students must have:

Some experience using Excel, including creating and using formulas and some exposure to PivotTables

Course Modules

Module 1: Introduction to PowerPivot 2013
Module 2: Building Data Models
Module 3: Create a PivotTable and PivotChart
Module 4: Use DAX in PowerPivot
Module 5: Enhance PivotTables and PivotCharts

Get To Know The Trainer

Trainer Shabenah

4.5

Shabenah is an experienced corporate trainer, facilitator and consultant with deep knowledge in the field of IT, soft skills, leadership and communication. She has a great passion for training, learning and development, and is able to work effectively with people of all levels. Shabenah is also an active participant in local community and social activities.

VIEW PROFILE