15May
How I Built a Comprehensive Canadian Postal Code Dataset in SQL and Excel
How I tackled the challenge of compiling a complete Canadian postal code dataset with lat/long in SQL and Excel — and what made it work in the end.
Read MoreBlog
15May
How I Executed a City-Wide Venue Survey and Built a Festival Database in Excel
I needed to call venues across the city and organize the data in Excel for a festival. Here's how the process went and what made it work in the end.
Read More
15May
How I Executed a Lender Data Collection Project Using Strategic Phone Outreach and Excel Management
How I managed a lender data collection project using structured phone outreach and Excel spreadsheet management — and where I got help when it scaled up.
Read More
15May
How I Turned Complex Sales Data Into Actionable Business Reports Using Excel
How I tackled messy sales data in Excel and got clean, actionable business reports — with help from a team that knew exactly what to do.
Read More
15May
How I Created Data-Driven Financial Analysis Dashboards That Informed Product Strategy
Learn how I built financial analysis dashboards in Excel and PowerPoint to drive product and marketing strategy decisions for a growing tech firm.
Read More
15May
How I Built an Interactive Excel Dashboard to Track Athlete Performance Metrics
How I designed an interactive Excel dashboard to track athlete gym metrics like weight, body fat, and workout volume — and what made it finally work.
Read More
15May
How I Built a Real-Time Excel Dashboard to Consolidate Scattered Data Across Departments
Learn how I tackled scattered department data by building a real-time Excel dashboard for KPI tracking, financial metrics, and cross-team visibility.
Read More
15May
How I Built an Automated Excel Reporting Tool for Weekly Sales Analysis
Learn how I built an automated Excel reporting tool for weekly sales analysis — and how expert help turned disorganized data into a clean, scalable solution.
Read More
15May
How I Built an Organized Marketing Contact List in Excel for Campaign Launch
How I organized a messy marketing contact list in Excel before a campaign launch — and what I learned when the data got too complex to handle alone.
Read More
15May
How I Built an Automated Excel-Based Music Chart to Track Sales and Streaming Metrics
Learn how I built an automated Excel-based music chart to track sales and streaming metrics, with dynamic visuals and VBA automation that actually works.
Read More