Managing Data with Formulas Function and Summarize with Pivot Table

4.7

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

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

4.7

  • 80%
  • 7%
  • 13%
  • 0%
  • 0%
  • NR
    Noor Azlien binti Rozad
    Senior Executive, Others

    5

  • GL
    Glorene Loh
    Manager / Supervisor, Accounting and Finance

    5

  • NR
    NUR AMIRAH IZZATI BINTI RAMLEE
    Executive, Others

    5

  • NA
    NOOR AINI
    Executive, Operations

    5

    such a superb class ever
  • DQ
    Daimon Quek
    Senior Executive, IT Management

    5

  • PM
    Pavithra Muniandy
    Junior Executive, HR / Learning and Development

    5

  • NN
    Norfaranirda Norman
    Manager / Supervisor, Others

    5

  • NS
    Nurul Syahirah
    Assistant Manager, Others

    5

  • RD
    Raziq Hamizan Bin Dunan
    Executive, Operations

    5

  • RM
    Renny Musa
    Manager / Supervisor, Others

    5

    👍 great
  • FI
    Fatin Syazana binti Md Isa
    Executive, Operations

    5

  • YY
    Yap Mun Yi
    Senior Executive, HR / Learning and Development

    5

  • PW
    Peter Wong
    Manager / Supervisor, Others

    4

  • Pc
    Phang yin ching
    Senior Executive, Accounting and Finance

    3

  • VG
    Vikneswaran Gunalan
    Assistant Manager, Operations

    3

OF 2Next
Optimized by Optimole

MEMBERS ONLY FEATURE

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

LOGIN

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

[nextend_social_login]

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?