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 VBA Automation

VBA

Customer Payment Reminder Tool in Excel VBA

October 4, 2026October 4, 2026 PKComments Off on Customer Payment Reminder Tool in Excel VBA
The Customer Payment Reminder Tool in Excel VBA reads your open invoices, groups them by customer and creates one statement email per customer in Microsoft Outlook. It escalates across 4
Read More
Charts and Visualization Templates VBA

Organization Chart in Excel

August 5, 2026August 5, 2026 PK0
The Organization Chart in Excel template turns a structured employee master table into a clean, dynamic hierarchy inside Excel. The sample workbook shown here includes 18 employee records, 10 employee
Read More
Templates

Employee Health Declaration Tracker in Excel

April 29, 2026April 29, 2026 PKComments Off on Employee Health Declaration Tracker in Excel
The Employee Health Declaration Tracker in Excel consolidates employee health submissions across 8 purpose-built worksheets, with a password-protected Login Form, a VBA-driven Data Entry form (Add / Update / Delete),
Read More
Templates VBA

Training Needs Assessment Tracker in Excel

October 6, 2025October 6, 2025 PKComments Off on Training Needs Assessment Tracker in Excel
In today’s competitive world, continuous learning and development are essential for every organization. Companies invest heavily in training programs, but without the right tracking mechanism, it becomes difficult to measure
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