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.

VBA

CRM and Sales Pipeline Management System in Excel VBA

September 26, 2026 PKComments Off on CRM and Sales Pipeline Management System in Excel VBA
The CRM and Sales Pipeline Management System is a macro-enabled Excel workbook that runs a whole sales desk from one file: 16 worksheets, 12 VBA entry forms, 4 pivot dashboards,
Read More
Blogs Templates VBA

Table Reservation Log Data Entry System in Excel

September 26, 2026September 26, 2026 PKComments Off on Table Reservation Log Data Entry System in Excel
Table Reservation Log Data Entry System in Excel is a focused VBA workbook for restaurants, cafes, bistros, and small hospitality teams that need a clear internal booking register without a
Read More
Templates VBA

Kitchen Inventory Log Data Entry System in Excel

September 26, 2026September 26, 2026 PKComments Off on Kitchen Inventory Log Data Entry System in Excel
Kitchen Inventory Log Data Entry System in Excel turns a loose kitchen stock list into a repeatable three-sheet workflow. The workbook shown here contains four live summary cards, six sample
Read More
Templates VBA

Menu Item Master Data Entry System in Excel

September 26, 2026September 26, 2026 PKComments Off on Menu Item Master Data Entry System in Excel
Menu Item Master Data Entry System in Excel is a macro-enabled workbook for maintaining a structured menu catalogue without relying on scattered notes or inconsistent tables. The verified file starts
Read More
Templates VBA

Food Delivery Log Data Entry System in Excel

September 26, 2026September 26, 2026 PKComments Off on Food Delivery Log Data Entry System in Excel
The Food Delivery Log 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

Catering Order Book Data Entry System in Excel

September 24, 2026September 24, 2026 PKComments Off on Catering Order Book Data Entry System in Excel
The Catering Order Book Data Entry System in Excel turns a paper order diary into a 4-sheet, macro-enabled workbook: a 7-field entry form, 4 VBA buttons, 4 live stat cards,
Read More
Templates VBA

Cake Order Register Data Entry System in Excel

September 24, 2026September 24, 2026 PKComments Off on Cake Order Register Data Entry System in Excel
The Cake Order Register 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

Bakery Order Booking Data Entry System in Excel

September 24, 2026September 24, 2026 PKComments Off on Bakery Order Booking Data Entry System in Excel
The Bakery Order Booking Data Entry System in Excel turns a paper order book into one macro-enabled workbook: a 7-field order form, 4 VBA buttons, 4 live stat cards, 12
Read More
Templates VBA

Cafe Daily Sales Data Entry System in Excel

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

Grocery Store Billing Data Entry System in Excel

September 23, 2026September 23, 2026 PKComments Off on Grocery Store Billing Data Entry System in Excel
The Grocery Store Billing Data Entry System in Excel is a macro-enabled workbook with a 7-field bill form, 4 VBA buttons, 4 live stat cards and 3 dropdown lists holding
Read More

Posts pagination

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