Blogs Archives - PK: An Excel Expert

VBA

Plant Production Planning and Control Management System in Excel VBA

September 30, 2026September 30, 2026 PKComments Off

The Plant Production Planning and Control Management System is a macro-enabled Excel workbook that runs a manufacturing plant from one file: 22 worksheets, 13 VBA entry forms, 5 pivot dashboards,

Excel Tips and Tricks

Excel Form Controls: Combo Box, Spin Button and Option Buttons (3 Real Business Examples)

September 29, 2026September 29, 2026 PKComments Off

Excel form controls turn a static sheet into an interactive tool that anyone can use with a click. In this tutorial we solve three real business problems with the three

Dashboard Templates

Tire Shop KPI Scorecard in Excel

September 29, 2026September 29, 2026 PKComments Off

The Tire Shop KPI Scorecard in Excel puts 10 tire shop KPIs from 4 KPI groups on a single monthly page, with a month picker, an MTD / YTD switch,

Dashboard Templates

Car Wash Business KPI Dashboard in Excel

September 29, 2026September 29, 2026 PKComments Off

The Car Wash Business KPI Dashboard in Excel scores 14 car wash KPIs in 6 groups - month-to-date and year-to-date - against target and prior year, on a 10-sheet workbook

Dashboard Templates

Auto Body Shop KPI Dashboard in Excel

September 28, 2026September 28, 2026 PKComments Off

The Auto Body Shop KPI Dashboard in Excel turns a collision shop's monthly numbers into one scored view: 14 KPIs in 6 groups, each measured month to date and year

Dashboard Templates

Auto Repair Shop KPI Scorecard in Excel

September 28, 2026September 28, 2026 PKComments Off

Ask the owner of an auto repair shop how last month went and you usually get a story. The bays were full, one technician was off for a week, two

Dashboard Templates

Tire Shop KPI Dashboard in Excel

September 28, 2026September 28, 2026 PKComments Off

The Tire Shop KPI Dashboard in Excel puts 13 tire-shop KPIs, 5 KPI groups and 11 worksheets behind a single month dropdown. Pick a month in one cell and seven

Dashboard Templates

Water Treatment Services KPI Scorecard in Excel

September 28, 2026September 28, 2026 PKComments Off

Water Treatment Services KPI Scorecard in Excel turns monthly operating figures into a consistent management review. Instead of rebuilding a slide or chasing separate sheets, a team can review ten

Dashboard Templates

Auto Repair Shop KPI Dashboard in Excel

September 28, 2026September 28, 2026 PKComments Off

Most repair shops measure two things well — money in and cars out — and everything else anecdotally. The Auto Repair Shop KPI Dashboard in Excel is a month-picker scorecard

Templates VBA

Juice Bar Sales Data Entry System in Excel

September 28, 2026September 28, 2026 PKComments Off

The Juice Bar Sales Data Entry System in Excel is a four-sheet, macro-enabled workbook that files every juice order through an eight-field form into an 11-column table, stamps each one