Microsoft Excel PowerPivot

Microsoft Excel PowerPivot

Overview and Objectives

  • In this course, students will make use of the PowerPivot add-in to consolidate data from various Excel sources and create a dynamic report.
  • Become familiar with the PowerPivot application and import data.
  • Manipulate data in a PowerPivot worksheet.
  • Create reports using PowerPivot data.

Course Outline

This course consists of 10 modules
Module 1What Is PowerPivot?
Module 2Download & Install PowerPivot
Module 3Working With Multiple Sheets in PowerPivot
Module 4Formatting Data for Pivot Tables
Module 5How to Use PowerPivot
Module 6Creating Relationships
Module 7Sorting & Filtering
Module 8Formatting PowerPivot Data
Module 9Calculations
Module 10Refreshing PowerPivot data

Excel PowerPivot

Who should attend?

This course is for advanced users of Excel who are looking for ways to enhance their skills in data analysis, pivoting & reporting areas.

Course Prerequisite

Students must have completed the Excel Intermediate and Advanced courses.

Duration

1 day

Cost

R1 270,00 (excl. VAT)

Includes

  • Comprehensive Manual
  • Lunch & Refreshments (not applicable to on-site training)
  • Electronic Certificate (on successful completion of the course)
  • Electronic Trainer Feedback Report
  • Electronic Delegate Feedback Questionnaire
Download Course Information

Microsoft Excel PowerPivot

Course Schedule

View the available course dates