Devices and data
The videos stream real-time, so you will be required access to a good data network or broadband / Wi-Fi network. Videos compatible on Android and iOS Excel 2010 onwards for Exercises compatibility.
Course Modules
1. Financial Accounts Introduction – an overview of the primary financial statements and how they interact. Fundamental accounting concepts with a focus on matching / accruals. WE review the 4 ‘categories’ of financial transactions – Assets, liabilities. Income, expenditure. 2. Exercises on the accounting ‘flow’ – a downloadable set of 3 exercises that guide you
Course includes
Videos – 32 videos each of 10-15 minutes long to allow flexible learning in YOUR timeframe Exercises – 19 downloadable Excel exercises Solutions – solution files plus video debrief from your experttutor Learning management – access to a dashboard, summarising your progress and providing learning access Certificate of Completion – CCT is an accredited learning
Pre-requisites
This program is for delegates new to the world of accounting and finance – perhaps interns or junior analysis and new-hires, or non-finance mangers who want to get into more detail. No prior accounting knowledge is required but you may be using the course as a refresher. Recommended: Our Finance for the Non-Finance Manager
Devices and data
The videos stream real-time, so you will be required access to a good data network or broadband / Wi-Fi network. Videos compatible on Android and iOS Excel 2010 onwards for Exercises compatibility.
Pre-requisites
This program is for delegates who use, review or build financial models but are perhaps self-taught. The only pre-requisites are the Excel Skills for modelling if new to Excel, and /or the Introduction to Accounting and Analysis which will ensure you know the links between financial statements and understand the concepts of working capital, depreciation,
Course Modules
1. Introduction and Golden Rules of Model design – Setting the scene and what the model will look like. 2. Recasting the accounts – A review of how financial statements might need to be re-cast to make them usable in a model. A downloadable exercise will use Excel tools and functions such as Data Validation
Course includes
Videos – 38 videos each of 10-15 minutes long to allow flexible learning in YOUR timeframe Exercises and models – the completed forecast model is downloadable in 8 different stages of completion so you can see section by section, with the tutor, how the model builds. Solutions – solution files plus video debrief from your
Course Modules
Module 1 - Financial Accounts – an overview of the accounting information relevant to finance and financial analysis. Why it is useful and where it falls short. We review the structure and content of the P&L and see how it builds with an Excel-based downloadable exercise. Module 2 - Ratios and Key Terms - his
Course includes
Videos – 51 videos each of 10-15 minutes long to allow flexible learning in YOUR timeframe Exercises – 14 downloadable Excel exercises Solutions – solution files plus video debrief from your experienced tutor Learning management – access to a dashboard, summarising your progress and providing learning access Certificate of Completion – CCT is an accredited