Powerful Data Analysis & Data Modeling in PowerPivot for MS Excel 2013

Loading Events

« All Events

Powerful Data Analysis & Data Modeling in PowerPivot for MS Excel 2013

January 16, 2018 @ 9:00 am - January 17, 2018 @ 5:00 pm

Introduction:

This program is designed for advanced Microsoft Excel users who may work or be interested in the domains of finance, statistics, project analysis, market analysis or general data manipulation. They will have a need to create PivotTables on a regular basis and to produce reports with multiple PivotTables/PivotCharts to produce ‘Business Intelligent’ type dashboard reports.

What Will You Learn:

Upon successful completion of this program, learners will 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;
  • distribute PowerPivot Data.

Target Group:

This program is designed for advanced Microsoft Excel users who may work or be interested in the domains of finance, statistics, project analysis, market analysis or general data manipulation. They will have a need to create PivotTables on a regular basis and to produce reports with multiple PivotTables/PivotCharts to produce ‘Business Intelligent’ type dashboard reports.

Pre-requisite

Before attending this program, learners need to be able to:

  1. good knowledge of Microsoft Excel;
  2. basic knowledge of Database Relationships (preferable but not unnecessary);
  3. good knowledge of Excel formula/function to manipulate data;
  4. understand the features of PivotTables, such as the areas designed for fields.

 

Details

Date:
16 - 17 January 2018
Time:
9:00 am - 5:00 pm
Event Category:

Venue

PENANG SKILLS DEVELOPMENT CENTRE (PSDC)
1, Jalan Sultan Azlan Shah,
11900 Bayan lepas,
Penang, Malaysia
Go to Top