Microsoft Excel – Power Pivot Course

overview

In this course, students will create and edit basic Microsoft
Office Excel 2010 worksheets and workbooks

Apply Today

Instructor Led Learning

Duration: 1 Day
Location: Cape Town & Johannesburg
Registration Open Now!

Video Learning

Duration:1 Day
Registration Open Now!

What you will learn

  • Lesson 1 :Getting Started with PowerPivot
  • Lesson 2 : Manipulating PowerPivot Data
  • Lesson 3 :Creating PowerPivot Reports
  • Lesson 4 :Using DAX Functions in PowerPivot
  • Lesson 5 : Distributing PowerPivot Data

Basic computer skills

Computers made easy course

Excel 2010 – Part 1

Excel 2010 – Part 2

Excel 2010 – Part 3

Location for instructor led courses are Cape Town and Johannesburg. We also offer onsite training country wide. T’s and Cs apply. Contact us for more information.

FULL COURSE OUTLINE

Lesson 1: Getting Started with PowerPivot

  • Explore the PowerPivot Application
  • Import Data from Various Data Sources
  • Refresh Data from a Data Source
  • Create Linked Tables

Lesson 2: Manipulating PowerPivot Data

  • Organize and Format Tables
  • Create Calculated Columns
  • Sort and Filter PowerPivot Data
  • Create and Manage Table Relationships

Lesson 3: Creating PowerPivot Reports

  • Create a PivotTable
  • Create PivotCharts
  • Filter Data Using Slicers
  • Present PivotTable Data Visually

Lesson 4: Using DAX Functions in PowerPivot

  • Manipulate PowerPivot Data Using DAX Functions
  • Extract Data from Tables Using Functions
  • Work with Time Dependent Data

Lesson 5: Distributing PowerPivot Data

  • Protect Reports
  • Save Reports in Different File Formats

Join Over 10,000 Students that have studied with MasterGrade IT Now

Become Part of MasterGrade IT to Further Your Career.