Advance Excel Training for Financial Modeling

This course is designed for business professionals who need to explore the practical usage of advanced excel functions in a financial model. By creating your own user-friendly financial model, you will learn to translate business concepts into a structured format to identify weaknesses and predict future performance.

•   Discover how to measure and interpret the performance of your company using Excel modelling
•   Create your own reliable model to identify weaknesses and predict future performance
•   Gain an in-depth understanding of how to build a business case
•   Learn how to enhance the decision-making process
•   Translate business concepts into logically structured models and formats
•   Learn to prevent incorrect use of your model by protecting worksheets
•   Learn to Validate data entry by setting data entry parameters
•   Learn to Create drop-down boxes which enable a model to produce a series of results depending       on scenario variable selected

Finance Managers, CA professionals, CFO

Well versed with various Excel formulas or must have taken up the basic and intermediate level in Excel.

Duration : 8 hours

Introduction to Financial Modeling

Principles of Financial Modeling

• Steps in model buliding • Designing for flexibility and scalability • Designing for consistency • Designing for usability and functionality • Designing checks and balances • Using VBA in financial models

Principles of Risk and Return

• Volatity • Capital Structures • Weighted Average Cost of Capital • Cost of Equity Capital

Company Valuation:Theory and Application

• Analysing past performance • Forecasting future performance • Discounted cash flow modelling • Sensitivity analysis • Capitalisation of earning • Interpreting results

Control of Finacial Models

• Why audit? • Excel's auditing tools

Excel Intermediate Training : Duration 5 hours

Range Names

• Concept and Purpose • Naming individual or range cells • Deleting and amending named ranges • Using named cells/ranges in formulae

Conditional Functions & Formats and Date Calculations

• Benefits and purpose • If Statements , Nested If • And, Or, Not • Combining If, And, Or, Not • Sumif , Countif • Conditional Formatting • Entering Dates and Times • Different date/time formats • How dates are stored • Calculating working days • Using the DAY(),MONTH(),YEAR() functions

Formulae Auditing

• Formula Auditing Tools • Revealing Formulae • Tracing Precedents/Dependents • Goto Special

Worksheet Management & Linking

• Linking sheets in the same file • Linking different Excel files • Using Edit, Links • Viewing different files at once • Saving a workspace • Viewing different sheets at once • Window Split • Data consolidation

Basic List Management

• Sorting Data • Adding Subtotals • Autofilter • Freeze Panes • Group and Outline • Data Form

Excel Charts / Graphs

• Using the Chart Wizard • Editing and Formatting charts • Saving custom chart types • Setting a default chart type

Pricing    

Online Instructor Led Training on Excel - How it works ?

You can listen to our instructor, interact with him on a one-to-one basis, access his computer screen from your desktop, make changes on his excel sheet, and get your doubts clarified instantly.

 

  COURSE FEE  US$ 499

Group Training

Encouraging the live interactions with the trainer as well as the understanding of Excel applications in various domains, Group Training on Advance Excel is scheduled on Weekends (Saturday & Sunday) at our premises.

Batch Size:12

Please call +91 91766 33246 / +91 91766 33247 for further details.

Individual Training

If you need self spaced training, Excelgoodies provides you with an option of Inividual Training which can be scheduled on any of the weekdays (Monday - Friday) at our premises.

Please Call +91 91766 33246 for further details.

For Corporate

We offer private hands-on training courses that can be held at your company's site. Our Onsite Corporate Training Packages go beyond the standard excel training and can be tailored according to the needs of the organisation and knowledge level of the employees.

Minimum Batch Size : 10

Click Here to request for quote

For Colleges and Universities

Our Services are now available on demand at Colleges and Universities

Minimum Batch Size : 25

Click Here to request for quote

System Requirements