• 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

Gift Register Data Entry System in Excel

August 17, 2026August 17, 2026 PKComments Off on Gift Register Data Entry System in Excel
Most gift records die in the same place: a notebook that gets lost, or a spreadsheet with eleven columns that nobody keeps up. The moment you need to know who
Read More
Dashboard Templates

Ceramic Tiles Production Dashboard in Excel

August 17, 2026August 17, 2026 PKComments Off on Ceramic Tiles Production Dashboard in Excel
The Ceramic Tiles Production Dashboard in Excel reports on 500 sample batch records across 5 interactive pages, using 5 KPI cards, 20 charts and 4 page-synced slicers. It is a
Read More
Power BI Templates

Cement Mixer Production Dashboard in Power BI

August 17, 2026August 17, 2026 PKComments Off on Cement Mixer Production Dashboard in Power BI
A cement mixer works runs on a batch log: which line built what, on which shift, how many units were planned against produced, how many were rejected, and what the
Read More
Dashboard Templates

Cement Mixer Production Dashboard in Excel

August 17, 2026August 17, 2026 PKComments Off on Cement Mixer Production Dashboard in Excel
A cement mixer plant generates one row per batch, and by the end of a year that is a few thousand rows of planned units, produced units, rejects, machine hours,
Read More
Power BI Templates

Career Counseling Centers Dashboard in Power BI

August 16, 2026August 16, 2026 PKComments Off on Career Counseling Centers Dashboard in Power BI
Most counseling centres already have the numbers. They sit in a spreadsheet of session records - who was seen, by which counselor, at which site, for how many hours, at
Read More
Dashboard Templates

Career Counseling Centers Dashboard in Excel

August 16, 2026August 16, 2026 PKComments Off on Career Counseling Centers Dashboard in Excel
A career counseling centre generates a surprising amount of data and almost never has anywhere good to put it. Session dates, counselor names, service types, delivery modes, referral sources, fees,
Read More
Power BI Templates

Carpooling Platforms Dashboard in Power BI

August 16, 2026August 16, 2026 PKComments Off on Carpooling Platforms Dashboard in Power BI
Most carpooling operators can tell you how many rides they ran last month. Far fewer can tell you, in the same breath, what share of the offered seats were actually
Read More
Dashboard Templates

Carpooling Platforms Dashboard in Excel

August 16, 2026August 16, 2026 PKComments Off on Carpooling Platforms Dashboard in Excel
Carpooling operators sit on a lot of ride data and very little reporting. Every completed trip produces a fare, a driver payout, a seat count, a distance and a carbon
Read More
Templates VBA

Supplement Sales Data Entry System in Excel

August 16, 2026August 16, 2026 PKComments Off on Supplement Sales Data Entry System in Excel
The Supplement Sales Data Entry System in Excel is a macro-enabled workbook built around one job: recording supplement orders quickly and accurately. It ships with a 7-field entry form, 3
Read More
VBA

Bar Stock Register Data Entry System in Excel

August 16, 2026August 16, 2026 PKComments Off on Bar Stock Register Data Entry System in Excel
The Bar Stock Register Data Entry System in Excel records every bottle, case and keg through a seven-field entry form, shows four live KPI cards — Total Items, Total Stock
Read More

Posts pagination

Previous 1 … 4 5 6 … 418 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