Course Detail(IT008C : Essential Excel Spreadsheet Skills)
Not Available

UTAP Funding

IT008C : Essential Excel Spreadsheet Skills

14.00 CPE Hours (Category 5)
Classroom
Please wait...

Notice
 

To reduce the environmental impact and contribute to sustainability efforts, ISCA will contribute our part by eliminating the printing of course materials for selected courses with effect from 2023.

Tips: To make your paperless learning experience more enjoyable, you may bring along a digital device such as a Windows based laptops or tablets to read your online materials during the class. QR code will be provided in the class for you to download the materials in PDF.

Join us and be a Difference Maker!

 




This programme is formerly known as “Advanced Excel Spreadsheet Skills”

Software Installation and Laptop

As this class places strong emphasis on the hands-on experience, you will be working with data for the majority of the time in the class. To optimize the learning experience, it is mandatory for all participants to be equipped with a Window laptop, pre-installed with Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version.



Programme Objective

It has been said that the 95/5 rule applies in the Excel spreadsheet world. 95% of the users used only 5% of its power. Most users realized that they could further harness the power of Excel if they could have a better handle of its structure, formulas and functions. This is much complicated by the incomprehensive jargon and procedures.

Nothing is more powerful than having clear and accurate data to make meaningful and useful decisions about your company, business units, product cycles, sales projections and operating requirements in order to forecast your business futures. This programme is directed at the businessperson who needs to use Excel in their everyday job to improve decision-making and productivity.

Programme Outline

 
  • Spreadsheet Concept & Structure
  • Effective spreadsheet structure
  • Designing input & output areas
  • Macro designing & the use of subroutines
  • Setting up data test plan Building Basic Formulas
  • Understanding formula basics
  • Controlling the order of precedence
  • Controlling worksheet calculation
  • Working with range names & links in formulas Creating Advanced Formulas
  • Working with arrays
  • Applying data validation rules to cells
  • Using dialog box controls on a worksheet Spreadsheet Calculation Techniques
  • Working with Excel’s functions
  • Building megaformulas with function nesting
  • Using Lookup tables & the If functions
  • Understanding & using NPV, IRR, SPB, DPB, NFV, MIRR, etc
  • Solving circular references Spreadsheet Consolidation & Linking
  • Linking data between worksheets
  • Working with Consolidate interface
  • Interfacing with other applications
  • Working with Pivot Tables & Scenarios Charting Techniques & Presentation
  • Representing data in charts
  • Plotting data interactively
  • Controlling graphic objects Auditing & Debugging
  • Understanding Error values
  • Testing the cell logic
  • Auditing a worksheet

Training Methodology

Lecture style, with computer hands-on Exercises
 
Closing Date for Registration

1 Week before Programme or Until Full Enrolment

Intended For

Business analysts, financial modellers, accountants, bankers, finance managers, financial analysts, financial controllers, financial advisers and others who wish to add spreadsheet design, spreadsheet security and advanced modelling to their skill sets. It appeals especially to those who need to build skills and confidence in complex spreadsheet systems in the area of finance and business, accounting, banking, and insurance.

Competency Mapping

Category 5 = 14.00 Hours

Schedule & Fees
Date & Time

04 Sep 2025 (9:00 AM - 5:00 PM)
05 Sep 2025 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)


SGD pricing -

For Members: $ 935.22
For Non-Members: $ 1,110.71


Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Testimonial


Lecturer is very experienced and detailed. Learn alot of extra excel skills which didnt know they exist. Hope it will help in daily working reports.

Alison Teo


The lecturer is very helpful and experience. He thought us a lots of shortcut and functions that we can use on our daily work.I learned a lot thru this course. It very useful.

Iwan


Interactive and hands on session. Discovered many useful tips for excel. Dr Lim is very knowledgeable on the content and is very interactive.

Sim Pei Pei


I have learned new excel skills from this course which will be useful in working environment.

Fong Wei Ling


The course gave me additional knowledge in excel shortcuts and creating formulas. Dr. Lim is very accommodating in answering our questions. I can apply the things that I learned at work.

Kristal Medina


Many useful formula was thought in class which can be applied to work and increase productivity

