Event Details

About

2013 TRAININGS |BEST FINANCIAL MODELING MS EXCEL TRAINING |FINANCIAL MODELING MS EXCEL ONLINE COURSE |FINANCIAL MODELING MS EXCEL TRAININGS ONLINE |FINANCIAL MODELING MS EXCEL TRAINING IN HYDERABAD | INDIA | UK | USA | CANADA ASTRALIA |FINANCIAL MODELING MS EXCEL ONLINE TRAINING

course contents:

Ecorp Trainings, one of the best institute providing quality level of training in E-learning & Corporate Services.

We offer instructor led online training. Classroom trainings are conducted in Hyderabad , India.

We provide training for almost all IT technologies,i.e : Documentum, SAP , ORACLE , JAVA , DOTNET , STORAGE products,HYPERION etc.

for more details please visit-

 http://www.ecorptrainings.com/financial-modeling-with-ms-excel-online-training-in-hyderabad-india.php

Course Contents 

Spreadsheet modelling techniques

Basic structure (separation of data from processing & output)

Cell referenced formulas (no hard coding of data)

Modularisation (break a complex model into simple bits)

Prototype development and refinement

Sensitivity analysis

Troubleshooting and debugging

Reasonability testing (common sense)

Microsoft Excel functions and methods useful for modeling

Named cell ranges

Lookup functions

Conditional functions (IF, COUNTIF, SUMIF)

Financial functions (IRR, NPV)

Formula nesting (pros and cons)

Autofilters

Advanced filters

Goal seeking

Conditional formatting

Navigation buttons

Automating your model with macros

Pros and cons

Setting the macro security level

Recording and running simple macros

The Visual Basic editor

Modifying a recorded macro for general use.

Protecting your model from undesired changes

Model structure

Locking cells

Worksheet and workbook protection

Password protection

Cross checks and error reports

Data validation

Output presentation (tips for effective reporting of results)

The importance of documentation

Spreadsheet model multimedia

Adding sound to your model

Providing video with your model

Make your model talk

Contact

ECORP TRAININGS.

Training Coordinator.

UK :+44-203-468-0685

USA : +1-703-445-4802

INDIA: +91-8143111555 ; +91-40-64643304 / 06

URL : www.ecorptrainings.com

Email : training@ecorptrainings.com

www.ecorptrainings.com/financial-modeling-with-ms-excel-online-training-in-hyderabad-india.php

Schedule

January 17, 2014 — 9:00 am to
December 17, 2018 — 6:00 pm

Add to your calendar

Venue

ECORP TRAININGS