Skip to content

Menu
  • Home Page
  • About Me
  • Templates
  • Work Smarter: Blog on Excel, Google Sheets & Business Tools

Category: Excel VBA Projects

I love building Excel projects!

What are Excel projects?

I’m glad you asked, from my perspective an Excel project is taking Excel’s capabilities to the max. Using VBA , pivot tables , pivot charts and other tricks I built Excel files for customers’ needs.

These Excels pull data from many different sources into one sheet. Names and definitions are combined under one to allow accurate analysis. The next steps are to use formulas to accurately analyse the data and build pivot tables and charts or value based tables for distribution.

I will post examples of projects that were completed and used to the users satisfaction.

ROI Estimator for the real estate business

January 6, 2023
Excel VBA Projects

ROI Estimator example for the real estate business I want to share with you a ROI estimator built for the […]

Read more →
Excel VBA QA PPT Builder

Excel VBA QA Power Point Builder

December 24, 2020
Excel VBA Projects

The QA manager reached out to me. She told me one of her employees spends a week every month to […]

Read more →
Excel VBA Inventory health report

Excel VBA Inventory Health Report

December 22, 2020
Excel VBA Projects

The VP Sales showed the VP Supply Chain a report he pulled from the ERP system showing them that there […]

Read more →

Excel VBA Logistics Control Tower

December 16, 2020
Excel VBA Projects

Can we build an Excel file that will show us the #of containers that are at risk for demurrage and […]

Read more →

Recent Posts

  • How I Finally Simplified Inventory Costing with an Excel COGS Calculator (FIFO & LIFO)
  • How I Built a Google Sheets Order Management System That Pulls Live Data From Multiple Customers
  • How a Simple Google Sheets Template Can Revolutionize Your Order Management System
  • πŸ“Š Build Your Own NPS Dashboard in Excel β€” No VBA Needed!
  • πŸ” Analyze Forecast Accuracy Like a Pro in Excel

Recent Comments

  • Elad Sharon on Grade Estimator
  • Elad Sharon on Recruitment Dashboard using Excel
  • Pakin on Project Management
  • mplrs.com on Grade Estimator
  • Hung Sheasby on Recruitment Dashboard using Excel

Archives

  • May 2025
  • April 2025
  • January 2023
  • April 2022
  • February 2021
  • January 2021
  • December 2020

Categories

  • Excel Formulas
  • Excel Templates
  • Excel VBA Projects
  • Food Industry
  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
- Proudly Powered by WordPress
Theme by Grace Themes
Ready to Grow Your Business? Let’s Connect!
Loading