Financial Reporting in Excel
Designing periodic financial reports that are linked to the data, update automatically and are ready for management.
Course contents
- 1Linking reports to the trial balance
- 2Income statement and balance sheet templates
- 3Comparing periods
- 4Automatic updating
- 5Finishing the report for print and presentation
What you gain from the course
You can build periodic financial reports that update themselves and save the time spent preparing them each month.
Other courses in the same track
Analysis and reporting
Pivot Tables and Data Analysis
Summarising and analysing large data sets with pivot tables, slicers and calculated fields.
Interactive Dashboards
Building an interactive dashboard that presents key figures with charts and filters.
Financial Modeling
Building a model that links the three statements, with assumptions, forecasts and sensitivity analysis.