Data Visualization Course

Advanced Financial Modeling Course

265 Reviews

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

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

Resource Requirement

TopicsOfferings
Laptop at Participant End
MS Excel 2007
Broadband connection

Course Structure

  • Excel auditing shortcuts
  • Formula auditing roads
  • Error tracing
  • 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
  • Data functions Project finance
  • Flexible models scenarios
  • Index match
  • Compounding
  • Leases with Facebook model example
  • Data base function
  • Inputs
  • Assets schedule
  • Debt schedule
  • Teriff sheet
  • Working capital
  • Optimization
  • Introduction VBA
  • Defining events using macro
  • VBA functions
  • VBA coding
  • Recording macro efficiently
  • User defined function using macro
  • Forecasting using Monte Carlo simulation
  • Primary and secondary axis
  • Radar charts
  • Waterfall chart details
  • Football field
  • Mekko chart

Schedule WHEN

 

Need more info?

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

* Mandatory Field

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

Who should do this? TARGET

Student should have hands on experience on Excel and brief idea about Finance, Balance Sheets and Cash Flow Models.

FAQsWHY?

Where can I get doubt clarifications?

`````````````````````````````````````````````````` courses.php Post ID = 104320