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)
- 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.)
Senior Business Analyst
Workshop duration: 3.00 hours
IIBA CDU / PD credit hours: 3.0 credits
IIBA CREDIT HOURS
- 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
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.
The registration fee covers workshop materials only. Refreshments and lunch is not included and is the responsibility of the registrant. Parking is not included.
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 email@example.com.