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

Templates

Supply Chain Checklist in Excel

April 14, 2025April 14, 2025 PKComments Off on Supply Chain Checklist in Excel
Managing a supply chain is no easy task. It involves constant coordination between vendors, internal teams, logistics partners, and inventory managers. To ensure that nothing falls through the cracks, using
Read More
Power BI

Warehouse Management KPI Dashboard in Power BI

February 11, 2025March 20, 2025 PKComments Off on Warehouse Management KPI Dashboard in Power BI
Warehouse management is a crucial part of any supply chain, ensuring seamless inventory tracking, optimizing storage, and improving operational efficiency. But how do businesses measure and improve warehouse performance? The
Read More
Dashboard

Distribution KPI Dashboard in Excel

December 1, 2024February 28, 2025 PKComments Off on Distribution KPI Dashboard in Excel
Managing a distribution network requires data-driven decisions and accurate insights into key metrics. The Distribution KPI Dashboard is an indispensable tool designed to simplify and optimize this process. This ready-to-use
Read More
Templates VBA

Inventory Management System -V3.0

November 6, 2024February 19, 2025 PKComments Off on Inventory Management System -V3.0
The Inventory Management System -V3.0 is an advanced Excel and VBA-based tool designed for efficient tracking of inventory records. Whether you're managing sales, purchases, or stock levels, this tool simplifies
Read More
Inventory Management Template for Multiple Locations
Templates

Inventory Management Template for Multiple Locations

November 28, 2022February 18, 2025 PKComments Off on Inventory Management Template for Multiple Locations
Efficient inventory management is crucial for any business, especially when dealing with multiple locations or warehouses. Excel inventory management templates can streamline this process, making it easier to track, analyze,
Read More

Posts pagination

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