All prices are in Canadian dollars.

Excel Reporting Part 6: The Right Way to do Lookups (30 Mins)

Date:   Aug 08, 2020 - Aug 08, 2020
Time:   9:30 AM (MDT)
Location:   Online Platform: Zoom

CPD:     1 Credit
Price:     Member: $30

Non-member: $40

       Read Cancellation policy
Why this Webinar?


Cross-referencing data and lookups are fundamental Excel skills…but there are many ways to do it, some better than others. The big question is: Are you still using VLOOKUP?? There’s a better way!

Key Learning Outcome(s):

  • Replace VLOOKUP/HLOOKUP with the more robust INDEX-MATCH combo.
  • Learn all about Excel’s latest lookup function, XLOOKUP.
Instructions to join the meeting:    

Upon registering you will receive a confirmation email on how to activate your registration.


  • High speed internet connection
  • Speakers

Ian Gonzalez

About the Instructor:

Ian Gonzalez, MBA, CIPS is a Senior Supply Chain Analytics & Stewardship Specialist with 16 years of experience in the aviation and oil and gas industries. He’s worked with companies such as Lufthansa, Shell, Suncor and Cenovus and has developed and implemented ground-breaking SCM and Finance solutions using Excel, Power BI, and VBA. He has a passion for teaching and does so from the perspective of an SCM professional, engineer, and computer programmer.


Refund and Cancellation Policy: 



  • Registrants will receive a full refund to courses cancelled by Supply Chain Canada, Alberta Institute.
  • Registrants who have received written acceptance into a course and provide written notice to Supply Chain Canada, Alberta Institute of their withdrawal from the course 14 days or more prior to the first day of class, will be provided a full refund. After 14 days prior up to 2 days prior to the start of the class, Supply Chain Canada, Alberta Institute will refund half the course registration fee. After the 2- day period, refunds will not be granted.


Due to unforeseen circumstance if Supply Chain Canada - Alberta Institute cancels an event all registrants will be offered the option to transfer the registration to a future event or receive a refund.

Please send cancellation request, questions or concerns to Millete Gutierrez (


To begin, please enter your email address below.

Should you not be able to complete the form in one sitting, any information you have entered will be saved and your form will continue from where you left off when you return.

By entering your email you are giving your consent to be contacted electronically by Supply Chain Canada on matters regarding the event and your registration/enrollment.


Have a promotional code? Enter it here.