PowerPivot 2013 Training for Excel

PowerPivot 2013 Training for Microsoft Excel PowerPivot 2013 for Microsoft® Excel
By TED Integrated
Microsoft® Excel Series:

PowerPivot 2013 for Microsoft® Excel

“A Self-Service Business Intelligence”

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
Course Title:
PowerPivot 2013 for Microsoft® Excel
Training Category:
Information Technology
Target Audience:
Excel Power Users, data analysts, business analysts, managers, MIS professionals and BI Consultants/ BI Developers.
Duration:
1 Day
Public Training Events
Feb 2017 ›
Venue:
Binjai 8, KLCC, Kuala Lumpur, Malaysia
Schedule:
Fri 10 Feb 2017 9:00AM - 5:00PM
Fee Per Person:
RM1,000.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
May 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Tue 30 May 2017 9:00AM - 5:00PM
Fee Per Person:
RM1,000.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Jun 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Fri 16 Jun 2017 9:00AM - 5:00PM
Fee Per Person:
RM1,000.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

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

* Other terms & conditions apply.
Sep 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Tue 26 Sep 2017 9:00AM - 5:00PM
Fee Per Person:
RM1,000.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Oct 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Tue 31 Oct 2017 9:00AM - 5:00PM
Fee Per Person:
RM1,000.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

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

* Other terms & conditions apply.
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Computer Lab Work
  • Internet Access
  • Participant Presentation
  • Certificate of Participation
*Terms & Conditions

Course Introduction ›

This is a 1-Day PowerPivot 2013 training for Microsoft® Excel. It is designed for Excel Power Users, data analysts, business analysts, managers, MIS professionals and Business Intelligence (BI) Consultants and Developers who wants to transform their valuable business data into a more meaningful and analytical information. It allows you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and Pivot Charts, and then further analyze the data for timely business decision making purposes with little to no involvement of your IT supports.

To request for in-house training, click on the Request for In-house Training link as displayed above for quotation. For a complete course cotent and more information about this course, feel free to contact the training provider as shown above. If the public program is available, you can request for a registration online by clicking on the Register for Public Training link. If the link is disabled, it simply means it has yet to be available for public. You can contact the training provider for further inquiry.

Course Objectives ›

In this training, you will use PowerPivot to:

  • Import external data from multiple sources.
    • Client database
    • Excel tables
    • CSV files
  • Handling massive data from multiple sheets.
  • Create relationships between multiple tables.
  • How to create a user friendly models
  • Perform calculations in Power Pivot
    • Calculated columns.
    • Measures (Calculated fields)
  • Create PivotTables and Pivot Charts.
  • Introduction to Data Analysis Expression language (DAX)

Prerequisites ›

Participants must be proficient users of Excel and experienced in creating Excel PivotTables and PivotCharts.

Course Outline ›

DAY 1

Introduction to PowerPivot

This module explains what PowerPivot is and how you can download and install the power pivot on your computer.

  • What is Power Pivot
  • Limitation of the normal Pivot Table
  • The Power Pivot Interface

Handling Data in Power Pivot

This module explains how to bring your data into Excel whether it's an external source, text files, Excel data and other sources. It also shows you how to build relationships between tables which is vital to data analysis.

  • Importing Data
  • Creating Linked Tables
  • Managing Relationships
  • Creating Your Power Pivot Table

Power Pivot at Work

This module explains how to use create and format your reports as creating reports from Power Pivot may differ from a normal pivot table. It also touches on making your data model more user friendly for end users.

  • Creating and customizing reports that are user friendly
  • Formatting your Numbers
  • Customizing your data model
  • Performing calculations with calculated columns
  • Performing calculations with calculated fields
  • Working with dates
  • Using slicers

Introduction to DAXS

PowerPivot has its own syntax for defining calculation expressions. It is conceptually similar to an Excel expression, but it has specific functions that allow you to create more advanced calculation on data stored in multiple tables.

  • DAXS operators
  • Calculated Columns
  • Calculated Fields
  • Date calculations

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-2386-7788
Email Customer Service E-mail : [email protected]

Related Courses ›

Published by: ,