• Excel and VBA
    • VBA Course
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • Charts
    • Progress Charts
    • Info-graphics
    • Animated Charts
    • Comparisons
    • Gantt Charts
    • Heatmaps
    • Speedometers
    • Timelines
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
  • Power BI
  • Template StoreNew
  • CoursesNew
  • Ready to Use Templates
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Blogs

Templates VBA

Operation Theatre Booking Calendar in Excel

August 26, 2026August 26, 2026 PKComments Off on Operation Theatre Booking Calendar in Excel
Most operating-theatre diaries are still a laminated grid on a wall, a whiteboard someone photographs on a Friday, or a spreadsheet that has been copied so many times nobody knows
Read More
Dashboard

DIY Home Improvement Stores KPI Dashboard in Excel

August 26, 2026August 26, 2026 PKComments Off on DIY Home Improvement Stores KPI Dashboard in Excel
A DIY and home improvement chain generates an awkward mix of numbers. Comparable-store sales growth behaves like a supermarket metric. Special-order fill rate and job-site delivery behave like a distribution
Read More
Dashboard Templates

Discount Stores KPI Dashboard in Excel

August 26, 2026August 26, 2026 PKComments Off on Discount Stores KPI Dashboard in Excel
Discount retail is a business of small margins repeated at enormous volume. When your average unit retail is $2.63 and your average basket is under $17, a 40-basis-point slip in
Read More
Templates VBA

Grocery Shopping List Data Entry System in Excel

August 26, 2026August 26, 2026 PKComments Off on Grocery Shopping List Data Entry System in Excel
The Grocery Shopping List Data Entry System in Excel is a macro-enabled workbook that records 6 fields for every item you plan to buy - Item, Category, Store, Quantity, Unit
Read More
Templates VBA

Movie Watchlist Data Entry System in Excel

August 26, 2026August 26, 2026 PKComments Off on Movie Watchlist Data Entry System in Excel
Most watchlists are scattered. A few titles in a notes app, a few in a group chat, a couple screenshotted from a trailer you meant to come back to. The
Read More
Power BI Templates

CrossFit Gym KPI Dashboard in Power BI

August 26, 2026August 26, 2026 PKComments Off on CrossFit Gym KPI Dashboard in Power BI
Most CrossFit affiliates measure the same three things - members, revenue and how full the 6am class is - and then argue about everything else from memory. The CrossFit Gym
Read More
Power BI Templates

Corporate Ethics Office Dashboard in Power BI

August 26, 2026August 26, 2026 PKComments Off on Corporate Ethics Office Dashboard in Power BI
Most ethics offices have the data. What they do not have is a way to show it. Cases land through a hotline, a web portal, a manager referral and an
Read More
Power BI Templates

Content Rights Agencies Dashboard in Power BI

August 26, 2026August 26, 2026 PKComments Off on Content Rights Agencies Dashboard in Power BI
A content rights agency lives on two numbers that never sit in the same place: what the contracts are worth, and what the royalties cost. The Content Rights Agencies Dashboard
Read More
Dashboard Templates

Crisis Mapping Startups Dashboard in Excel

August 26, 2026August 26, 2026 PKComments Off on Crisis Mapping Startups Dashboard in Excel
A crisis mapping startup lives on two numbers that almost never sit in the same file: how much it costs to keep a platform in the field, and how much
Read More
Dashboard Templates

Credit Recovery Agencies Dashboard in Excel

August 26, 2026August 26, 2026 PKComments Off on Credit Recovery Agencies Dashboard in Excel
The Credit Recovery Agencies Dashboard in Excel is a five-page analytical workbook built on 19 charts, 25 pivot tables and 4 linked slicers, running over a 500-record sample book of
Read More

Posts pagination

1 2 … 423 Next
  • Excel and VBA
    • VBA Course
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • Charts
    • Progress Charts
    • Info-graphics
    • Animated Charts
    • Comparisons
    • Gantt Charts
    • Heatmaps
    • Speedometers
    • Timelines
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
  • Power BI
  • Template StoreNew
  • CoursesNew
  • Ready to Use Templates
  • 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