Get 10% discount

Advanced Business & Financial Modelling using Excel 2010

Introduction

Business and financial modelling using Microsoft Excel are highly demanded professional affairs today. Though the course title emphasises heavily on business, finance and Microsoft Excel 2010, development of sophisticated, comprehensive and dynamic financial model requires a little bit more than the skills in finance and spreadsheet applications. To be a professional financial modelling analyst it requires skills in system development, database, system security, project management and networking besides skills in finance and Microsoft Excel.

Most of the contemporary training programs ignore these additional skills requirements. This course with the title “Advanced Financial Modelling with Microsoft Excel- Plan, Develop, Pack, Distribute and Protect” is developed with the objective of incorporating all these additional skills with the core finance and spreadsheet skills.
Learning Outcomes:
The course is designed for the professionals working in finance and accounting discipline having fundamental concepts of finance and Microsoft Excel.

1. Identify and Understand financial modelling scenarios and life cycle of a financial model and take necessary pre-development initiatives
2. Develop advance skills on Microsoft Excel Functions, Formulas and Referencing System
3. Understand and apply core and advance Financial functions needed in various financial activities
4. Understand risk management and take risk management decisions using What-if-analysis
5. Develop Costing, Budgeting and Other Financial Planning Models
6. Develop Investment analysis, Discounted Cash Flow Analysis and Portfolio Analysis Models
7. Making financial models dynamic using Control Tools
8. Implement security and sharing features as post-development activities

Methodology

The programme will be delivered using formal lectures combined with practical and interactive case studies and exercises. There will be a great emphasis on gaining practical experiences.

Contents of Training:


Chapter One:
Financial Modelling Scenarios and Life Cycle
Scopes of Financial Modelling
Life Cycle of a Financial Model
Data collection and Assumptions
Application of Microsoft Excel in Financial Models

Chapter Two:
Formulas, Functions and Referencing
Formulas with Absolute and Relative Referencing
Advanced Logical Functions
Advanced Lookup/Match/Index Functions
Accounting and Financial Functions

Chapter Three:
Advance Financial Functions
Time value of money functions
Financial Evaluation Functions
Costing and Budgeting Related Functions
Accounting Functions

Chapter Four:
Risk Management and What-if-Analysis
Risk Management in Finance
Goal Seek Analysis for Risk Management
Scenarios and Simulation
Advanced Referencing for Risk Management Models

Chapter Five:
Costing, Budgeting and Financial Planning Models
Develop model for costing and pricing products and services
Prepare production, overhead and sales budgets

Chapter Six:
Costing, Budgeting and Financial Planning Models
Prepare cash budget
Prepare pro-forma Financial Statements

Chapter Seven:
Investment Analysis and Planning Models
Develop a Investment Planning Model
Evaluate an Investment Project

Chapter Eight:
Investment Analysis and Planning Models
Discounted Cash Flow Analysis for Company Valuation
Portfolio Analysis Models

Chapter Nine:
Model Control Tools
Drop-down Box, Check-box and Radio Button
Vertical and Horizontal Scroll Bars
Buttons and other Components
Macros and VBA

Chapter Ten:
Post-Development Activities
Testing models, finding Errors using Excel’s Error Handling Tools;
Assigning Security
Adding Help Files and other Documents
Packaging the Model and Distributing

Related Courses

Md. Jehad Uddin
  • 26 - 27 Apr 2017 (2 Evenings)

This course is designed in such a way that participants ...

Accounts
Price 12,000 Tk + VAT
Dr. Md. Abdur Rouf
  • 28 Apr - 6 May 2017

Accounts
Price 5,000 Tk + VAT
Muhammad Arif-ur-Rahman
  • 5 - 13 May 2017 (4 evenings)

At the end of the course you will be a confident, skilful ...

Accounts
Enamul Haque Sujon
  • 7 May - 6 Jun 2017

Tally is a most powerful, yet very simple and easy, ...

Accounts

Contact

9140345, 9117179

certificate@bdjobs.com

Bdjobs.com Ltd.

19 th floor (East), BDBL Building (Old BSRS)
12 Karwan Bazaar
Dhaka - 1215

Business Managers and Finance professionals should join the course. Finance skills, Logical reasoning and fundamental IT skills are essential to successfully achieve the outcomes of the course.