Welcome to TED Learning!

  • 12-07, Binjai 8 Premium SOHO, No. 2 Lorong Binjai, 50450 Kuala Lumpur
  • Phone: +603-2742 1828
  • training@ted.com.my

Microsoft® Project 2013 Advanced Level - TED Learning

By tedadmin | March 14, 2018

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:

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

Course Outline

DAY 1

MORNING SESSION

  1. Import data from multiple data sources.
  2. Create linked data.
  3. Create relationships between data from different data sources.

AFTERNOON SESSION

  1. Rename columns, and create calculated columns.
  2. Create Pivot Tables and Pivot Charts.
  3. Add Slicers.
  4. Create a measure.
 Register Now

.

.

.

.

.

FEEL FREE TO ENQUIRE ABOUT OUR RANGE OF TRAINING COURSES