Simple spreadsheet functions will be used to create interactive reports, dynamic charts, automated and stored commentaries. You will also learn to create, edit and combine Macros in order to automate activities. This course meets your unique business challenges at a fraction of the time taken compared to your standard practice and process. It enables you to present concise information to management quickly and with maximum data integrity. Successfully apply i3BAR techniques at work to provide fresh perspectives on business challenges and opportunities. The logical structure and approach will also result in models that can be maintained, grow and be taken over by others where traditional ad-hoc approaches typically become problematic.

Post Project Course Work
You will be guided in applying the new BAR concepts to build interactive Excel models to resolve current work issues.

Certificate of Competency
An internationally recognised Certificate of Competency is awarded to participants who successfully submitted and assimilated the BAR concepts in building a working model.

Integrate Multiple Data Sources

Understand the Key Components of an Integrated Model

• Input, data, logic and presentation blocks
• Design and construct data structures for ease of update maintenance and analysis
• Understand and avoid bad practices that lead to static reports
• Discover the secrets illustrated in three case studies

Build & Present Interactive Reports

• Understand the principles of developing interactive tables charts, sorted data and visualisation techniques. This includes charts and tables that can change month/ data type/ content at the click of a button
• Incorporate interactive commentaries that auto-reflect changes made in data and have the ability to store and retrieve ad-hoc commentary, actions, notes alongside your reports
• Turn the integrated, interactive model into an easy-to-navigate board presentation

Budget Simulation & Intelligence

Modelling Business Processes to Develop Intelligent Budget and ‘what-if’ simulation models

• P&L, cash flow and balance sheet
• Capital expenditure authorisation model
• Other simulation you may need based on categorisation and application of four key approaches to simulation