Maximizing Pivot Table 2016/2019

Learn how to use Excel pivot tables more efficiently and effectively.


1 day
All levels
0 lessons
0 quizzes
0 students

Course Info

This course is for anyone who wants to learn how to use Excel pivot tables more efficiently and effectively plus experienced Excel users who have already use or want to use pivot tables for data analysis. Students will also learn how to produce and automate summary reports from large blocks of data in a matter of seconds.

What Will I Learn From This Course?

Creating PivotTables

Modifying PivotTable Calculations

Using VLOOKUP with the Pivot Tables

Advanced Pivot Table Options

Creating a PivotTable based on External Data

Creating Pivot Charts

Working Pivot Table with Macro


To ensure your success, we recommend that you have a good basic working knowledge of Excel. Students can obtain this level of skill through our Excel Foundation, Intermediate and Advance courses.

Course Outline for This Programme

  1. What is a PivotTable
  2. Identify the Source
  3. Creating the Pivot Table
  4. Working with Pivot Table Layout
  1. Rearranging the Layout
  2. Adding New Field
  3. Renaming a Field
  4. Formatting Numbers
  5. Changing Sorting Order
  6. Showing Top 10
  7. Refreshing Data
  1. Grouping Items
  2. Displaying Subtotals
  3. Hiding/Showing Grand Totals
  4. Formatting PivotTable
  5. Using Slicer (Only for 2010)
  6. Formatting Slicer (Only for 2010)
  1. Using Formulas
  2. Create a Calculated Field
  3. Create a Calculated Item
  4. Use the GETPIVOTDATA Function
  5. Turn Off the GETPIVOTDATA Function
  1. Creating a Pivot Table Based on External Data

  2. Create a Pivot Table Consolidated from multiple worksheets

  3. Page fields in consolidation

  4. A single page field

  5. Multiple page fields

  1. Creating PivotChart

  2. Edit and Format Pivot Chart

Curriculum is empty

Academic Qualifications
  • Diploma in Accountancy
  • ACCA (Association of Chartered Certified Accountants), UK

Professional Certifications
  • Pembangunan Sumber Manusia Berhad (PSMB) Certified Trainer
  • Microsoft Certified Trainer (MCT)

Julian specialises in conducting MS Excel application courses & seminars for various companies, local & multinationals. He teaches practical on-the-job experience, which translates to real-life exercises for participants’ benefit. Julian conducts various IT courses using Word Processors, Spread sheet, Database, Multimedia & Programming applications