Skip to main content
Back to the calendar

The Finance Prof.'s Toolkit: Pivot Tables, XLOOKUP & INDEX/MATCH

The Finance Prof.'s Toolkit: Pivot Tables, XLOOKUP & INDEX/MATCH is a Finance & Accounting workshop on Monday, April 13, 2026 at White Sport Restaurant, Langford in Victoria, BC. Presented by CPB Canada.

The Finance Prof.'s Toolkit: Pivot Tables, XLOOKUP & INDEX/MATCH promotional image

Monday, April 13, 2026

6:00 p.m. to 8:00 p.m.

White Sport Restaurant, Langford (open in Google Maps)

Presented by CPB Canada

Hosted by CPB Canada, this technical session sees Kevin Loo demonstrate how finance professionals can turn disparate data into actionable financial intelligence through advanced spreadsheet skills. It covers Pivot Table mastery for deep-dive analysis, slicing and visualizing large volumes of data to surface trends, outliers, and key business drivers, alongside advanced lookup logic comparing XLOOKUP and INDEX/MATCH and when to use each so formulas stay robust as data structures evolve. The session is aimed at finance professionals who need high precision while managing high-volume data, and it carries one CPD point. Loo is a seasoned finance professional with deep expertise in both Microsoft Excel and Google Sheets. It runs in person at the White Spot in Langford.

Anu's Take

Excel, Google Sheets, Xlookup and other advanced spreadsheet stuff we can all learn a little bit more about.

Share:

Published Monday, April 13, 2026 by Anu Jolliffe on LinkedIn

Frequently asked questions

When is The Finance Prof.'s Toolkit: Pivot Tables, XLOOKUP & INDEX/MATCH?
Monday, April 13, 2026, 6:00 p.m. to 8:00 p.m..
Where is The Finance Prof.'s Toolkit: Pivot Tables, XLOOKUP & INDEX/MATCH?
White Sport Restaurant, Langford, in Victoria, BC.
Is The Finance Prof.'s Toolkit: Pivot Tables, XLOOKUP & INDEX/MATCH worth attending?
Excel, Google Sheets, Xlookup and other advanced spreadsheet stuff we can all learn a little bit more about.