PROJECT 01
WordPress Blog Management
A complete editorial workflow with formatted posts, categories, SEO fields, and an importable WordPress content file.
Detailed case studyEditable files
Portfolio by Joseph Guerrero
Ten practical projects. One connected brand system.
Explore detailed examples covering WordPress, administration, spreadsheets, e-commerce, content, design, document formatting, testing, and responsive web development.
Northstar Fitness StudioOriginal concept brand used across ten connected projects
Portfolio library
Browse the work
Each project includes finished client-facing content, a concise case study, and downloadable working files. Search by task or filter by service.
PROJECT 02
Business Research Spreadsheet
A structured 50-record research directory with a dashboard, validation rules, a data dictionary, and documented sources.
Detailed case studyEditable files
PROJECT 03
Spreadsheet Data Cleanup
A before-and-after workbook with normalization rules, duplicate handling, validation, and an auditable cleaning log.
Detailed case studyEditable files
PROJECT 04
WooCommerce Product Store
A detailed storefront concept with product pages, filters, a browser-based cart, and an import-ready product CSV.
Detailed case studyEditable files
PROJECT 05
YouTube Content Package
Ten fully planned videos with titles, descriptions, scripts, metadata, thumbnails, and a publishing calendar.
Detailed case studyEditable files
PROJECT 06
Social Media Design Kit
A coordinated brand system with feed posts, Stories, thumbnails, a banner, and a printable promotional flyer.
Detailed case studyEditable files
PROJECT 07
Website QA Report
A professional testing package with an executive PDF, issue log, reproducible steps, and an interactive checklist.
Detailed case studyEditable files
PROJECT 08
Virtual Assistant System
An operations workbook with tasks, contacts, time tracking, content planning, meeting notes, and reusable SOPs.
Detailed case studyEditable files
PROJECT 09
Document Formatting
A polished multi-page client guide, a matching PDF, before-and-after source material, and a formatting specification.
Detailed case studyEditable files
PROJECT 10
Responsive Fitness Website
A seven-page HTML/CSS business website with programs, trainers, pricing, schedule filtering, resources, and forms.
Detailed case studyEditable files
Project approach
One brand, many business needs
I created Northstar Fitness Studio as an original concept brand, then developed a connected system of web, content, admin, e-commerce, design, and QA deliverables around it.
- Original brand, content, and project direction
- Consistent voice and visual system across every deliverable
- Locally stored photography with source credits
- Interactive features that work without a server