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

VBA

Learn how to automate tasks and create custom functions using VBA (Visual Basic for Applications) in this category. Our tutorials cover basic to advanced VBA programming concepts, including creating user-defined functions and interacting with other Office applications. Each tutorial includes a free practice file and tutorial videos to help you learn easily. Increase your productivity in Excel by automating repetitive tasks with VBA macros and functions. Start exploring this category now and take your Excel skills to the next level.

Templates VBA

Gas Cylinder Sales Data Entry System in Excel

September 23, 2026September 23, 2026 PKComments Off on Gas Cylinder Sales Data Entry System in Excel
The Gas Cylinder Sales 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
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
Templates VBA

Dairy Product Sales Data Entry System in Excel

September 21, 2026September 21, 2026 PKComments Off on Dairy Product Sales Data Entry System in Excel
The Dairy Product Sales Data Entry System in Excel is a macro-enabled workbook with an 8-field entry form, 4 VBA buttons, 4 live stat cards and 4 dropdown lists holding
Read More
Retail Store Management System V1.0 in Excel VBA
VBA

Retail Store Management System V1.0 in Excel VBA

September 20, 2026 PKComments Off on Retail Store Management System V1.0 in Excel VBA
Running a retail shop on a bill book, a stock spreadsheet and a notebook for expenses works right up to the day you need an answer. How much did the
Read More
Templates VBA

Wholesale Order Book Data Entry System in Excel

September 19, 2026September 19, 2026 PKComments Off on Wholesale Order Book Data Entry System in Excel
The Wholesale Order Book Data Entry System in Excel is a macro-enabled workbook with a 7-field order form, 4 VBA buttons, 4 live stat cards and 3 dropdown lists holding
Read More
Templates VBA

Sports Day Practice Calendar in Excel

September 18, 2026September 18, 2026 PKComments Off on Sports Day Practice Calendar in Excel
The Sports Day Practice Calendar in Excel is a macro-enabled workbook that holds a school or club's whole practice season in one file. It ships with 100 sample sessions from
Read More
Templates VBA

Meat Shop Sales Data Entry System in Excel

September 18, 2026September 18, 2026 PKComments Off on Meat Shop Sales Data Entry System in Excel
The Meat Shop Sales 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
Templates VBA

Fruit and Vegetable Sales Data Entry System in Excel

September 16, 2026September 16, 2026 PKComments Off on Fruit and Vegetable Sales Data Entry System in Excel
The Fruit and Vegetable Sales 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
Read More
Templates VBA

Sweet Shop Sales Data Entry System in Excel

September 16, 2026September 16, 2026 PKComments Off on Sweet Shop Sales Data Entry System in Excel
The Sweet Shop Sales 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

Posts pagination

Previous 1 2 3 4 … 38 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