Build comprehensive financial models using Excel or specialised software, covering topics like forecasting, budgeting, valuation, and scenario analysis. Additionally, you’ll explore advanced techniques for modeling financial statements, performing sensitivity analysis, and making informed business decisions based on these models.

“While there is a lot of value in mastering the basic and intermediate array of functions offered by Microsoft Excel, for some, simply automating the day-to-day arithmetic functions involved in a simple balance sheet will not be enough to meet the financial accounting needs of a large company and 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”

Course Content

  • Creating a pivot table to use as a database
  • Consolidating multiple pivot tables
  • Updating multiple pivot tables
  • Converting multiple columns into a database format
  • Introduction
  • Setting up the structure
  • Checking source data
  • Consolidating source data
  • Creating a mapping table, mapping data and validating mapping
  • Complete the report
  • Introduction
  • Numbering data automatically and making it unique
  • Steps in reconciling data (one list)
  • Reconciling two lists
  • Introduction
  • Using indirect formula to report on column format data
  • Introduction
  • Fixing the dates and calculating the number of days old
  • Creating the mapping table
  • Finishing the age analysis and reporting
  • Amortisation table where the rates stay consistent
  • Amortisation tables where the rates and capital payments can change
  • Introduction
  • Fixing the signage
  • Creating adjustment columns
  • Creating a mapping table
  • Finishing the cash flow statement
  • Non-accredited: Short course only  
  • Duration: 1h 30m
  • Delivery: Classroom/Online/Blended
  • Access Period: 12 Months 
Print Button
Scroll to Top