• Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Blogs

Dashboard Templates

Edutainment Parks Dashboard in Excel Template

September 11, 2026September 11, 2026 PKComments Off on Edutainment Parks Dashboard in Excel Template
A mid-sized science centre can take twenty thousand bookings a year and still not be able to answer three questions quickly: which site is losing money, which program pays for
Read More
Templates VBA

Health Checkup Package Calendar in Excel

September 10, 2026September 10, 2026 PKComments Off on Health Checkup Package Calendar in Excel
The Health Checkup Package Calendar in Excel is a macro-enabled workbook of 7 sheets that turns one table of bookings into four synchronised calendar views. It ships with exactly 100
Read More
Templates VBA

Hospital Bed Turnover Calendar in Excel

September 10, 2026September 10, 2026 PKComments Off on Hospital Bed Turnover Calendar in Excel
Bed turnover is the quietest bottleneck in a hospital. A discharge is signed at 10 a.m., the bed sits stripped until someone is free, and the admission waiting in the
Read More
Dashboard Templates

Window and Door Installation KPI Scorecard in Excel

September 10, 2026September 10, 2026 PKComments Off on Window and Door Installation KPI Scorecard in Excel
Most window and door companies can tell you last month's revenue and almost nothing else. How many in-home quotes actually went out, what share of them closed, how many installs
Read More
Dashboard Templates

Garage Door Service KPI Scorecard in Excel

September 10, 2026September 10, 2026 PKComments Off on Garage Door Service KPI Scorecard in Excel
The Garage Door Service KPI Scorecard in Excel is a monthly report card for garage door installation and repair companies: 10 pre-built KPIs in 5 groups, 12 months of MTD
Read More
Dashboard Templates

Garage Door Service KPI Dashboard in Excel

September 10, 2026September 10, 2026 PKComments Off on Garage Door Service KPI Dashboard in Excel
Most garage door companies measure the wrong thing. They count jobs. A busy month feels like a good month, right up to the point where the callbacks land, the second
Read More
Dashboard Templates

Locksmith Business KPI Dashboard in Excel

September 10, 2026September 10, 2026 PKComments Off on Locksmith Business KPI Dashboard in Excel
A locksmith business lives or dies on two numbers that almost nobody tracks properly: how long it takes to get a van to an emergency call, and how often the
Read More
Templates VBA

Jewellery Stock Register Data Entry System in Excel

September 10, 2026September 10, 2026 PKComments Off on Jewellery Stock Register Data Entry System in Excel
Most small jewellery shops still run on a stock book. A ruled register, a pen on a string, and one person who knows what the shorthand means. It works until
Read More
Templates VBA

Garment Shop Sales Data Entry System in Excel

September 10, 2026September 10, 2026 PKComments Off on Garment Shop Sales Data Entry System in Excel
Most clothing shops start with a notebook. It works right up until the day somebody asks how much the shop actually took last week, or which customer still has a
Read More
Power BI Templates

Window and Door Installation KPI Dashboard in Power BI

September 10, 2026September 10, 2026 PKComments Off on Window and Door Installation KPI Dashboard in Power BI
The Window and Door Installation KPI Dashboard in Power BI scores 12 KPIs across 9 KPI groups on four report pages, backed by two hidden tooltip pages and five slicers.
Read More

Posts pagination

Previous 1 … 17 18 19 … 454 Next
  • Learn Excel (Free Course)
    • 1. Shortcut Keys
    • 2. Fill & Flash Fill
    • 3. Find & Replace
    • 4. Sort & Filter
    • 5. Formulas & Functions
    • 6. Data Validation
    • 7. Conditional Formatting
    • 8. Basic Charts
    • 9. Advanced Charts
    • 10. Pivot Tables
    • 11. Excel Dashboards
    • 12. VBA Course
    • 13. Excel Formulas with AI
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Excel Dashboards
    • Power Pivot & DAX
  • Power BI
  • Template Store
    • Ready to Use Templates
  • Courses
  • Academy
    • Excel + AI Mastery: 100 Formulas
    • Excel Pivot Tables & Dashboards
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy
This website uses cookies to improve your user experience, analyze site traffic and serve targeted ads in accordance with our Privacy Policy ACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT