Duration: 2 days
Time: 9am to 6pm

What Will Be Taught For This Excel Financial Modelling Course?

R an open-source software combines well with Excel to offer a good balance of ease-of-use, flexibility and efficiency in financial modeling, and is becoming a standard in the financial community. A reasonable level of efficiency requires good knowledge in the R programming language besides Excel.

The intensive course will teach Excel users how to harness additional programming power in the context of building R/Excel financial spreadsheet models. The sessions will emphasize technical issues to give the participants the tools needed for the latter sessions which will focus on familiar spreadsheet financial models which participants have already acquired. A short introduction into each topic is offered during the lectures, generally accompanied with examples. This course will be held in an interactive fashion where participants have the chance to instantly work with each presented example using a building block approach in learning.

Learning Outcome

  • Learning how to develop sophisticated spreadsheet models using R programming language.
  • Gaining hands-on experience on how to build Excel spreadsheet models.
  • Learning how to improve your current spreadsheet models.
  • Knowing what is spreadsheet models and its limitations.
  • Increasing your skills and capabilities in building advanced financial and corporate models.
Module 1 : Using Spreadsheet an Financial-Modeling Languages
  • What is Modeling
  • Spreadsheets Models and Limitations
  • Overview of how R can improve Spreadsheet Models
  • R Model Design Principles
Module 2 : Introduction to R Development in Excel
  • R Development Features
  • The R Editor
Module 3 : Getting Started with R
  • Models Development
  • Understanding Variables and Constants
  • Using R Expressions
  • Using Built-in Functions
Module 4 : Arrays in R
  • The Need for Arrays
  • Rules for Working with Arrays
Module 5 : Control Logic and Loops
  • Using Control Structure
  • Conditional Constructions
  • Iterations in R
Module 6 : More on Variables and Subroutines
  • Scope of Variables and Subroutines
  • Arguments Passing
  • Writing R Functions
Module 7 : Integrating an R Application
  • Handling Errors in R
  • Enhancing your Models using Dialog Boxes

Who Should Attend This Excel Financial Modelling Course Training?

Pre-requisite

The participants are assumed to have fundamental knowledge of Excel and already have foundational knowledge in financial, statistical and econometric concepts. The course is beneficial to software developers, programmers, analysts, consultant from financial and accounting fields.

  w/o GST w GST
Course Fee $1,200 $1,284

Remarks:

COMAT is a business centre of e-Services, Electronics, ST Engineering.

Terms & Conditions

  • All prices stated above are in Singapore Dollars (SGD).
  • e-Services, Electronics, ST Engineering reserves the right to change the date or venue without prior notice.
  • e-Services, Electronics, ST Engineering reserves the right to cancel or reschedule the course due to class size or unforeseen circumstances.



Please click on the course date to enrol.