Blogs Archives - PK: An Excel Expert

Office Parking Permit Request Tracker in Excel

April 26, 2026April 26, 2026 PKComments Off

Office Parking Permit Request Tracker in Excel — Blog Post Content (for pk-anexcelexpert.com) Managing office parking is one of those quiet operational headaches that gets noisy fast — limited stalls,

Power Pivot

Crisis Response KPI Dashboard in Power BI

April 26, 2026April 26, 2026 PKComments Off

The Crisis Response KPI Dashboard in Power BI tracks unlimited crisis KPIs across 3 interactive Power BI pages, with Month and KPI Group slicers plus 3 status cards showing Total

Power Pivot

Distillery KPI Scorecard in Excel

April 26, 2026April 26, 2026 PKComments Off

The Distillery KPI Scorecard in Excel tracks 10+ distillery KPIs across 4 structured worksheets, with MTD and YTD trend analysis, color-coded performance indicators, and dropdown-driven filtering. Setup takes under 10

Dashboard

Accounts Payable and Receivable Calendar in Excel

April 26, 2026April 26, 2026 PKComments Off

The Accounts Payable and Receivable Calendar in Excel Calendar in Excel organizes invoice due dates, payment schedules, and collection deadlines across 5 interactive worksheets — Home, Annual View, Monthly View, Daily

Dashboard

Virtual Classrooms KPI Dashboard in Excel

April 26, 2026April 26, 2026 PKComments Off

The Virtual Classrooms KPI Dashboard in Excel tracks 20+ virtual classroom KPIs across 7 interactive worksheets, with MTD and YTD trend charts, conditional formatting arrows, and month-based filtering. Whether you

Dashboard

Music School Dashboard in Power BI

April 26, 2026April 26, 2026 PKComments Off

The Music School Dashboard in Power BI tracks 5 KPI cards and 16 interactive visuals across 5 report pages, all driven by an Excel data source that you refresh from

Dashboard

Music School Dashboard in Excel

April 26, 2026April 26, 2026 PKComments Off

The Music School Dashboard in Excel tracks 5 KPIs and 20 interactive charts across 5 dashboard pages, all driven by pivot tables that auto-refresh when you update the Data sheet.

Dashboard

Data Analytics Dashboard Report in Excel

April 26, 2026April 26, 2026 PKComments Off

The Data Analytics Dashboard Report in Excel is a 4-worksheet appointment-analytics report that tracks 5 headline KPIs across Summary, Report, Data, and Support sheets. It uses 5 charts, two slicer

Power BI

Plumbing Contractor Dashboard in Power BI

April 25, 2026April 25, 2026 PKComments Off

The Plumbing Contractor Dashboard in Power BI tracks 5 headline KPIs and 12 DAX-driven visuals across 5 interactive report pages — Overview, Job Analysis, Technician Performance, Financial Tracking, and Client

Dashboard

Financial Year-End Close Calendar in Excel

April 25, 2026April 25, 2026 PKComments Off

The Financial Year-End Close Calendar in Excel organizes 5 interactive worksheets with annual, monthly, and daily calendar views plus a centralized events database containing 7 fields per record. The template