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.

Chat with us LIVE to get a

FREE QUOTATION!

COURSE INCLUDES

COURSE BENEFITS

ALL IN FROM ONLY

RM1,999/DAY

RRP RM2,860/DAY   SAVE RM861

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

No review yet.

MEMBERS ONLY FEATURE

Kindly sign-up or log-in to get access.

LOGIN

Login with your social account

or

Don’t have an account with us?

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?