Course Detail()

7.00 CPE Hours (Others)
Classroom

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.

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.

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)


No course instances or course instance sessions available.