Course Detail(IT008C : Essential Excel Spreadsheet Skills)

SDF Funding, SkillsFuture Credit, UTAP Funding

IT008C : Essential Excel Spreadsheet Skills

14.00 CPE Hours (Others)
Classroom


Notice
This programme is formerly known as “Advanced Excel Spreadsheet Skills”
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

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
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

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

Others = 14.00 Hours

Schedule & Fees

Date & Time

09 Mar 2020 (9:00 AM - 5:00 PM)
10 Mar 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

15 Jun 2020 (9:00 AM - 5:00 PM)
16 Jun 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

09 Sep 2020 (9:00 AM - 5:00 PM)
10 Sep 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

09 Dec 2020 (9:00 AM - 5:00 PM)
10 Dec 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

11 Dec 2019 (9:00 AM - 5:00 PM)
12 Dec 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Dr Lim Thou Tin

Date & Time

09 Sep 2019 (9:00 AM - 5:00 PM)
10 Sep 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Dr Lim Thou Tin

Date & Time

12 Jun 2019 (9:00 AM - 5:00 PM)
13 Jun 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Dr Lim Thou Tin

Testimonial


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

Fong Wei Ling


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


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

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 5 December 2020
Course Ref No.: CRS-N-0023353

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 5 December 2020
Funded Hours: 14 hours
Course Ref No.: CRS-N-0023353

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).

 

3] NTUC Union Training Assistance Programme (UTAP)
UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members. NTUC member gets to enjoy UTAP funding 50% of the unfunded course fee capped at $250 every year. This excludes miscellaneous fees such as GST and registration fee etc.
 
This course is approved for UTAP support for intakes conducted between 01 April 2019 – 31 March 2020.
 
As UTAP is given on calendar year basis, and calculated based on year of training taken, it cannot be accumulated.

  • Maintained paid-up NTUC membership before course, throughout course duration and at the point of claim and;
  • Course by training provider must be supported under UTAP and training must commence within the supported period and;
  • Unfunded course fee must not be fully sponsored by company or other types of funding
  • Unfunded course fee must be S$20.00 and above, and;
  • Member must achieve a minimum of 75% attendance for each application and sat for all prescribed examination(s), if any and;
  • UTAP application must be made within 6 months after course ends.


To submit for UTAP claims, please visit http://skillsupgrade.ntuc.org.sg/. Terms and conditions apply.
 
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
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.


Notice
This programme is formerly known as “Advanced Excel Spreadsheet Skills”
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

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
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

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

Others = 14.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

09 Mar 2020 (9:00 AM - 5:00 PM)
10 Mar 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709