Financial Modeling Forecasting and Analysis with R Excel

Financial Modeling, Forecasting and Analysis with R Excel

 Customize Training

  • Overview
  • Course Outline
  • Target Audience
  • Fees

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
 

Terms & Conditions

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

 

 

 

Please select the course date to enrol
No course date available

  Duration: 2 days
  Time: 9am to 6pm