Financial Information Management and Reporting - Tools, Techniques and Methods

The techniques learned can play an important role in the successful implementation of strategic initiatives and directing operational decision-making.

Information and data sources. Distinguishing between data and information - Internal and external sources - Cost-benefit analysis

Management information systems. Design - Formal and informal systems

Data and information types

Data and information analysis. Modelling principles - Model design and construction - Modelling use

Use of spreadsheets. General rules - Creating worksheets - Importing and exporting data - Data extraction - Pivot tables and scenarios - Sorting and filtering data - Linking with other applications - Basic macros

Managing databases. General rules - Design and construction - Importing and exporting data - Sorting and filtering data

Information reporting. Use of graphics - Use of charts - The end user

Statistically modelling. Forecasting techniques - Regression analysis - Correlation strength between data - Time series analysis

Data mining. Functions and techniques

Managing data as a valuable resource
Data mining
Conducting financial analyses
Designing financial models
Creating financial forecasts
Preparing financial reports