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

SDF Funding, SkillsFuture Credit

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

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.

Competency Mapping

Others = 7.00 Hours

Schedule & Fees

Date & Time

05 Nov 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 331.70   $ 265.36
For Non-Members: $ 417.30   $ 333.84
Early Bird Discount till 30 Nov 2020

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

Online Classroom in or outside of
Singapore

Date & Time

20 Jul 2020 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Dr Lim Thou Tin

Date & Time

20 Apr 2020 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Dr Lim Thou Tin

Date & Time

05 Nov 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Dr Lim Thou Tin

Testimonial

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 14 July 2020
Course Ref No.: CRS-N-0019669

All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. The credits will not expire and periodic top-ups will be provided by the government. SFC may be accumulated to pay for skills related course fees. You may wish to use your SFC to pay for partial/full ISCA course fees.  (For more information on the SFC scheme, please visit http://www.skillsfuture.sg/credit)

If you wish to enrol for the course with SFC Funding, please proceed with the following steps:

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for SkillsFuture Credit?”, click “Yes” and input all required information. At the Cart page, please ensure that SFC funding is applied before clicking “Checkout”.
  • Step 2: After successful enrolment, please proceed to submit SFC claim on Skillsfuture Portal within 60 days before the course start date and obtain the necessary approval. Please submit SFC claim via SFC portal here: http://www.skillsfuture.sg/credit.

Failure to submit claim application and obtain necessary approval before the course start date will result in topping up of the SFC indicated for use. Please note that there will be an administrative fee of $42.80 for any revision of invoice.


2] WDA Training Grant - SDF Funding
This course is approved for SDF funding ($2 per training hour) for Company-sponsored participants only (Eligibility criteria apply). 

Funding Period: Until 14 July 2020
Funded Hours: 7 hours
Course Ref No.: CRS-N-0019669

If you wish to enrol participants with SDF Funding, please proceed with the following steps (For Corporate enrolments only) :

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for WDA Funding?”, click Yes and input all required information. At the Cart page, please ensure that SDF funding is applied before clicking “Checkout”.
     
  • Step 2: After successful enrolment, please proceed to submit the Training Grant application via SkillsConnect Portal here: https://www.skillsconnect.gov.sg/

Employers of company-sponsored participants must submit training grant via SkillsConnect system to obtain training grant for course fees. You may submit the Training Grant application within the period from 30 days before the course start date to 30 days after course start date. Please note that there will be an administrative fee of $42.80 for any revision of invoice.

Eligibility Criteria:

  • Company must be registered or incorporated in Singapore and;
  • Applicant is taking the course for the first time.
  • Applicant must be employed, and is either Singapore Citizen or Permanent Resident of Singapore and;
  • Applicant must achieve at least 75% attendance, and pass all examinations /assessments and;
  • Applicant must be fully sponsored by the Company for all costs associated with the training and;
  • Payment has to be made via corporate means (e.g. corporate cheque, corporate GIRO, corporate credit card).

Programme Facilitator(s)


Dr Lim Thou Tin
DBA, MKM, MInfSys, DipSA, DipIntelligentSys
DipMgtConsultancy, DipT&D, BBA, MFP (FAAFM)

 
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. He is a fellow of the American Academy of Financial Management.
 
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.

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

Others = 7.00 Hours

Programme Facilitator(s)

Dr Lim Thou Tin
DBA, MKM, MInfSys, DipSA, DipIntelligentSys
DipMgtConsultancy, DipT&D, BBA, MFP (FAAFM)

 
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. He is a fellow of the American Academy of Financial Management.
 
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

05 Nov 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 331.70   $ 265.36
For Non-Members: $ 417.30   $ 333.84
Early Bird Discount till 30 Nov 2020

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

Online Classroom in or outside of
Singapore