This session is delivered via live webinar (zoom platform) and includes a AER e-learning module to be completed before you attend the live webinar. The mode of delivery for this programme has been changed to blended learning. This programme includes a 3.5-hour e-learning module with self-practice exercises and a 3.5-hour live webinar with hands-on exercises. TFor more information on how to access and use the E-Learning Course, please download a copy of the user guide here . Programme ObjectiveThis one-day practical course aims to train participants with the knowledge and ability to apply advanced excel functions for business analysis and financial reporting. Participants will also learn the fundamentals of transforming basic formulas to interactive formulas to support dynamic and sustainable reports.This programme also serves as a primer for the Business Analytics & Reporting (BAR) course.
This session is delivered via live webinar (zoom platform) and includes a AER e-learning module to be completed before you attend the live webinar.
The mode of delivery for this programme has been changed to blended learning. This programme includes a 3.5-hour e-learning module with self-practice exercises and a 3.5-hour live webinar with hands-on exercises. T
For more information on how to access and use the E-Learning Course, please download a copy of the user guide here . Programme ObjectiveThis one-day practical course aims to train participants with the knowledge and ability to apply advanced excel functions for business analysis and financial reporting. Participants will also learn the fundamentals of transforming basic formulas to interactive formulas to support dynamic and sustainable reports.This programme also serves as a primer for the Business Analytics & Reporting (BAR) course.
Overview of ExcelThe following formulas will be covered in a 3.5 e-learning module with self-practice exercises.A. Cell ReferencesRelative vs. Absolute referencingNamed Ranges B. Using Functions to Lookup and Reference to DatabaseMatchHlookup / VlookupChoose C. Text FunctionsConcatenateLeftRightMidThe following 3 formulas will be covered in a 3.5 Hours live webinar with computer hands-on exercises: D. Using Functions to Manage Data:Logical functionsMathematical functionsE. Using Functions to Lookup and Reference to Database: OffsetIndex F. Placing controls on a worksheet: FormsCreating interactivity using combo box, spinner and scroll barMaking choices using check box or option box on a worksheetLinking a control to worksheet dataPre-requisitesPlease take note of the following admission requirements:Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsoryMandatory for video camera to be turned on throughout the courseDisplay your official name (as per NRIC) in Zoom, to facilitate attendance takingTraining MethodologyThis programme includes a 3.5-hour e-learning module with self-practice exercises and a 3.5-hour live webinar with computer hands-on exercises. Closing Date for Registration1 week before programme or until full enrolment.
Overview of ExcelThe following formulas will be covered in a 3.5 e-learning module with self-practice exercises.A. Cell References
B. Using Functions to Lookup and Reference to Database
C. Text Functions
The following 3 formulas will be covered in a 3.5 Hours live webinar with computer hands-on exercises:
D. Using Functions to Manage Data:
E. Using Functions to Lookup and Reference to Database:
F. Placing controls on a worksheet:
Please take note of the following admission requirements:
Training MethodologyThis programme includes a 3.5-hour e-learning module with self-practice exercises and a 3.5-hour live webinar with computer hands-on exercises. Closing Date for Registration1 week before programme or until full enrolment.
This programme is especially suitable for those who need to build skills and confidence in complex spreadsheet systems in the area of finance and business, accounting and banking. This is also a pre-requisite for the Business Analytics & Reporting (BAR) programme.
Category 5 = 7.00 Hours
09 May 2024 (9:00 AM - 12:30 PM)
For Members: $ 274.68 For Non-Members: $ 329.62
12 Jul 2024 (9:00 AM - 12:30 PM)
20 Sep 2024 (9:00 AM - 12:30 PM)
06 Nov 2024 (9:00 AM - 12:30 PM)
Past Participant
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.
Jasmine NgCA (Singapore), FCCA, ACTA, DACEJasmine Ng is a Fellow member of the Association of Chartered Certified Accountants (ACCA) and a member of the Institute of Singapore Chartered Accountants (ISCA). She has over 18 years of extensive experience in the area of audit, accounting, financial analysis, business controlling, enterprise system implementation and training. She travelled extensively during the course of her work and gain exposure to different culture and work style.She utilizes her creativity and real-world examples in conducting her training. Jasmine is passionately fond of training and always willing to share with others all that she knows. Her outgoing, pleasant personality and confident disposition have made her training all the more lively, fun and insightful.
Online Classroom in or outside ofSingapore
You are about to leave ISCA eServices Portal and the registration link will be opened in a new tab. Do you wish to continue?
This course has been added successfully
Declaration to be provided by CPE
This Course is Intended for CA Singapore Users..
If you have an account with us, please sign-in first. If you do not have an account with us, create one now for free.
Do you wish to apply for SFC funding? (Singapore Citizenship Only)
05 Apr 2024 - 05 Apr 2024
08 Apr 2024 - 09 Apr 2024
17 Apr 2024 - 17 Apr 2024