Skip to main content
Good Picnic, homeLet's talk
Menu

Microsoft Excel Consulting

Spreadsheets people want to use. Built to last.

I'm Victor Lai. I've been an Excel consultant since 2008. I build custom workbooks, modernize the ones your team already relies on, and automate the work you keep doing by hand.

I'm based in Courtenay, BC, and work with clients across Canada, with on-site meetings available in Vancouver, Victoria and across Vancouver Island.

Microsoft Office Specialist: Excel Expert, certified in 2016

Victor Lai pointing to a spreadsheet on a wall screen while two people at a meeting table look on

What I can help with

  • Fix a slow or complicated workbook

    Maybe you inherited a workbook nobody wants to touch, or opening it gives you time to make coffee. I can trace what's slowing it down, repair formulas and links, and make it easier for your team to update.

  • Connect Excel to your data and automate reporting

    I use Power Query to modernize workbooks and connect them to SQL databases, CSV exports and other data sources. If every month starts with the same downloads, cleanup and copy-paste, I can build a refreshable process that pulls in the latest data, applies your business rules and flags exceptions for review.

  • Make Excel feel like a well-designed app

    One of my specialties is making spreadsheets that hardly look like spreadsheets. I design clean interfaces that make it obvious where to enter information, what needs attention and how to get to the report you need. I build that into tools for budgeting, payroll, cost tracking and client reporting, with Mac and Windows compatibility in mind when your team uses both.

How I work

A lot of clients first find me by searching for a Vancouver spreadsheet consultant. They come with a workbook they need help with and usually discover I can help with the work around it too, from connecting business systems to automating the steps that happen before the data ever reaches Excel.

There's a running joke in the Excel world that half a consultant's job is telling clients using spreadsheets to switch to a database. The other half is telling clients using a database to switch to a spreadsheet.

This is only partially true. The truth is, Excel is often the best tool for the job. You can build a prototype quickly, put it in front of the people who'll use it, and change it while everyone's still figuring out what they need. It's probably the closest thing an office has to a shared programming language. The CFO, the developer and the office admin can all open the same workbook and see how the numbers come together.

I start by looking at how the work gets done. After consulting since 2008, I've seen the same issues come up in all kinds of organizations. A reporting problem might start with three teams entering the same information three different ways. Fixing that can save more time than automating the report. When a team has outgrown Excel, I've helped move workflows into tools like Airtable for shared tracking and Tableau for reporting.

I think spreadsheets can be art. I care about how they look, how they feel to use, and how easy they'll be to maintain a few years from now. I keep the logic easy to follow and use VBA macros when they earn their keep. When I do use them, I document what they do and where to make changes. I've inherited enough old workbooks to know what a difference that makes for the next person.

Selected projects

  • WATSON Advisors

    Built a Mac Excel workbook that turned Qualtrics survey exports into branded dashboards and client reports. WATSON reported saving five days of work in one month.

    "It didn't take him long to understand our process and to deliver a result that was beyond our expectations - our team was jumping for joy on the first run!"

    Bradley Chisholm, Associate, WATSON Advisors
  • Unsworth Vineyards

    Designed an inventory system that connects to QuickBooks to track wine inventory by SKU across all of Unsworth's retailers in BC.

  • MaKami College of Massage

    Built an automated student calendar that recalculates cut-off dates when the calendar rolls over to a new year.

  • Nisga'a Lisims Government

    Designed an anonymous citizenship registry database to simplify reporting.

  • British Columbia Lottery Corporation (BCLC)

    Built an idea management system that let the team compare and rank ideas using several criteria.

  • Common Good

    Worked with a non-profit serving people experiencing poverty to simplify its data analysis. The tool cut manual work and saved the team about an hour and a half each week, according to Common Good.

    "His solution also eliminates the stress and frustration they feel when it comes to data analysis."

    Common Good

Selected clients

  • BCIT
  • Smart Sweets
  • MaKami College of Massage
  • Pacific Specialty Brands
  • Revera Living
  • HUB Financial
  • Pacific Western Brewery
  • Unsworth Vineyards
  • BC Hydro
  • British Columbia Lottery Corporation
  • Nisga'a Lisims Government
  • PHEMI Systems

What's taking too long in Excel?

Tell me what the workbook does and where you're getting stuck. We can start there.