<< Back to Calendar

*Sold Out* SkillBuilder Workshop 1 - EXCELlence - Intermediate Functions and Formulas

Technical

Special offer: Register and attend Part 1 (Jan 16) and Part 2 (Jan 23) workshops and receive a $5 off promo code for an upcoming PMI Toronto event of your choice!

Synopsis

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 PMI-Toronto BA Community 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 a number or text

Pre-Requisite:  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!



Note: The January 16th workshop is a pre-requisite for the second workshop on January 23, 2021. If you wish to attend Part 2, you must attend this workshop first!

Topics of Discussion

  • 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 a number or text

Speaker

David Vrbanek, B.A., ITIL

david_vrbanek.jpg

 

David Vrbanek, B.A., ITIL, is a senior business analysis practitioner with over 15 years of real-world project experience in industries such as finance, health sciences, product lifecycle management, automotive, and IT service management. He has led software development and business process improvement projects in blended PM/BA roles. David is a Project Management Office Lead at Brookfield, managing, and coaching both project managers and business analysts in project delivery. David is passionate about teaching and developing business analysts:  he currently delivers Business Analysis courses at the University of Toronto and Sheridan College and is active in both the business analysis and project management communities sharing his industry and professional expertise through workshops for various professional association chapters.

PDU Allocation

Three (3) PDUs are applicable for PMPs who attend this three (3) hour event.

The talent triangle allocation is 3 PDUs – Technical.

 

 


Cancellation and Refund Policy

Cancellations must be received by 5:00 p.m., 5 business days before the event and must be sent in writing by email to your chapter registrar. There will be a 20% administration fee charged for cancellations, subtracted from the refund. Please contact info@pmitoronto.ca to cancel your registration.  Cancellation/refund requests will not be accepted less than 5 business days before the event. However, substitutions are welcome.

It is no longer possible to register for this event

It is no longer possible to register for this event

Information

Type of activity: PMI Toronto Business Analysis Community

Date: January 16th, 2021

Hour: 10:00AM to 1:00PM

# of PDUs: 3.0

Price

Members: $20.00

Non members and Guests: $35.00

Location

Online