CONNECT WITH US!

(02) 8616 8079

0917 113 1154

Head Office: 6F Salustiana D. Ty Tower Paseo de Roxas cor. Perea St. Legaspi Village, Makati City

Philippines

Training Center: 5F National Life Insurance Company Building, 6762 Ayala Avenue, Makati City Philippines

© 2016-2017 Phoenix One Knowledge Solutions, Inc.

MS Excel PowerPivot

DURATION: 16 hours (2 days)

Prerequisites

Participants who want to attend this training should have at least an intermediate knowledge in Microsoft Excel Working with familiarity in Data Analysis, Advance Logical, Lookup, and Nesting Functions.

Course Description

Perhaps the best feature of Microsoft Excel is its ability to provide a more agile and highly cost-effective approach to Business Intelligence which has been made possible by PowerPivot.  It extends the things you already know about Excel, rather than having to start from scratch. 

 

Learn the in-depth tools available in PowerPivot so you can analyze huge amounts of data quickly and accurately.  This course will enable you to create business intelligence reports out of Microsoft Excel using the power of Power Pivot.

Course Objectives

At the end of this course, the participant should be able to:

  • Learn how to connect, analyze and visualize massive amounts of data from familiar interface of Excel from different external sources.

  • Explore the power of Data Model and how to integrate structure to Microsoft Excel.

Course Coverage

  • Understanding PowerPivot

  • PowerPivot Data Source

  • Data Model

  • Pivot Table from PowerPivot Design

  • DAX Overview

Who Should Attend

Finance or accounting executives, data analysts, marketing executives, business managers and any professionals who deal with generating reports and would like to create a graphical representation using the power of Microsoft Excel.