v
varsdigital

VARS D

@varsdigital

Excel and Google Sheets Specialist

Canada
Anglais
Certaines informations sont présentées en anglais.
À propos de moi
I am a spreadsheet and data specialist based in British Columbia, specializing in building, fixing, and automating workbooks for small businesses. I leverage professional knowledge of AI-assisted tools and Excel VBA to turn messy data into clean, reliable dashboards and templates. My work is shaped by real-world experience in trades contracting, ensuring practical solutions for job costing and bookkeeping.... Plus d’infos

Compétences

v
varsdigital
VARS D
hors ligne • 

Voir mes services

Formules & Macros
I will build an estimate and job costing spreadsheet for your trade business
Analyse de la chaîne d'approvisionnement
I will build an excel solver optimization model for your business problem

Portfolio

Expérience professionnelle

Self_employed / Freelance

Excel and Google Sheets Specialist

Self employed / Freelance • Indépendant

May 2012 - Present • 14 yrs 5 mos

Self-taught, hands-on Excel and Google Sheets work used to run real business operations. Built and maintained estimates and quotes, job costing, price books, hours and pay tracking, budgets and bookkeeping records. Cleaned and combined data from exports and other systems into usable tables and reports, automated repetitive work with formulas, Google Apps Script, Excel VBA and Power Query, and built financial models for pricing, profit per job, debt payoff, investments and budgets.

Freelance

Spreadsheet Template Designer, VARS Digital

Freelance • Indépendant

May 2012 - Present • 14 yrs 5 mos

Design and publish ready-to-use spreadsheet templates under the VARS Digital name: 21 templates so far, including 14 trade estimate and job costing editions, Canadian small business bookkeeping, seller profit tracking and personal finance trackers. Each template uses drop-downs, validation, conditional formatting and dashboards, and is tested in Excel-compatible apps and Google Sheets with zero formula errors and matching totals before release.