My name is Victor Lai. I'm a web geek & Excel ninja. I make data beautiful. I can show you how to work more efficiently and help grow your business - contact  hello@goodpicnic.ca.

victor lai linkedin LinkedIn Resume

victor lai twitter Follow Me

“Do good work for good people.”

 

Recent Spreadsheet Projects

  • SymbiAudit Sustainability

    excel vba consulting for SymbiAudit

    Excel can be sexy. I created a slick automated workbook to parse a mountain of data using VBA macros and PivotTables. They're a great bunch to work with, if you ever get the chance! Another perk is feeling good inside knowing you're helping spread the three R's of waste management. Quick, what are they, and in what order?

    Visit Symbiaudit
  • Granville West Group

    Vancouver Excel guru for Granville West Group

    GWG are & wealth management experts. However when it comes to Excel, they knew their limits. Working closely together, I designed an automated spreadsheet to pull in financial data from the web & mutual fund providers to automate reporting, giving GWG more time with their clients and less time massaging piles of data.

    Visit Granville West Group
  • ConocoPhillips

    Excel consulting for COP

    Try explaining upstream oil & gas business analytics over a drink on the West Coast: Eyes glaze, hands fidget until the inevitable half question / assumption "So... you're in IT?". Still reading? I streamlined reporting by pulling data from Oracle & proprietary systems using Excel & Crystal to create beautiful charts for the suits in Houston to decide where to poke holes.

    Visit Conocophillips

Web Marketing Projects

  • 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.

    Visit Dunks For Dreams
  • 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
  • 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 (aka things I'm really good at)

  • Creating beautiful, useable Excel spreadsheets
  • Untangling large, linked spreadsheets
  • Transforming CSV files to Charts, automagically with VBA macros
  • Replacing XLS files with custom web databases (i.e. TrackVia CRM SAAS)
  • PivotTables, database connections, pulling data from the web
  • Recommending web tools for managing projects, emails & clients
  • Optimizing business processes
  • Web, email & content marketing
  • Wordpress optimizations with ideal plugin setup (there are so many!)