i3BAR | Integrated, Interactive & Intelligent Excel Models for Business Analytics & Reporting
"A revolutionary approach to analysis and reporting which will reduce the time spent from days to minutes. Discover how to use simple spreadsheet functions to create interactive reports, dynamic charts and automated.
Course Description
“A revolutionary approach to analysis and reporting which will reduce the time spent from days to minutes. Discover how to use simple spreadsheet functions to create interactive reports, dynamic charts and automated.
HOW THIS IS ADDRESSED?
The i3bar – Certificate In Business Analytic and Reporting is a best practice methodology for Excel applications development. It provides a standard approach using simple formulate and logical structuring of data, logic, and reporting to produce reliable, robust, and maintainable models. These can also be highly interactive enabling users to carry out their own analysis directly or enabling the model to be used to present and answer user
WHO SHOULD ATTEND?
Suitable for anyone who produces reports in MS Excel regularly.
It is recommended that i3BAR participants should have at least two years prior experience working with MS Excel.
The 3-day i3BAR does not teach excel functions, it emphasizes on solving actual workplace reporting challenges through structure and methodology. It is IMPORTANT that participant practices the few good functions in the pre-learning materials BEST attending the class.
LEARNING OBJECTIVES
At the end of the program, participants will be able 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
- Produce visually attractive and impactful reports
WHAT YOU WILL LEARN?
i3BAR teaches you to create reliable and interactive MS Excel models with no additional software or licenses required. A revolutionary approach to analysis and reporting which will reduce reporting time from days to minutes.”
Discover how to use simple spreadsheet functions to create interactive reports, dynamic charts and automated commentary. i3BAR provides the skill to build integrated Excel models that improves your speed, accuracy and interactivity in the reporting process. So do you want to transform your regular analysis and reporting and reduce the time spent from days to minutes? This course is a revolutionary approach and meets your unique business challenges at a fraction of the time take compared to your standard practice and process. It enables you to present concise information to management quickly and with maximum data integrity.
This is a 3-day intensive hands-on Certification course.
DAY ONE | iBAR principles & modelling techniques
- Design rules for the 3 block structure of an integrated model (input, logic and presentation blocks) enabling data to be smoothly integrated from multiples sources into multiple reports
- The 2 stages of model building; constructing the foundation and creating the “data bridge” for automating updates.
- 7 essential principles of making sustainable spreadsheet models (finance or non-finance) that are easy to maintain and structured to support future changes and development
- 5 steps to data transformation – turning what you have into what you want
DAY TWO | Build and Present Interactive Reports
- Securitizing performance obligations
- Bonds and guarantees
- Parent company guarantees
- Letters of intent, comfort, or awareness
- Insurance policies
- Assessing the need for financial security
DAY THREE | Resolving Disputes Simulation, What-if Decision Models
- Proper budget simulation and “what if” analysis; building assumptions tables and modeling using the four cost behavior types for expense simulations
- Commonly overused and misused techniques (including Vlookup, Pivot Tables and Macros), where, when and why they should be used to manage file size, performance and maintainability
- Develop a ‘what-if’ simulation model to aid good decision making
CERTIFICATION
This is awarded to all participants who successfully submitted and assimilated the i3BAR concepts in building a working model. This internationally recognized Certificate is valued by employers as it confirms the participant’s ability to solve business reporting needs.
REINFORCING THE LEARNING
In addition to the 3-day hands-on training, IBA 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 a 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 4 weeks after the course.
i3BAR COURSE JOURNEY
You can opt to submit a 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 4 weeks after the course.
1)Pre learning materials 2 weeks before class
2) i3BAR hands-on files 2 days before class
3) i3BAR manual and project submission materials on 1st day of class
4) Project submission reminder 2 weeks after class
5) Project submission reminder 4 weeks after class
6) Project submission acknowledgment upon submission
7) Receive Certificate of Competency on successful completion 6 to 8 weeks after submission
ALL MATERIALS WILL SENT VIA EMAIL. ALL SESSIONS WILL BE RECORDED AND MADE AVAILABLE ON REQUEST.
ALL REGISTRATION CLOSING: 1ST AUGUST 2022
- 28, 29 & 30 September 2022
- Johannesburg, South Africa
- In-Person
- Virtual
- REGISTRATION CLOSING: 1 AUGUST 2022
Contact Us
- registration@peganix.org.za
- +2711 041 0181
- +2768 053 6221