Or log in to access your purchased courses

Mastering Excel Pivot Tables

Learn how Pivot Table analyses and presents data in an easy-to-understand way

Introduction 引言

Pivot Table is one of the more advanced and complicated features of Microsoft Excel, but many oversee the benefits of using it to generate analysis and data summaries. It can be used for viewing, summarizing and analyzing the information in multiples ways to give you an insight into the data. In this course you will learn how a Pivot Table works and the skills and techniques to use the tools effectively.

Course Objectives 課程目標

  • Creating a Pivot Table
  • Customizing fields in a Pivot Table
  • Formatting Pivot Table report
  • Using Pivot Tables for summary and presentation
  • Creating and using Pivot Charts
  • Using external data sources for a Pivot Table
  • Leveraging the power of OLAP Cubes

On course completion, you will have a good understanding of the functionality of Excel Pivot Tables and be able to analyse, summarise and present data in an effective way.

  • Qualified and experienced instructors
  • Easy-to-follow, step-by-step hands-on learning approach
  • Best practices explained and demonstrated
  • Weekday and weekend classes available

Modules

Mastering Excel Pivot Tables

Lessons