Financial Modeling Advanced Techniques Using Excel, VBA and Xcelsius

DESKRIPSI

Tujuan :

Pelatihan ini merupakan gabungan antara pelatihan :

• Financial Modeling for Sensitivity & Scenario Analysis and Dynamic Chart
• Financial Modeling for Interactive Business Dashboard, ditambah dengan berbagai tips & tricks financial modeling tingkat lanjut
• Pelatihan ini sangat berguna untuk membekali peserta agar dapat lebih kreatif didalam membangun financial model.

Syllabus :

• Logical Functions: IF, nested IF
• Math Functions: SUM
• Statistical Functions: MAX, MIN
• Lookup and Reference Functions: OFFSET, INDEX
• Date and Time Functions: DATE, DATEDIF
• Information Functions: ISERROR
• Range Names
  • Naming one cell
  • Naming Row
  • Naming relative reference
  • Conditional Formatting
  • Data Validation
  • Combo Box
  • Spinner
  • Recording Macro for Button plus

Siapakah yang harus hadir :

• CFOs
• Directors / Managers of Strategic Planners
• Financial Controllers
• Financial Analysts
• Accountants
• Corporate Finance Personnel
• Treasury Personnel
• Risk Managers
• General Managers
• Corporate and Government officers

Waktu :

• 2 hari kerja, 09.00 am ? 05.00 pm, diselingi 2 kali coffee break dan 1 kali istirahat makan siang

Course Leader :

Irwin Ibrahim

More...