Certificate and Executive Programs

Certificate in Business Analytics and Reporting (i3BAR)

DATE

DEC 06 - DEC 21

2022

TIME

8:30 AM - 12:00 PM

WHO CAN ATTEND

All

PD HOURS

21 Hours

ETHICS HOURS

0 Hours

STATUS

Registration closed on

Nov 30, 2022

EVENT DESCRIPTION

This course is offered online over six, half-day, live, instructor-led sessions. All sessions include regularly scheduled breaks and breakout rooms for virtual networking and group discussions. Recordings of all sessions will be available to all registrants.

Register early to take advantage of our $300 off discount!

 VIEW/DOWNLOAD THE BROCHURE

SCHEDULE

  • Tue, Dec 6, 2022 @ 8:30 AM - 12:00 PM
  • Thu, Dec 8, 2022 @ 8:30 AM - 12:00 PM
  • Tue, Dec 13, 2022 @ 8:30 AM - 12:00 PM
  • Thu, Dec 15, 2022 @ 8:30 AM - 12:00 PM
  • Mon, Dec 19, 2022 @ 8:30 AM - 12:00 PM
  • Wed, Dec 21, 2022 @ 8:30 AM - 12:00 PM

Upgrade your Excel reporting models to increase speed and accuracy.

Presented in partnership with the Institute of Business Analytics, this six half-day, CPA Ontario certificate program focuses on the Excel Models for Business Analytics and Reporting (i3BAR) methodology designed to build interactive Excel models with speed and accuracy. You will gain hands-on experience through case studies, practical exercises, and create a simulated Excel reporting model of your own.

This program will teach you how to create Excel models that automate your reporting and reduce routine reporting time from days to minutes. It is recommended participants have at least two years of experience with MS Excel.

KEY TAKEAWAYS

  • Integrate data from disparate data sources into Excel
  • Build reliable and sustainable Excel reporting models
  • Construct interactive models for decision making
  • Create scenarios and what-if analysis for simulations, appraisals and planning models
  • Produce visually attractive and impactful reports
  • Present directly from Excel, while making Excel look like PowerPoint

Successful completion of this program, including the post-course project, will entitle participants to a Certificate in Business Analytics and Reporting from the Institute of Business Analytics.

Who will Benefit:

Accounting and finance professionals who need to produce financial and non-financial information for senior stakeholders; anyone wanting to automate and improve their spreadsheet-based Excel reporting and analytics; and those looking to support or lead future analytics and reporting projects.

You might also be interested in our Certificate in Visual Analytics and Dashboards (i2VSA).

NEED APPROVAL TO ATTEND?

  EMPLOYER REQUEST LETTER

PRICING

$3625.00 Member

$3625.00 Student

$4175.00 Public

Status: Registration closed on Nov 30, 2022

LOCATION

Online

SPEAKER(S) BIO

Simon Lindley is an international trainer, speaker and consultant in business transformation through analytics. He brings expertise in visual analytics and dashboard design to transform the role and performance of finance teams. Simon is a Chartered Accountant, Chartered Engineer (IT) and MBA with a Masters Diploma in corporate governance. He also has training and qualifications in statistics and data science.

Simon Lindley

SPECIAL INSTRUCTIONS

This three day course is now being offered as six half day live morning sessions. All six sessions will be recorded and available for viewing should you miss a certain day or would simply like a refresher. Please see the schedule below:

.

SCHEDULE

  • Tue, Dec 6, 2022 @ 8:30 AM - 12:00 PM
  • Thu, Dec 8, 2022 @ 8:30 AM - 12:00 PM
  • Tue, Dec 13, 2022 @ 8:30 AM - 12:00 PM
  • Thu, Dec 15, 2022 @ 8:30 AM - 12:00 PM
  • Mon, Dec 19, 2022 @ 8:30 AM - 12:00 PM
  • Wed, Dec 21, 2022 @ 8:30 AM - 12:00 PM

  • Participants must bring a laptop with Excel 2007 or above. Those with Apple MacBook can also benefit from the course but must be familiar with the differences in function keys from Windows.
  • There will be pre-learning materials two weeks before the course start date.
  • To access the course please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.

    Please allow at least four hours after registration for the seminar to appear on your BlackBoard page.

    Registration, cancellation, withdrawal and all other CPA Ontario PD Seminar policies can be found here.