Please be informed that in view of the current COVID-19 situation, we will be changing the format of this course into a Live Webinar. A detailed set of instructions on the Live Webinar will also be sent to you closer to date. Please sign up for a Zoom account (https://zoom.us/) if you currently do not have an account.
PS: Your laptop has to be equipped with either Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version. Working files will be sent to you before the live webinar.
Notice
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
You may opt to bring along your laptop if you wish to use Excel 2013.
Programme Objective
Pivot table is one of the most powerful features of Excel, yet few accountants use them in their day-to-day activities. For some, pivot tables are too intimidating and for others, pivot tables are unknown. With a little instruction and guidance, you will be using pivot tables to accomplish routine analysis and reporting.
Excel: Pivot Tables will begin with basic pivot tables and progress to advanced pivot table topics. Topics covered in this session will include drag and drop pivoting, grouping and ungrouping, calculated items and fields, pivot tables consolidated from multiple ranges, and pivot tables dynamically linked to external databases and your financial accounting system.
Programme Outline
How You Will Benefit:
- Pivot Tables: An overview
- Creating Pivot Tables
- Working with Pivot Table components
- Calculations in a Pivot Table
- Securing a Pivot Table
- Working with Pivot Chart
- Analyzing multidimensional data with Pivot Table
- Automating a Pivot Table
To view our full list of Infocomm courses, please click here.
Pre-requisites
Please take note of the following admission requirements:
- Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
- Mandatory for video camera to be turned on throughout the course
- Display your official name (as per NRIC) in Zoom, to facilitate attendance taking
Training Methodology
Lecture style, with computer hands-on Exercises
Closing Date for Registration
1 Week before Programme or Until Full Enrolment
Intended For
Pre-requisite: Participants in this course would have already been using or have used Pivot Tables in their organization and wish to go beyond the basics of Pivot Tables for analysis and reporting. Anyone who want to learn how to use Excel pivot tables more efficiently and effectively, plus experienced Excel users who use or want to use pivot tables for data analysis.
Schedule & Fees
Testimonial
Funding
No funding Available!
Programme Facilitator(s)
Please be informed that in view of the current COVID-19 situation, we will be changing the format of this course into a Live Webinar. A detailed set of instructions on the Live Webinar will also be sent to you closer to date. Please sign up for a Zoom account (https://zoom.us/) if you currently do not have an account.
PS: Your laptop has to be equipped with either Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version. Working files will be sent to you before the live webinar.
Notice
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
You may opt to bring along your laptop if you wish to use Excel 2013.
Programme Objective
Pivot table is one of the most powerful features of Excel, yet few accountants use them in their day-to-day activities. For some, pivot tables are too intimidating and for others, pivot tables are unknown. With a little instruction and guidance, you will be using pivot tables to accomplish routine analysis and reporting.
Excel: Pivot Tables will begin with basic pivot tables and progress to advanced pivot table topics. Topics covered in this session will include drag and drop pivoting, grouping and ungrouping, calculated items and fields, pivot tables consolidated from multiple ranges, and pivot tables dynamically linked to external databases and your financial accounting system.
Programme Outline
How You Will Benefit:
- Pivot Tables: An overview
- Creating Pivot Tables
- Working with Pivot Table components
- Calculations in a Pivot Table
- Securing a Pivot Table
- Working with Pivot Chart
- Analyzing multidimensional data with Pivot Table
- Automating a Pivot Table
To view our full list of Infocomm courses, please click here.
Pre-requisites
Please take note of the following admission requirements:
- Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
- Mandatory for video camera to be turned on throughout the course
- Display your official name (as per NRIC) in Zoom, to facilitate attendance taking
Training Methodology
Lecture style, with computer hands-on Exercises
Closing Date for Registration
1 Week before Programme or Until Full Enrolment
Intended For
Pre-requisite: Participants in this course would have already been using or have used Pivot Tables in their organization and wish to go beyond the basics of Pivot Tables for analysis and reporting. Anyone who want to learn how to use Excel pivot tables more efficiently and effectively, plus experienced Excel users who use or want to use pivot tables for data analysis.
Programme Facilitator(s)
