EXCEL in Financials

MDIS


Course introduction

Transitioning from the IT era to the IR4.0, efficiency is the key to survive the global competition. Modern businesses are likely to have accounting software from which data can be downloaded and processed into meaningful financial information. EXCEL is one of the indispensable tools to transform data into reports to address the needs in different business contexts. This course provides a platform for participants to enhance their spreadsheet building skills and encourage them to exploit the EXCEL functions to meet the workplace demands.



Course Benefits


Anyone (see prerequisite) who wishes to automate their financial reporting process.

Participants must possess acceptable accounting and advanced EXCEL knowledge to benefit optimally from this course.



Target Audience


Anyone (see prerequisite) who wishes to automate their financial reporting process.

Participants must possess acceptable accounting and advanced EXCEL knowledge to benefit optimally from this course.



Course Outline


  • EXCEL overview
  • Data design
  • Data retrieval
  • Data manipulation
  • Advanced EXCEL functions
  • Financial statement analysis tools
  • Creating a dashboard
  • Statement of cash flow
  • Corporate finance tools



Available Course Sessions


Please click here to stay updated on upcoming sessions.



Trainer Profile


Lawrence

Lawrence graduated with a degree in Economics and Japanese Studies from National University of Singapore. He is a Fellow with the Association of Chartered Certified Accountants, (FCCA), a member of the Institute of Singapore Chartered Accountants (ISCA), an Accredited Tax Practitioner (ATP) and a member of Singapore Institute of Directors (SID). He has bagged with him more than 20 years of field experience in accounts, finance, human resources, information technologies and training.

He is ACTA certified and Master in Applied Linguistics at National Institute of Education, Nanyang Technological University.



 

Top