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

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

Dashboard VBA

Vehicle Reservation Tracker in Excel

May 3, 2026May 3, 2026 PKComments Off

Vehicle Reservation Tracker in Excel — Overview Managing office vehicles sounds simple — until 5 different people request the same pool car for Tuesday morning, the field-staff van comes back

Dashboard Templates VBA

Client Contract Amendment Tracker in Excel

May 2, 2026May 2, 2026 PKComments Off

The Client Contract Amendment Tracker in Excel logs every contract change across 8 purpose-built worksheets, with a password-protected Login Form, a VBA-driven Data Entry form (Add / Update / Delete),

Dashboard VBA

Office Key Access Request Tracker in Excel

May 1, 2026May 1, 2026 PKComments Off

Office Key Access Request Tracker in Excel — Overview Managing office keys sounds simple — until 12 different people share a single cabinet key, the server room key disappears for

VBA

Monthly Budgeting Calendar in Excel

April 27, 2026April 27, 2026 PKComments Off

In this article we have created a Monthly Budgeting Calendar in Excel. This is a ready-to-use calendar template in Excel that helps you track monthly bills, income dates, tax deadlines,

VBA

Training Material Request Tracker in Excel

April 23, 2026April 23, 2026 PKComments Off

The Training Material Request Tracker in Excel is a VBA-powered workbook that lets HR, L&D, and training teams log, approve, and report on every request for manuals, e-learning licences, printed

Dashboard Templates VBA

Inventory & Warehouse Master Kit – 8 Premium Excel + Google Sheets + VBA Templates (Save 36%)

April 11, 2026April 14, 2026 PKComments Off

Managing inventory across multiple warehouses, platforms, and teams is one of the most complex challenges businesses face today. From tracking stock levels to managing purchase orders, sales transactions, and warehouse