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
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
| Date | Time | Venue | Registration Closing Date | Register |
|---|---|---|---|---|
| 16-08-2023 to 16-08-2023 |
09.00 - 17.00 | ASK Training | 02-08-2023 |  |
| 15-09-2023 to 15-09-2023 |
09.00 - 17.00 | ASK Training | 01-09-2023 | |
| 18-10-2023 to 18-10-2023 |
09.00 - 17.00 | ASK Training | 04-10-2023 | |
| 08-11-2023 to 08-11-2023 |
09.00 - 17.00 | ASK Training | 25-10-2023 | |
| 20-12-2023 to 20-12-2023 |
09.00 - 17.00 | ASK Training | 06-12-2023 | |
| 23-06-2023 to 23-06-2023 |
09.00 - 17.00 | ASK Training | 09-06-2023 | |
| 13-07-2023 to 13-07-2023 |
09.00 - 17.00 | ASK Training | 29-06-2023 | |
Who should attend?
Level 2 - Supervisor, Executive, & Emerging Managers
Level 4 - Managers
Level 5 - Senior Managers & Directors
Programme leader
Course fee
| Programme Fee | Amount (including GST) | Remarks |
|---|---|---|
| Course Fee GST 8% | $302.40 | - |
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