Welcome to Corporate Excel TrainingClick to print this pagePrint
You are here: / Home

Corporate Financial Modelling Courses       Excel Courses       Project Financial Modelling Courses

Real Estate Modelling Course       Understanding Corporate Performance Course

Courses Currently Running
Courses 2010
Duration
Date(s)
    Specialised Excel Techniques → View Outline
2 Day
 ⇒ Sep 13 - 14
⇒ Oct 25 - 26
⇒ Nov 16 - 17
    Corporate Financial Modelling Masterclass → View Outline
3 Day
⇒ Sep 28 - 30
⇒ Oct 27 - 29
⇒ Nov 23 - 25
    Project Financial Modelling Masterclass → View Outline
3 Day
⇒ Sep 7 - 9
⇒ Nov 2 - 4
    Real Estate Financial Modelling Masterclass → View Outline
3 Day
⇒ Oct 5 - 7
⇒ Nov 9 - 11
Other Courses Available
Duration
Date(s)
    Excel for Executives
1 Day
on Request
    Understanding Corporate Performance
2 Day
on Request
    Specialised Excel Techniques & Corporate Financial Modelling Masterclass
4 Day
on Request
    Data Reporting & Analysis
2 Day
on Request
    Advanced Spreadsheet Techniques for Reporting - "In association with AuditExcel
2 Day
on Request
Book for these Courses Now

The Essential Advanced Reporting & Analysis Class
For Spreadsheet Users & Modellers

  • Data Clean-up
  • Enhance Data Manipulation Ability
  • Generate Improved Data Reporting
  • Reduce Time & Effort Through Advanced Techniques
  • Ensure Good Spreadsheet Design
  • Understand the Essentials for Well-designed Models

The Key Excel Functions & Skills
Necessary for All Excutives

  • Arrays, Formulae, Goalseeking
  • Working with Data Tables
  • Formatting, Grouping & Outlining
  • If Statements, Sumif, Countif
  • Pivot Tables, Max & Min,
  • Naming Cells, Ranges, Formulae
  • Reviewing & Protecting Spreadsheets
  • Working with Sheets, Scenarios, Sensitivity
  • Validation & Integrity

Understand the Critical Tools & Functions
Needed To Do the Job

  • Naming Cells, Ranges, Formulae
  • Validating & Protect your Data
  • Conditional Formatting, Drilling Down, Hyperlinks
  • Working With & Across Multiple Sheets, Summing
  • Create Data Tables Consolidate Data Files, Data Base
  • Logical Tests, Pivot Tables, Index, Match, Lookup
  • Work with Arrays, Formulae, Functions, Constants
  • Index, Match, Min, String, Grouping
  • Data Tables, Views, Offset, Rounding, Summing
  • Recording Macros, Assigning Macros, Setting Controls

Using Excel to Understand the Key Concepts
Of What Creates Profit & Adds Value

  • Accounting Terms
  • Elements of the Income Statement & Balance Sheet
  • Financial Statements & Working Capital
  • Ratios & Analysis
  • Cash Flow & Profit
  • Fixed & Variable Relationship
  • Breakeven
  • Forecasts & Budget
  • Evaluate Financial Statements

Hands-on Project Modelling Masterclass
Learn the Essential Functions & Techniques
Ensure Integrity & Clarity
Meet Best Practice Standards

  • Understand the Fundamentals of Sound Design
  • Reduce Time & Effort Using Advanced Functions
  • Understand and apply specific project modelling requirements
  • Enrich Your Modelling Skills Base
  • Reduce Potential for Errors
  • Ensure Integrity

  • Corporate Financial Modelling Masterclass: 5 Day
When booking for the full 5 Day course, simply add both Modules to your Shopping Cart.

Internationally Renowned
Specialised Financial Excel Techniques
& Modelling Master Class
Choose from 3 Modules

  • Essential everyday Excel Techniques
  • Combine these Techniques with Best Practice Modelling
  • Structured Steps to Build a Model from Scratch
  • Understand the Financial Relationships Inherent in the Model
  • Test the spreadsheets with Basic to Advanced methodologies

Hands-on Project Modelling Masterclass
Learn the Essential Functions & Techniques
Ensure Integrity & Clarity
Meet Best Practice Standards

  • Understand the Fundamentals of Sound Design
  • Reduce Time & Effort Using Advanced Functions
  • Understand and apply specific project modelling requirements
  • Enrich Your Modelling Skills Base
  • Reduce Potential for Errors
  • Ensure Integrity

Practical Real Estate Modelling
For Serious Real Estate Practitioners

  • Beneficial for Financial Officers, Management, Construction & Development Personnel
  • Best Practice Model Construction
  • Understanding Income Statement, Balance Sheet, Cash Flow Interaction
  • Create Project Models to handle Scenarios, Schedules, Balances, Statements
  • Cover WACC, NPV, IRR, Inflation, Drawdown, Comparison, Valuations, Validations

Based on years of hands-on experience in building complex financial models for a variety of industries, including banks, manufacturing, retail, mining, motor amongst others, Corporate Excel offers a range of financial, project, real estate and modelling courses based on MS Excel.

These application-driven, practical programmes range from 1-Day Executive courses to 5-Day comprehensive courses that introduce delegates to some of the advanced functions and routines in Excel, and leads them through various financial modelling techniques.

The courses focus on the basic nuts and bolts of financial model preparation and structure, and provide the delegates with useful modelling techniques that can be immediately applied in the work place.

The courses are hands-on and not intimidating. - Delegates work through various exercises under the supervision, and with the help, of the Course Director, to get to grips with practical modelling techniques and, as a valuable spin-off, the specialised Excel functions essential in the preparation of sound corporate financial models.

To The Top