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: Excel inventory

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

Spare Parts Inventory Data Entry System in Excel

September 21, 2026September 21, 2026 PKComments Off on Spare Parts Inventory Data Entry System in Excel
The Spare Parts Inventory Data Entry System in Excel is a macro-enabled workbook with a 7-field entry form, 4 VBA buttons, 4 live stat cards and 3 dropdown lists holding
Read More
Power Pivot

Product Inventory Data Entry System in Excel

June 20, 2026June 20, 2026 PKComments Off on Product Inventory Data Entry System in Excel
The Product Inventory Data Entry System in Excel tracks 6 inventory fields — Product Name, Category, Stock Qty, Unit Price, Reorder Level, and Supplier — with 3 live KPI cards
Read More
Web-based-Advanced-Inventory-Management-System
Templates

Web-based: Advanced Inventory Management System

May 13, 2026May 13, 2026 PKComments Off on Web-based: Advanced Inventory Management System
The Web-based: Advanced Inventory Management System is a Google Apps Script web app that pairs a browser front-end with Google Sheets as the database. It covers 11 fully-linked pages, 2
Read More
Dashboard

Product Inventory Report in Excel

April 21, 2026April 21, 2026 PKComments Off on Product Inventory Report in Excel
Running a warehouse, retail chain, or e-commerce operation means living inside inventory data — reorder points, vendor lead times, dead-stock piling up on shelves, and inventory value spread across locations
Read More
Templates VBA

Office Supply Inventory Update Tracker in Excel

June 15, 2025June 15, 2025 PKComments Off on Office Supply Inventory Update Tracker in Excel
Managing office supplies is a vital yet often overlooked aspect of business operations. Keeping track of inventory, ensuring timely restocking, and maintaining smooth office functioning all depend on a well-organized
Read More
Templates

Inventory Restocking Calendar in Excel

January 31, 2025April 2, 2025 PKComments Off on Inventory Restocking Calendar in Excel
Managing inventory efficiently is a key part of running any business. Without an effective system in place, stock shortages, overstocking, and missed restocking opportunities can lead to lost sales, increased
Read More
  • 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