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

Admission Enquiry Data Entry System in Excel

June 15, 2026June 15, 2026 PKComments Off

Coaching institutes and admission desks lose track of prospective students for one simple reason: enquiries arrive faster than anyone can organise them. The Admission Enquiry Data Entry System in Excel

Templates VBA

Student Attendance Data Entry System in Excel

June 14, 2026June 14, 2026 PKComments Off

If you are still marking a register by hand or hunting through a messy spreadsheet at the end of the month, the Student Attendance Data Entry System in Excel gives

Templates VBA

Student Fee Collection System in Excel

June 13, 2026June 13, 2026 PKComments Off

The Student Fee Collection System in Excel records 7 fields per student through a single VBA form and updates 3 live KPI cards — Total Students, Total Fee Collected, and

Templates VBA

Appliance Service Data Entry System in Excel

June 11, 2026June 11, 2026 PKComments Off

The Appliance Service Data Entry System in Excel is a lightweight tool that lets an appliance repair shop log every job - customer, appliance, issue, amount, technician, and status -

Templates VBA

IT Hardware Upgrade Request Tracker in Excel

May 17, 2026May 17, 2026 PKComments Off

If your IT team is still tracking hardware upgrade requests in an Outlook folder, a shared OneDrive spreadsheet, or scattered Teams messages, you already know the pain. Requests get lost.

Templates VBA

Employee Satisfaction Survey Tracker in Excel

May 13, 2026May 13, 2026 PKComments Off

The Employee Satisfaction Survey Tracker in Excel captures every employee response across 8 purpose-built worksheets, with a password-protected Login Form, a VBA-driven Data Entry form (Add / Update / Delete),

Templates VBA

Corporate Sponsorship Request Tracker in Excel

May 7, 2026May 7, 2026 PKComments Off

Corporate development and CSR teams lose an estimated 6–10 hours per week chasing sponsorship request statuses across email chains, shared folders, and disconnected spreadsheets. Worse, decisions get delayed because decision-makers

VBA

Office Safety Inspection Tracker in Excel

May 6, 2026May 6, 2026 PKComments Off

Office safety inspections are no longer just a "nice-to-have" — they are mandated by ISO 45001, OSHA in the US, the Health and Safety at Work Act in the UK,

VBA

Travel Insurance Request Tracker in Excel

May 5, 2026May 5, 2026 PKComments Off

Managing corporate travel insurance requests across a busy team often turns into a tangle of email threads, shared spreadsheets, and missed renewals. The Travel Insurance Request Tracker in Excel replaces

Templates VBA

Supplier Feedback Tracker in Excel

May 4, 2026May 4, 2026 PKComments Off

The Supplier Feedback Tracker in Excel is a VBA-powered workbook that captures, scores, and analyzes feedback against every active supplier through one password-protected file. It bundles 8 sheets — Login