My name is Victor Lai. I'm an Excel ninja and web geek. I make data beautiful and solve data process problems to help free up time and grow your business. What problem can I help you solve? Email hello@goodpicnic.ca.

victor lai linkedin LinkedIn Resume

victor lai twitter Follow Me

“Do good work for good people.”

 

Recent Spreadsheet Projects

  • BC Ministry of Health

    Vancouver Data Analyst for Health Care HIMS

    Working with huge amounts of research and CSV survey data is never easy, but there are ways to speed it up and make it simpler. I designed improved survey methodologies and automated the creation of over 1,000 charts using Excel to help answer the big question: How much is diabetes costing our health care system?

    Visit BC Ministry of Health
  • The Flash (TV Series)

    Excel contractor for TV Movies

    The Flash doesn't often need help, but when it came to an aging costing and timesheet system, it was time to call the experts. Working with the construction team, I took the inefficiencies out of the old system and implemented a simple, PivotTable based system to track their episode costs. The Flash would be proud.

    Visit The Flash
  • Fisheries & Oceans Canada

    Excel consulting for government of Canada

    Working closely with the business management team at the Canadian government's DFO (as it's often still called), I helped untangle a web of spreadsheets involving multiple users updating a single workbook on a regular basis. This error prone system was replaced with a user friendly, web-based SAAS form - another example of moving beyond spreadsheets.

    Visit Fisheries & Oceans
  • 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 Excel spreadsheet forms with advanced conditional formatting and macro buttons (export to PDF, adding / deleting rows) for use in the office and in the field.

    Visit Tervita
  • Porchlight Financial

    Vancouver Excel guru for Porchlight Financial Services

    Porchlight are wealth management experts and also a great group to work with. But when it comes to Excel, they knew when to ask for help. One of our first projects was to design an automated spreadsheet to pull financial data from mutual fund providers sites to automate reporting, freeing up time massaging piles of data so they can focus on their clients.

    Visit Porchlight Financial
  • WATSON Advisors

    excel vba consulting for Corporate Governance

    Excel can be sexy. I created an automated workbook to parse CSV survey results from SurveyMonkey, resulting in useful dashboards and customer facing reports designed to align with the brand using VBA macros and PivotTables. And it's Mac Excel compatible!
    They're a great bunch to work with, if you ever get the chance!

    Visit WatsonInc.ca

Web Marketing Projects

  • FreeWalkingTourEcuador.com

    wordpress custom booking software

    Book a tour for the top-rated, fun and free tour of the historic Old Town in Quito, Ecuador's capital city. This one page Wordpress theme customization is complete with a booking system, a beautifully tiled mosaic gallery, and is optimized for mobile & SEO.

    Visit Free Walking Tour Ecuador
  • ABS Agencies

    vancouver email marketing consultant

    Created an email marketing strategy using Mailchimp and designed the email template for this reputable restaurant industry supplier. Contacts from Outlook were exported & custom fields automatically merged to customize each email with the contact's name, company & login details to optimize open rates.

    View the Email Template
  • DunksForDreams.com

    Dunks for Dreams

    In tandem with the Make A Wish Foundation and Granville Entertainment Group (owners of Doolin's, The Cellar, Roxy), we created the website for a charity basketball event headed by the BC Lion's own Ryan Phillips. Joined by fellow CFL players, Ryan will play against some of BC Hospitality's most recognizable faces.

  • Weddingful.com

    it consulting for weddingful

    Designed the logo for this VC backed startup. Was brought in at the very beginning for the whole gamut: branding, UX, product dev, A/B testing, analytics, SEO, server admin, email marketing, reporting and anything (and everything) else a startup demands!

    Visit Weddingful
  • InsideQuito.com

    web marketing consulting for inside quito

    Built with Wordpress to give an insider's guide to Ecuador's capital city of Quito. Locals, backpackers & ex-pats come together here to provide visitors with timely advice on the increasingly popular destination that the Lonely Planet doesn't cover. SEO, web design & content.

    Visit InsideQuito
  • FantasyCube.com

    fantasy football stats

    FantasyCube is a passion side project focused on liberating NFL statistics so you can do your own fantasy football draft preparation using our free spreadsheets. Using white hat SEO techniques, took it to the top of the SERPs for phrases like "NFL spreadsheets". Look for unique in-depth content on this very important subject matter.

    Visit FantasyCube

Services (Stuff I'm really good at)

  • Creating beautiful, useable, fast Excel spreadsheets
  • Untangling large, linked spreadsheets
  • Data analysis, business analysis & process optimization
  • Recommending the best databases and web solutions to replace Excel
  • PivotTables, database connections, pulling data from the web
  • Import and export of CSV / PDF / XML files
  • Email marketing strategy and list management with Mailchimp
  • Wordpress optimizations with optimal plugin setup


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 to help us get to the next level.

    His expertise with Excel and online databases led us to an elegant solution that is 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 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 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 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!

    Bradley Chisholm
    Associate, WATSON Advisors

  • I approached Victor because 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 and Dropbox.

    Through a combination of in person and phone meetings, we created a solution that now saves me hours every week. 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