Log in

  Institute of


Business Analysis Everywhere

Log in

Skill Builder Online Workshop - Intermediate Excel Functions and Formulas - Sat June 20

  • 11 Aug 2020
  • 7:00 PM - 10:00 PM
  • Online


  • Currently enrolled in a post secondary institution. Email for password.

Registration is closed

Skill Builder Online Workshop 

Intermediate Functions & Formulas

3 Hour Hands On Workshop

August 11, 2020

10:00 AM to 1:00 PM


Excel is a very powerful spreadsheet program, which can analyze business data in more ways than one could count. Most people use less than 10% of its capabilities. Imagine if you could not only learn more functions and formulas, but also learn in which scenarios to use them, and even how to combine functions together to solve business problems!

Let us help you build your skills! The Toronto IIBA Chapter has established a series of 3-hour workshops for you to achieve ‘EXCELlence’. You choose your starting point, and go as far as you need/want.

In this Intermediate Functions and Formulas workshop, you will learn to process and analyze volumes of data by:

    • Entering formulas with linked cells in the same worksheet, different worksheet or different workbook
    • Using two different modes while editing a cell/formula
    • Relative cell referencing, absolute cell referencing, mixed cell referencing – for single cells or multiple cells (range)
    • Quick ways to copy/paste
    • VLOOKUP (single or multiple criteria)
    • Recognizing if a cell is number or text

    Every participant will leave the session with greater comfort and confidence to model business processes using effective diagramming techniques, be less intimidated by this work, and clearly show how Business Process Modeling leads to better business outcomes.

    You will have a working knowledge of basic formulas - SUM, AVERAGE, COUNT, COUNTA, COUNTBLANK

    Every participant will leave each session less intimidated by data analysis, with the confidence knowing your improved Excel skills will lead to data-driven decision-making, better business outcomes and your boss thoroughly impressed!


    Quick Reference Guide for 107 Excel Functions!

    (If you complete all workshops.)


       3 hours




      David Vrbanek

      Senior Business Analyst


      Workshop duration: 3.00 hours

      IIBA CDU / PD credit hours: 3.0 credits


      • Workshop is eligible for IIBA Professional Development (PD) credit hours and CDU credits.


      • Workshop eligible for IIBA® PD and CDU credits


      • IIBA Toronto Full Membership requires being member of IIBA International and IIBA Toronto
      • IIBA Toronto Chapter Subscription also available

      Payment Policy

      Workshop fees must be paid upon registration in the workshop prior to attending. Pricing, registration terms, and conditions are subject to change without notice.

      For credit card payments, charges will be in the currency of the country where the class takes place and will be converted by the credit card company. IIBA Toronto Chapter is not responsible for fluctuations due to exchange rates. Taxes will be applied to the payment where applicable.

      IIBA Toronto Chapter reserves the right to make changes to the workshop program described or to cancel the workshop at any time without notice or liability. The Chapter's sole liability will be limited to the refund of registration fees paid in respect of the workshop and the Chapter shall not be responsible for any incidental or consequential loss arising whatsoever. The Chapter will endeavor to give enrollees as much advance notice as possible of any change to the workshop program or registrant’s enrollment.

      Registration Fee

      The registration fee covers workshop materials only. Refreshments and lunch is not included and is the responsibility of the registrant. Parking is not included.

      Refund Policy

      Cancellations will be allowed prior to 4 days of the workshop start date and a full refund will be issued. Cancellations will not be permitted within 4 days of the workshop start date; however, substitutions will be permitted. It is up to the registrant to find and arrange a substitute. The Chapter will process the substitution by changing the registrant name but is not responsible for any financial transactions between the registrants.

      No refunds will be issued within 4 days of the workshop start date. If a registrant does not attend the workshop and has not given adequate notification, it will result in full forfeiture of the registration fee.

      If you are unable to attend the workshop, or have comments or questions, please contact


      Secondary navigation G - Navigation links, Secondary menu.

      This website is being
      modified to a new look and functionality. Keep scrolling. 

      Powered by Wild Apricot Membership Software