Skip to main content

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

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 (Victoria Regional Network)

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.

Want my next pick in your inbox? Email me new events.

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.

Where's Anu

One short email from me when I add an event I'm going to or recommend.
No filler, unsubscribe anytime.

One quick step: after you sign up we'll email you a confirmation link. You're on the list the moment you click it.

We respect your privacy. Unsubscribe at any time.