The Excel Club offers an extensive core syllabus. The syllabus focuses on formula and functions, helping you become a master in Financial Modelling. Prior knowledge of Excel is required. In addition to the core syllabus The Excel Club regularly posts new tutorials on topics requested by the students.
Chapter 1
- Excel Basics
- Relative and Absolute cell references
- The Sum and Average functions
Chapter 2
- Logical Basic
- IF functions – Bank reconciliations
- IF functions – Commission calculation
- Conditional Formatting
Chapter 3
- Using Text in Excel
- Date and Time
- Custom formatting
- More Date math
Chapter 4
- Introduction to Arrays
- Table and Arrays
- More complex Array formula
- Advanced filter
- Pivot tables
Chapter 5
- Vlookup
- Vlookup – Dynamic invoice template
- Index and Match
- Choose
- Lookup Wizard
Chapter 6
- Future Value and interest
- Present and Net Present Value
- Payment
- Depreciation - Straight line
- Depreciation – Reducing balance
Chapter 7
- What if Analysis - One variable
- What if Analysis - Two variable
- Scenario manager
- Solver
Chapter 8
- Form controls
- Dynamic Chart using Form Controls and the Offset function
- Introduction to Macros
- Understanding errors
- Protecting workbooks and worksheets
- Consolidate function
Chapter 9
- Financial Modelling Tip’s
*Microsoft Excel 2007 has been used to make these tutorials, however workbooks are available in 2003 and earlier format. Download your free Office trial from the Microsoft website.