• Excel and VBA
    • VBA Course
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • Charts
    • Progress Charts
    • Info-graphics
    • Animated Charts
    • Comparisons
    • Gantt Charts
    • Heatmaps
    • Speedometers
    • Timelines
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
  • Power BI
  • Template StoreNew
  • CoursesNew
  • Ready to Use Templates
  • 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.

Dashboard VBA

Vehicle Reservation Tracker in Excel

May 3, 2026May 3, 2026 PKComments Off on Vehicle Reservation Tracker in Excel
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
Read More
Dashboard Templates VBA

Client Contract Amendment Tracker in Excel

May 2, 2026May 2, 2026 PKComments Off on Client Contract Amendment Tracker in Excel
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),
Read More
Dashboard VBA

Office Key Access Request Tracker in Excel

May 1, 2026May 1, 2026 PKComments Off on Office Key Access Request Tracker in Excel
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
Read More
VBA

Monthly Budgeting Calendar in Excel

April 27, 2026April 27, 2026 PKComments Off on Monthly Budgeting Calendar in Excel
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,
Read More
VBA

Training Material Request Tracker in Excel

April 23, 2026April 23, 2026 PKComments Off on Training Material Request Tracker in Excel
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
Read More
Dashboard Templates VBA

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

April 11, 2026April 14, 2026 PKComments Off on Inventory & Warehouse Master Kit – 8 Premium Excel + Google Sheets + VBA Templates (Save 36%)
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
Read More
VBA

Payroll Calculator and Payslip Generator in Excel

April 1, 2026April 1, 2026 PKComments Off on Payroll Calculator and Payslip Generator in Excel
Managing payroll manually can quickly become complex, time-consuming, and error-prone. From calculating salaries and deductions to generating payslips, businesses often struggle with accuracy and efficiency. As a result, payroll delays
Read More
Dashboard VBA

Smart Grid Services KPI Dashboard in Power BI

March 1, 2026March 1, 2026 PKComments Off on Smart Grid Services KPI Dashboard in Power BI
In today’s rapidly evolving energy ecosystem, utilities and smart grid service providers generate massive volumes of operational data every day. Power distribution networks, renewable integration systems, smart meters, grid automation
Read More
VBA

Interview Scheduling Management System V1.0

February 28, 2026February 28, 2026 PKComments Off on Interview Scheduling Management System V1.0
Managing interviews efficiently is one of the biggest challenges for HR teams, recruitment agencies, and hiring managers. When interview schedules are handled manually using emails, scattered spreadsheets, or notebooks, organizations
Read More
VBA

Insurance Enrollment Management System V1.0 in Excel VBA

February 21, 2026February 21, 2026 PKComments Off on Insurance Enrollment Management System V1.0 in Excel VBA
Managing insurance enrollments manually often creates confusion, delays, and data errors. Many HR departments and insurance administrators still rely on multiple spreadsheets to track employee enrollments, plan selections, and dependent
Read More

Posts pagination

Previous 1 … 7 8 9 … 29 Next
  • Excel and VBA
    • VBA Course
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • Charts
    • Progress Charts
    • Info-graphics
    • Animated Charts
    • Comparisons
    • Gantt Charts
    • Heatmaps
    • Speedometers
    • Timelines
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
  • Power BI
  • Template StoreNew
  • CoursesNew
  • Ready to Use Templates
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy
This website uses cookies to improve your user experience, analyze site traffic and serve targeted ads in accordance with our Privacy Policy ACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT