ADVANCED PIVOT TABLE TECHNIQUES IN MICROSOFT EXCEL

SIM

Course overview

Categories

Digital Tools

Course date

23-06-2023 to 23-06-2023

13-07-2023 to 13-07-2023

16-08-2023 to 16-08-2023

15-09-2023 to 15-09-2023

18-10-2023 to 18-10-2023

08-11-2023 to 08-11-2023

20-12-2023 to 20-12-2023

Provider

SIM

Course type

Instructor-Led

Course fee

(including GST)

Course Fee GST 8% : $302.40

Funding/Subsidy

SkillsFuture Credit

ADVANCED PIVOT TABLE TECHNIQUES IN MICROSOFT EXCEL


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.


Course benefits

·      Build PivotTables from single or multiple data sources

·      Add calculated fields, filter your results

·      Format your layout to make it more readable.

Course outline

·      Introduction to PivotTable

·      Working with PivotChart

·      Managing PivotTable

Duration

1 Day

Course runs

Who should attend?

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

Programme leader

Course fee

COURSE FEES AND GRANTS

S$302.40 per participant (Incl. GST)

Applicants may use SkillsFuture Credit for this course


Enquiries: Please contact Colin @ colinkwok@sim.edu.sg