Course Curriculum
Module 01: The Balance Sheet | |||
The Balance Sheet | 00:29:00 | ||
Module 02: The Income Statement | |||
The Income Statement | 00:25:00 | ||
Module 03: The Cash Flow Statement | |||
The Cash Flow Statement | 00:25:00 | ||
Module 04: Planning your Financial Model | |||
Planning your Financial Model | 00:09:00 | ||
Module 05: Building a Model Template | |||
Building a Model Template | 00:13:00 | ||
Module 06: Financial Reporting | |||
Financial Reporting | 00:26:00 | ||
Module 07: Analysing Profitability | |||
Analysing Profitability | 00:24:00 | ||
Module 08: Credit Analysis | |||
Credit Analysis | 00:32:00 | ||
Module 09: Equity Analysis | |||
Equity Analysis | 00:17:00 | ||
Module 10: Ratio Analysis | |||
Ratio Analysis | 00:28:00 | ||
Module 11: Visualizing Data with Charts | |||
Create Charts | 00:13:00 | ||
Modify and Format Charts | 00:12:00 | ||
Use Advanced Chart Features | 00:13:00 | ||
Module 12: Using PivotTables and PivotCharts | |||
Create a PivotTable | 00:13:00 | ||
Analyze PivotTable Data | 00:12:00 | ||
Present Data with PivotCharts | 00:08:00 | ||
Filter Data by Using Timelines and Slicers | 00:11:00 | ||
Module 13: Automating Workbook Functionality | |||
Apply Data Validation | 00:13:00 | ||
Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
Work with Macros | 00:18:00 | ||
Module 14: The fundamentals of Organisational Reporting | |||
The Fundamentals of Organisational Reporting | 00:17:00 | ||
Module 15: Current State | |||
Current State | 00:03:00 | ||
Module 16: Review Data | |||
Review Data | 00:03:00 | ||
Module 17: Define Requirements | |||
Define Requirements | 00:03:00 | ||
Module 18: Survey key Stakeholders | |||
Survey key Stakeholders | 00:04:00 | ||
Module 19: Gap analysis | |||
Gap analysis | 00:03:00 | ||
Module 20: Build the First Report | |||
Build the First Report | 00:04:00 | ||
Module 21: Get feedback | |||
Get feedback | 00:03:00 | ||
Module 22: Amend the Reporting | |||
Amend the Reporting | 00:04:00 | ||
Module 23: Roll out | |||
Roll out | 00:04:00 | ||
Module 24: Continuously Improve | |||
Continuously Improve | 00:03:00 |