HOME
 

i3BAR – Integrated, Interactive & Intelligent Excel Models for Business Analytics & Reporting

BPP Professional Education
Course summary
18 hours
1,670 GBP excl. VAT
London
Next available date: 11/11/2019 - London

Course description

i3BAR – Integrated, Interactive & Intelligent Excel Models for Business Analytics & Reporting

This is a three-day intensive hands-on face-to-face certification course, plus an introductory Module 1 which will be covered as pre-course work via email, and ongoing post-course support.

Module 1 – Pre-course Work: Proficiency in Core Excel Functions

Covered via email, the skills taught in Module 1 will serve as great foundation for the upcoming modules, enabling participants to understand the use of core functions in the following clusters and their application in the right environment:

  • Referencing tools
  • Text functions
  • Lookup reference
  • Logical functions
  • Form controls

Module 2 – Day 1: Integrate Multiple Data Sources

  • Understand the key components of an integrated model
  • Input, logic and presentation blocks
  • Construct and design a database
  • Database design rules

Module 3 – Day 2: Build and Present Interactive Reports

  • Understand bad practices that lead to static reports
  • Discover the secrets of interactive reports illustrated in three case studies
  • Understand the principles of developing interactive charts that change at the click of a button
  • Incorporate interactive commentaries that auto-reflect changes made in data
  • Turn the integrated, interactive model into an easy to-navigate Board presentation

Module 4 – Day 3 - Budget Simulation and Intelligence

  • Common reasons for delay in budget completion
  • Design of input templates incorporating data validation and protection
  • Modelling business process to develop intelligent planning models for
    • Profit & Loss, Cash Flow and Balance Sheet
    • Capital Expenditure Approval Model
  • Common reasons for difficulties in creating an Excel model for 'what-if' analysis
  • Develop a 'what-if' simulation model to aid good decision making

Additional Support

In addition to the three-day hands-on training, i3BAR reinforces success through a comprehensive learning support system:

  • active community of practice: i3BAR alumni can tap into the network for additional support in Excel modelling. You will also be invited to networking, sharing and learning sessions to continue your learning journey
  • post course project work: you can opt to submit project work after the course, to build interactive Excel models that solve your current business needs. You will receive guidance in applying the newly acquired i3BAR concepts into your project work which is to be submitted four weeks after the course
  • certification of competency: this is awarded to all participants who successfully submitted and assimilated the i3BAR concepts in building a working model. This internationally recognised certificate is valued by employers as it confirms the participant's ability to solve business reporting needs

Suitability - Who should attend?

CFOs, financial controllers, accountants, finance managers and business managers who find generating management reports too time-consuming and rigid for analysis purposes. Good prior knowledge of Excel is assumed. In order to make optimal use of the course you must have been using Excel for at least two years.

Outcome / Qualification etc.

Successfully apply i3BAR techniques at work to provide fresh perspectives on business challenges and opportunities. Transform the nature of your role by freeing up significant time from reporting for added value analysis and critical projects. I3BAR will enable you to:

  • integrate data from disparate data sources into Excel
  • build reliable and sustainable Excel-based reporting models
  • construct interactive models for decision making
  • create scenarios and what-if analysis for budgets
  • produce visually attractive and impactful reports.

This course is Excel-driven but is not about Excel functions. Rather it concerns the application and combination of those functions in the most creative manner to meet your needs in the work place.

About provider

BPP Professional Education

BPP Professional Education -  Accountancy, Tax, Financial Services, Law & Insolvency Courses

BPP Professional Education is one of the specialist examination-based and professional development training arm of the BPP Group, Europe's biggest professional education and publishing provider with 2,000 staff members across 40 countries and over 30,000 students per year. BPP Professional Education...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about i3BAR – Integrated, Interactive & Intelligent Excel Models for Business Analytics & Reporting.

  Contact the provider

  Get more information

  Register your interest

Contact info

BPP Professional Education

3 London Wall Buildings
EC2M 5PD London

 Show phone number
www.bpp.com

Request information

Find out more about this i3BAR – Integrated, Interactive & Intelligent Excel Models for Business Analytics & Reporting course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here