Attend 1-day course on “Advanced Pivot Table Techniques in Microsoft Excel” to use Advanced techniques to summarize and analyze your Excel data effectively. As you may already know that Excel’s most powerful analytical tool is the PivotTable. But how can we optimise this tool further by uncovering the best features that Excel has offer to you?
In 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.
At the end of this course, you should be able to:
You will be learning the following:
S$299.60 per participant (Incl. GST)
Click here for UTAP Fundings
SDF Subsidy for Company Sponsored Individuals: WSQ Courses. For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.
Applicants may use SkillsFuture Credit for this course
Absentees will be charged the full course fee.
For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.