Hi! I'm Victor and I've been an Excel consultant since 2008. I've helped over 100 companies big and small work better using the best tools for their unique problems.
Reach out at hello@goodpicnic.ca to find out how I can help you.

“ We highly recommend Victor as an Excel consultant to anyone who wants the job done right the first time and thinks 'there has to be a better way!'. ”
- Chris, Managing Director

 

Recent Spreadsheet Projects

  • Fisheries & Oceans Canada

    Vancouver IT Consultant for Canada Federal Government

    Working closely with the business management team at the Canadian government's DFO, I've built multiple tools and designed systems in Microsoft Excel to simplify employee tracking, finance reviews, team reporting and surveys for multiple departments.

    Visit Fisheries & Oceans
  • The Flash (TV Series)

    Excel contractor for TV Movies

    The Flash doesn't often ask for help, but when it came to an aging cost & timesheet Excel workbook, it was time to call an expert. Working with the set construction team, I updated the old system with an easy to use, automated PivotTable interface using macros to better track their episode costs. The superhero would be proud.

    Visit The Flash
  • Panalytics Research Group

    Excel contracting for market research analysis and market research models

    Working with this team of market research experts in Vancouver, I've improved models and supplemented their analysis to build better internal and customer-facing marketing preference models in Microsoft Excel to help them reach their research objectives more quickly and accurately.

    Visit Panalytics
  • Tervita

    Vancouver Excel guru for Tervita Alberta

    Providing environmental solutions in Alberta, Tervita approached me to create templates for health & safety. Using Excel, I created protected forms with advanced conditional formatting rules and macros to simplify and validate data input and make exporting to PDF and inserting pre-formatted rows a one-click operation.

    Visit Tervita
  • Porchlight Financial

    Vancouver Excel guru for Porchlight Financial Services

    Wealth management financial advisors and all just a great group of people, it's been a pleasure being their on-call Excel expert. Our first project was back in 2012, an Excel spreadsheet to pull data from mutual fund providers to automate reporting. This VBA macro solution is still in use, freeing up their time to focus on their clients.

    Visit Porchlight Financial
  • WATSON Advisors

    excel vba consulting for Corporate Governance

    This wonderful group of management and board governance consultants runs Mac Excel, which I use as well. Together we created a workbook to parse CSV survey results from SurveyMonkey and Qualtrics to automate dashboards and customer-facing reports that align with the brand identity using an elegant combo of VBA macros and advanced formulas.

    Visit WatsonInc.ca

Services (Stuff I'm really good at)

  • Creating beautiful, useable, fast Excel spreadsheets & templates
  • Performance optimizations of large (100MB+), linked spreadsheets
  • Using SQL databases and SAAS solutions to replace Excel
  • PivotTables, database connections, pulling data from the web
  • Import and export of CSV / PDF / XML files with API's
  • Survey design (worked with Stats Canada consultants)
  • Data visualizations, business analysis & process optimization (BPR)
  • Microsoft Power Query, Flow, Google Sheets and AirTable


Microsoft Office Specialist: Excel Expert
Certified on Feb 27 2016 by Microsoft Corp.

Testimonials

  • We recognized that we were outgrowing our spreadsheet heavy processes, so in order to serve our clients better, we hired Victor as our Excel expert to help us get to the next level.

    His professionalism, positive attitude and expertise with Excel led us to an elegant solution that's easy to use and saves us several hours a week when preparing customized financial information for our clients. Victor guided us through a smooth implementation process and since then, we've worked on several Excel automation projects together.

    We highly recommend Victor's Excel consulting services to anyone who thinks "there has to be a better way!".

    Christopher M. Forman
    CEBS, CFP®, Managing Director, Porchlight Financial

  • Victor worked closely with our team to understand our product, our efficiency gaps and our ultimate goal. What we had in place was working but it was rudimentary, and we knew there had to be a better way to streamline our process with Microsoft Excel. As consultants ourselves, we knew it was time to call in the experts and we hired Victor to help us craft a better system.

    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! We were very impressed by Victor's ability to come up with a creative and elegant solution to our complex needs. His Excel template has already saved us five days of work this month, giving us valuable time to focus on our clients and our own areas of expertise. I would highly recommend Victor to anyone looking for an Excel consultant in Vancouver!

    Bradley Chisholm
    Associate, WATSON Advisors

  • I approached Victor because in my new position, I took over a legacy spreadsheet cost and labour tracking system that was getting too large to manage. He helped me by creating a new, streamlined system using Microsoft Excel 365 and Dropbox.

    Through a combination of in-person and Zoom meetings, we created a solution that now saves me hours every week. His experience shows because it didn’t take him long to understand our very complicated process. Victor's been an absolute pleasure to work with and I look forward to working with him again.

    Michele Lyons
    Construction Buyer, The Flash

Not Just Spreadsheets
(Tools we use and recommend)

  • Trello
  • Notion
  • Google Sheets
  • Tableau
  • QuickBooks QODBC
  • AirTable
  • Microsoft Power Automate & Power Query

Let's Work Together

Spreadsheets can be art. They can be designed beautifully with elegant, intuitive interfaces. My methodology involves tapping into the experience I've gained working with companies of all kinds since 2008. I've seen the same issues come up time and again, and I've seen what works for my clients and what saves them time and money in the long run.

When macros are necessary (and only then, often they're not), I document them well so they can be easily maintained. I know what it's like to takeover an old spreadsheet. And sometimes Excel isn't the answer and I'm not afraid to say it. It's often not a data issue but a process problem, but a better spreadsheet or a better tool can help.

If this resonates with you, reach out to see if we're a good fit.

Some happy clients:

- Smart Sweets
- MaKami College of Massage, Edmonton
- British Columbia Lottery Corporation (BCLC)
- BC Hydro
- Nisga'a Lisims Government
- Unsworth Vineyards, Mills Bay, BC
- PHEMI Systems, Vancouver
- Revera Living