Blogs Archives - PK: An Excel Expert

Templates VBA

Patient Discharge Planning Calendar in Excel

September 9, 2026September 9, 2026 PKComments Off

Discharge planning is mostly coordination. A family conference here, a medication reconciliation there, a walker to be delivered on Thursday, transport to confirm for Friday morning, and a follow-up clinic

Templates VBA

Medication Reminder Calendar in Excel

September 9, 2026September 9, 2026 PKComments Off

Medication schedules have a habit of living in four places at once: a strip of paper taped inside a kitchen cupboard, a phone alarm that somebody silenced in a meeting,

Power BI Templates

Locksmith Business KPI Dashboard in Power BI

September 9, 2026September 9, 2026 PKComments Off

The Locksmith Business KPI Dashboard in Power BI tracks 14 locksmith KPIs across 4 report pages, driven by 38 DAX measures and two hidden tooltip pages. Ten of those KPIs

Dashboard Templates

Locksmith Business KPI Scorecard in Excel

September 9, 2026September 9, 2026 PKComments Off

Most locksmith businesses measure themselves one job at a time. You know the 2am lockout on the north side took forty minutes to reach, you know the Ford transponder job

Dashboard Templates

Pest Control Business KPI Scorecard in Excel

September 9, 2026September 9, 2026 PKComments Off

Most pest-control operators already have the numbers. Jobs completed, callbacks, renewals, revenue per treatment - they sit in the field-service app, in the invoicing system, in a spreadsheet somebody keeps.

Dashboard Templates

Pest Control Business KPI Dashboard in Excel

September 9, 2026September 9, 2026 PKComments Off

The Pest Control Business KPI Dashboard in Excel tracks 15 pest-control KPIs across 6 KPI groups on 11 worksheets, driven by a single month dropdown. Seven summary cards, a full

Dashboard Templates

Septic Tank Service KPI Dashboard in Excel

September 9, 2026September 9, 2026 PKComments Off

Most septic businesses already know their month was good or bad. What they usually cannot do, on the spot, is say why - which of the fifteen things that actually

Templates VBA

Footwear Shop Stock Data Entry System in Excel

September 9, 2026September 9, 2026 PKComments Off

A shoe shop carries the same style in eight sizes and four colours, which means a shop holding 200 pairs is really tracking several hundred separate lines. That is exactly

Templates VBA

Mobile Accessory Sales Data Entry System in Excel

September 9, 2026September 9, 2026 PKComments Off

A mobile-accessory counter sells small things quickly. Ten cases, four cables, a power bank and a pair of earbuds can go across the till before lunch, each one a different

Power BI Templates

Pest Control Business KPI Dashboard in Power BI

September 9, 2026September 9, 2026 PKComments Off

The Pest Control Business KPI Dashboard in Power BI scores 13 pest control KPIs across 10 KPI groups on 4 report pages, and ships with 24 months of sample actuals