Portfolio & Free Tools

Google Sheets Dashboard

Interactive Shopify Analytics Dashboard on Google Sheets

Custom JavaScript dashboard built on Google Sheets for a Shopify store — 4 interactive pages covering executive KPIs, customer analytics, product performance, and operations.

Google Sheets Apps Script JavaScript Shopify

Read More

Excel VBA Automation

Automated Invoice Generator for Architecture Firm

Custom Excel VBA tool that imports timesheets from Airtable, generates branded PDF invoices with one click, and includes a project analysis dashboard.

Excel VBA Power Query Airtable PDF Export

Read More

FREE TOOL Excel VBA & Power Query

Automated Excel Data Consolidation Tool

VBA & Power Query tool that consolidates data from multiple Excel files into one sheet — extracting keywords and values with a single click.

Excel VBA Power Query Automation

Read More

Excel Power Query

COVID-19 Tracking & Reporting Tool

Automated Excel tool that pulls live pandemic data via Power Query, builds dynamic pivot charts, and generates a printable PDF report — refreshed daily with zero manual work.

Excel Power Query Pivot Tables PDF Export

Read More

FREE TOOL Free Python Script

CSV Data Cleaner & Validator

Open-source Python tool that automatically detects and fixes common data quality issues in CSV files — duplicates, missing values, type errors, and formatting.

Read More