Course Detail(IT021Cv : Financial Data Management with Pivot Tables (Live Webinar))

IT021Cv : Financial Data Management with Pivot Tables (Live Webinar)

7.00 CPE Hours (Category 5)
Live Webinar

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.

Competency Mapping

Category 5 = 7.00 Hours

Schedule & Fees

Date & Time

07 Oct 2022 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 289.97
For Non-Members: $ 348.82

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

Online Classroom in or outside of
Singapore

Testimonial

Funding

No funding Available!

Programme Facilitator(s)


Dr Lim Thou Tin, DACE
 
Dr Lim Thou Tin is a business graduate with the National University of Singapore. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctor of business administration from Southern Cross University with current research interests in information systems and business modelling.

His work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organizational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia, and Thailand.

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.

Competency Mapping

Category 5 = 7.00 Hours

Programme Facilitator(s)

Dr Lim Thou Tin, DACE
 
Dr Lim Thou Tin is a business graduate with the National University of Singapore. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctor of business administration from Southern Cross University with current research interests in information systems and business modelling.

His work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organizational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia, and Thailand.


Upcoming Schedule

Date & Time

07 Oct 2022 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 289.97
For Non-Members: $ 348.82

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

Online Classroom in or outside of
Singapore