Advanced Financial Modeling Course

ONLINE TRAINING INR 12,600 onwards

About COURSE

EduPristine Advanced Financial Modeling Program will help you understand understanding the advanced techniques to quickly audit the robust models, advanced excel tools to build flexibility in the models, advanced application of functions in executing nitty-gritties of models, and advanced sensitivity, optimization, & charting techniques.

Methodology

Topics	Offerings
Case Study based Learning
Live Examples
Slide pack
Excel Models
24x7 Access to Online Materials
Certificate of Participation

Resource Requirement

Topics	Offerings
Laptop at Participant End
MS Excel 2007
Broadband connection

Course Structure

Module 1: Advanced Model Auditing Techniques >

Excel auditing shortcuts
Formula auditing roads
Error tracing

Module 2: Excel Tools: Working with Data >

Importing data from ERP systems or other external sources
Fetching data from web queries
Formatting imported data
Data mining using pivot tables
Converting data into tabular format
Conditional formatting including harvy balls InCell bars etc.
Identifying and removing duplicates

Module 3: Advanced Excel Functions >

Data functions Project finance
Flexible models scenarios
Index match
Compounding
Leases with Facebook model example
Data base function

Module 4: Optimization Case in Power Sector: Optimizing the Fixed and Variable Energy Charges in Power Model >

Inputs
Assets schedule
Debt schedule
Teriff sheet
Working capital
Optimization

Module 5: Advanced Excel using Macros >

Introduction VBA
Defining events using macro
VBA functions
VBA coding
Recording macro efficiently
User defined function using macro
Forecasting using Monte Carlo simulation

Module 6: Advanced Charting Techniques >

Primary and secondary axis
Radar charts
Waterfall chart details
Football field
Mekko chart

ENROLL NOW

Download Brochure

For corporate enquiries contactcorporate@edupristine.com

Schedule WHEN

Location	Start Date	Batch Type	Class Timing

Location	Start Date	Batch Type	Class Timing

Location	Start Date	Batch Type	Class Timing

Location	Start Date	Batch Type	Class Timing

Need more info?

Just drop in your details and our support team will reach out to you as soon as possible.

Need more info?

Benefits WHY?

At the end of the course, you will know the Advanced Model Auditing Techniques, Advanced Excel Functions, Advanced Excel using Macros and Advanced Charting techniques.

Reviews WHAT OTHERS SAY

Job well done!! The engagement with the EduPristine rep was favourable. The trainer, was knowledgeable. I like the fact that he has hands-on experience rather than just theory based.

Syahida Ismail Manager, Corporate Intelligence