catraining

 

Microsoft Partner
Excel PowerPivot 2010

Audience: This course is aimed at experienced users of Excel PivotTables wishing to further their knowledge in Excel PowerPivot. Microsoft PowerPivot is a Microsoft Excel 2010 Add-on used for creating Business Intelligence (BI) reports based on large data sets inside the familiar environment of Excel PivotTables. PowerPivot is a free download from Microsoft. You need to have the PowerPivot add-on installed before the course if you are using your own equipment.

Course Duration: 1 day

Course: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday Club.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

reaining course

 

After completing this course, students will be able to:
    • Navigate the PowerPivot window
    • Specify source data for PowerPivot
    • Preparing data for analysis
    • Format Data
    • Create PowerPivot Relationships
    • Enter PowerPivot Calculations using DAX
    • Create Key Performance Indicators (KPI's)
    •  


  • Course Content
    print this page
    Module 1: Introduction to Power Pivot
    • Enabling the PowerPivot Add-in
    • Opening the PowerPivot window
    • Navigating the PowerPivot window
    • Exploring PowerPivot tabs and field list
    Module 2: Source data for PowerPivot
    • Data sources and types supported by PowerPivot workbooks
    • Importing data
    • Adding tables to a PowerPivot model
    • Linking to Excel Tables
    Module 3: Preparing data for analysis
    • Working with Tables and Columns
    • Filtering and Sorting Data
    • Creating Table Relationships
    • Creating calculations
    Module 4: Formatting Data
    • Creating and deleting a table
    • Renaming a Table or Column
    • Setting the Data Type of a Column
    • Hiding and Freezing Columns
    • Sorting and filtering table data
     
    Module 5: PowerPivot Relationships
    • Understanding Relationships
    • Creating Relationships between Tables
    • Viewing and Editing Relationships
    • Deleting Relationships
    Module 6: PowerPivot Calculations
    • The Data Analysis Expressions (DAX) language
    • Creating formulas for calculated columns and measures
    • Using DAX operators
    • Review of DAX functions
    • Using relationships and lookups in formulas
    • Using aggregate functions
    • Using filters in aggregate functions
    • Recalculating Formulas
    Module 7: Key Performance Indicators (KPI's)
    • Defining a KPI
    • Creating the KPI calculation
    • Setting the icon style and threshold values
    • Editing a KPI
     
      Microsoft

Call us now for further information Tel:08001601666