Past Participant

Funding

1] NTUC Union Training Assistance Programme (UTAP)
UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members.
 
To find out more on the UTAP funding and support validity period please click here.
 
Should you have queries on the funding scheme, you can email to UTAP@e2i.com.sg or call NTUC Membership Hotline at 6213-8008

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.

Notice
 

To reduce the environmental impact and contribute to sustainability efforts, ISCA will contribute our part by eliminating the printing of course materials for selected courses with effect from 2023.

Tips: To make your paperless learning experience more enjoyable, you may bring along a digital device such as a Windows based laptops or tablets to read your online materials during the class. QR code will be provided in the class for you to download the materials in PDF.

Join us and be a Difference Maker!

 




This programme is formerly known as “Advanced Excel Spreadsheet Skills”

Software Installation and Laptop

As this class places strong emphasis on the hands-on experience, you will be working with data for the majority of the time in the class. To optimize the learning experience, it is mandatory for all participants to be equipped with a Window laptop, pre-installed with Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version.



Programme Objective

It has been said that the 95/5 rule applies in the Excel spreadsheet world. 95% of the users used only 5% of its power. Most users realized that they could further harness the power of Excel if they could have a better handle of its structure, formulas and functions. This is much complicated by the incomprehensive jargon and procedures.

Nothing is more powerful than having clear and accurate data to make meaningful and useful decisions about your company, business units, product cycles, sales projections and operating requirements in order to forecast your business futures. This programme is directed at the businessperson who needs to use Excel in their everyday job to improve decision-making and productivity.

Programme Outline

 
  • Spreadsheet Concept & Structure
  • Effective spreadsheet structure
  • Designing input & output areas
  • Macro designing & the use of subroutines
  • Setting up data test plan Building Basic Formulas
  • Understanding formula basics
  • Controlling the order of precedence
  • Controlling worksheet calculation
  • Working with range names & links in formulas Creating Advanced Formulas
  • Working with arrays
  • Applying data validation rules to cells
  • Using dialog box controls on a worksheet Spreadsheet Calculation Techniques
  • Working with Excel’s functions
  • Building megaformulas with function nesting
  • Using Lookup tables & the If functions
  • Understanding & using NPV, IRR, SPB, DPB, NFV, MIRR, etc
  • Solving circular references Spreadsheet Consolidation & Linking
  • Linking data between worksheets
  • Working with Consolidate interface
  • Interfacing with other applications
  • Working with Pivot Tables & Scenarios Charting Techniques & Presentation
  • Representing data in charts
  • Plotting data interactively
  • Controlling graphic objects Auditing & Debugging
  • Understanding Error values
  • Testing the cell logic
  • Auditing a worksheet

Training Methodology

Lecture style, with computer hands-on Exercises
 
Closing Date for Registration

1 Week before Programme or Until Full Enrolment

Intended For

Business analysts, financial modellers, accountants, bankers, finance managers, financial analysts, financial controllers, financial advisers and others who wish to add spreadsheet design, spreadsheet security and advanced modelling to their skill sets. It appeals especially to those who need to build skills and confidence in complex spreadsheet systems in the area of finance and business, accounting, banking, and insurance.

Competency Mapping

Category 5 = 14.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

04 Sep 2025 (9:00 AM - 5:00 PM)
05 Sep 2025 (9:00 AM - 5:00 PM)
Fee (inclusive of GST)


SGD pricing -

For Members: $ 935.22
For Non-Members: $ 1,110.71


Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709


Other courses you might like

View Courses 
7.00
CPE Hours
Classroom

Time Saving Excel Tips and Tricks for Admin /Finance/ HR Professionals (Classroom)

14 Apr 2025 - 14 Apr 2025

  • UTAP
7.00
CPE Hours
Classroom

Transforming Accounting and Finance: Leveraging RPA, ChatGPT, and Copilot for Efficiency and Innovation

22 Apr 2025 - 22 Apr 2025

  • UTAP
21.00
CPE Hours
Blended Learning (with Live Webinar + Classroom)

Business Analytics and Reporting (Blended Learning)

25 Apr 2025 - 29 Apr 2025