PowerPivot for MS Excel 2013 - Workshop 2017

PowerPivot for Excel 2013 is a powerful data analysis tool that delivers unmatched computational power directly within Excel. With this add-in to Excel, you can transform mass quantities of data with significant speed into meaningful information to get the answers you need.

Key topics covered:

  • Using and Create Database
  • Introduction to PowerPivot
  • Working with Multiple Table Data Sources
  • PowerPivot Functions
  • Using PowerPivot to build report

Trainer profile:

Ms. Chan
DynaSys Solutions Limited

Ms. Chan has expertise in a variety of Microsoft systems and applications, especially for Microsoft Office applications. She has already conducted many Microsoft Office seminars and workshops for different level of users. Ms. Chan has also been providing a wide variety of computer training courses for various organisations and is a frequent speaker in tailor-made training programs on Microsoft Excel and Adobe software. Her special expertise in teaching all levels of Microsoft Office and Adobe software from a practical standpoint has made her one of our most requested trainers.

Learning objectives

  • Understand how to create and use Database
  • Use a wide variety of data sources within PowerPivot
  • Working with DAX (Data Analysis Expressions)
  • Create calculations within PowerPivot
  • Create Report with Data from PowerPivot


This workshop is designed for intermediate/advanced Microsoft Excel professionals who may work or be interested in the domains of finance, statistics, project analysis, market analysis or general data manipulation.

6 hours