FINANCIAL MODELLING

While knowing Microsoft Excel's basic and intermediate capabilities is beneficial, for some, simply automating the day-to-day mathematical processes involved in a simple balance sheet may not suffice to meet a major company's financial accounting needs. A more in-depth knowledge is required.
This course will equip you with the skills to significantly improve your company’s control of its financials.

The following topics are covered:
• Creating reports from multiple sources
• Simplifying reporting
• Reconciliation model
• Creating reports where actuals, budgets and prior years change with lists
• Compiling an age analysis in five minutes
• Amortisation tables

• Unit 1: Creating reports from multiple sources
  1. Creating a pivot table to use as a database
  2. Consolidating multiple pivot tables
  3. Updating multiple pivot tables

• 
  Unit 2: Converting multiple columns into a database format
  1. Converting multiple columns into a
     database format

• Unit 3: Simplifying reporting
  1. Introduction
  2. Setting up the structure
  3. Checking source data
  4. Consolidating source data
  5. Creating a mapping table, mapping data and
     validating mapping
  6. Completing the report

• Unit 4: Automatic reconciliations
  1. Introduction
  2. Numbering data automatically and making it
     unique
  3. Steps in reconciling data (one list)
  4. Reconciling two list

• Unit 5: Reporting by using the indirect formula
  1. Introduction
  2. Using indirect formula to report on column
     format data

• Unit 6: Compiling an age analysis
  1. Introduction
  2. Fixing the dates and calculating the number
     of days
  3. Creating a mapping table
  4. Finishing an age analysis and reporting

• Unit 7: Amortisation tables
  1. Amortisation tables where the rates stay
     consistent
  2. Amortisation tables where the rates and
     capital payments can change

• Unit 8: Cash flows
  1. Introduction
  2. Fixing the signage
  3. Creating adjustment columns
  4. Creating a mapping table
  5. Finishing the cash flow statement