Course Overview

This course will be conducted by ASK TRAINING PTE LTD

Attend our 1-day course on “Advanced Pivot Table Techniques in Microsoft Excel” to use Advanced techniques to summarize and analyze your Excel data effectively. However, as you may already know that Excel’s most powerful analytical tool is the PivotTable. But how can we optimize this tool further by uncovering the best features that Excel has offer to you?

During this course, you’ll be taught how to leverage PivotTables to summarize, sort, count, group and chart your data in Microsoft Excel. You will also learn how to navigate the complexity of PivotTables to take advantage of their power. By the end of the course, you will be able to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable.

Who should attend?

Level 2 - Supervisor, Executive, & Emerging Managers
Level 4 - Managers
Level 5 - Senior Managers & Directors

Course fee