New: NextGenTemplates Academy - video courses on Excel formulas with AI and Pivot Tables & dashboards. Early-bird: 20% off with code EARLYBIRD20 - first 20 orders only. See the courses →
  • 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

Tag: Stock Management

Templates VBA

Tyre Shop Stock Data Entry System in Excel

September 23, 2026September 23, 2026 PKComments Off on Tyre Shop Stock Data Entry System in Excel
The Tyre Shop Stock Data Entry System in Excel is a macro-enabled workbook with a 7-field entry form, 4 VBA buttons, 4 live stat cards and 4 dropdown lists holding
Read More
Templates VBA

Tile Showroom Stock Data Entry System in Excel

September 15, 2026September 15, 2026 PKComments Off on Tile Showroom Stock Data Entry System in Excel
A tile showroom carries the same design in several sizes, from several suppliers, in several categories - ceramic, porcelain, vitrified, granite - which is why a stock book kept on
Read More
Templates VBA

Stationery Shop Stock Data Entry System in Excel

September 11, 2026September 11, 2026 PKComments Off on Stationery Shop Stock Data Entry System in Excel
A stationery shop is deceptively hard to count. One shelf of pens is six brands in four ink colours and three tip sizes, the paper aisle turns over in reams,
Read More
Templates VBA

Pharmacy Stock Expiry Calendar in Excel

August 29, 2026August 29, 2026 PKComments Off on Pharmacy Stock Expiry Calendar in Excel
The Pharmacy Stock Expiry Calendar in Excel is a macro-enabled workbook of 7 worksheets that turns a single list of expiry-control activities into 5 linked calendar views. It arrives with
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
Dashboard Power BI

Product Inventory Dashboard in Power BI

August 26, 2025August 26, 2025 PKComments Off on Product Inventory Dashboard in Power BI
Managing product inventory effectively is one of the biggest challenges for businesses today. Stockouts lead to lost sales, while overstocking ties up working capital and increases holding costs. Organizations need
Read More
Power Pivot

Product Inventory Dashboard in Excel

August 2, 2025August 2, 2025 PKComments Off on Product Inventory Dashboard in Excel
Managing inventory effectively is a top priority for businesses of all sizes. Whether you’re running a retail store, a warehouse, or an e-commerce business, keeping track of your product stock,
Read More
Dashboard Power BI

Inventory Management Dashboard in Power BI

July 24, 2025July 24, 2025 PKComments Off on Inventory Management Dashboard in Power BI
In the fast-paced world of business operations, managing inventory efficiently is crucial to the success of any organization. With the advent of tools like Power BI, businesses can now monitor
Read More
Dashboard

Inventory Management Dashboard in Excel

May 18, 2025May 25, 2025 PKComments Off on Inventory Management Dashboard in Excel
Managing inventory can be overwhelming, especially when you have hundreds—or even thousands—of products to track across multiple locations. But what if you could visualize all your key stock data in
Read More
Dashboard

Out-of-Stock Rate KPI Dashboard in Excel

March 8, 2025March 8, 2025 PKComments Off on Out-of-Stock Rate KPI Dashboard in Excel
Managing inventory effectively is crucial for businesses to prevent stockouts and maintain customer satisfaction. The Out-of-Stock Rate KPI Dashboard in Excel is a powerful tool that helps businesses track their
Read More

Posts pagination

1 2 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