PowerPivot Training for Microsoft Excel

PowerPivot Training for Microsoft Excel PowerPivot Training for Microsoft Excel
By TED Integrated
PSMB HRDF Claimable
Course Title:
Introduction to PowerPivot 2010
Training Category:
Information Technology
Target Audience:
Any experienced Microsoft Excel users who would like to use PowerPivot to pull data from various sources and manipulate the data for decision making.
Duration:
1 Day
Public Program* Now Available! »
Jun 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Thu 27 Jun 2019 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Jul 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Tue 16 Jul 2019 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Aug 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Tue 20 Aug 2019 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Sep 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Fri 13 Sep 2019 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Oct 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Thu 10 Oct 2019 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Nov 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Tue 19 Nov 2019 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
Dec 2019 ›
Venue:
TED Learning Centre, Binjai 8 Premium SOHO, Kuala Lumpur, Malaysia
Schedule:
Fri 13 Dec 2019 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Promotions:
  • 10% discount for group registration of 3 paxs or more.
Register Now!

* Other terms & conditions apply.
For In-house Training »
Request for Quotation Request for Quotation
For Customization & Other Inquiries »
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • Workshop
  • Presentation Handouts
  • Computer Lab Work
  • Certificate of Participation
Ad by Google
*Terms & Conditions
Microsoft Excel Training Series:

Introduction to PowerPivot 2010

“Discover the power of PowerPivot and learn how it aids your decision making process...”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Register for Public TrainingRegister for Public Training
Email Customer Service [email protected] Contact Customer Service+603-2386-7788

Introduction

PowerPivot is a powerful data analysis tool in Microsoft Excel 2010. This feature enables you to import large amount of data from multiple data sources into one single Excel workbook and create relationships between heterogeneous data. Apart from that, you can also create calculated columns and measures using formulas to further manipulate it for your business objectives. The beauty of building Pivot Table and Pivot Chart is to allow you to analyze the data so that you can make timely and prompt decision.

Course Objectives

Upon successful completion of this 1-day course, students should be able to:

  • Become familiar with the PowerPivot application and import data.
  • Manipulate data in a PowerPivot worksheet.
  • Create reports using PowerPivot data.
  • Use DAX functions in PowerPivot.

Course Outline

DAY 1

Morning Session

  • Import data from multiple data sources.
  • Create linked data.
  • Create relationships between data from different data sources.

Afternoon Session

  • Rename columns, and create calculated columns.
  • Create Pivot Tables and Pivot Charts.
  • Add Slicers.
  • Create a measure.

For In-house Training:

Request for Quotation

Request for Quotation Now

For Content Customization & Other Inquiries:

Contact TED Integrated

Contact Customer Service

+603-2386-7788

Email Customer Service [email protected]

Ad by Google

Related Training Courses:

More Other Training Courses:

Published by: ,