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! »
Jan 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Tue 16 Jan 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Register Now!

* Other terms & conditions apply.
Mar 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Fri 02 Mar 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Register Now!

* Other terms & conditions apply.
Apr 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Tue 10 Apr 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Register Now!

* Other terms & conditions apply.
May 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Tue 15 May 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Register Now!

* Other terms & conditions apply.
Jun 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Thu 28 Jun 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Register Now!

* Other terms & conditions apply.
Jul 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Tue 24 Jul 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Register Now!

* Other terms & conditions apply.
Aug 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Thu 09 Aug 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Register Now!

* Other terms & conditions apply.
Sep 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 19 Sep 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Register Now!

* Other terms & conditions apply.
Oct 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Tue 16 Oct 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Register Now!

* Other terms & conditions apply.
Nov 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Tue 13 Nov 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
Register Now!

* Other terms & conditions apply.
Dec 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Fri 07 Dec 2018 9:00AM - 5:00PM
Fee Per Person:
RM1,060.00
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: ,