• Advanced Excel
    • 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
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us

PK: An Excel Expert

Excel, VBA, and Power BI tutorials

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.

Bulk WhatsApp Sender
Templates VBA

Fully Automated Bulk WhatsApp Sender in Excel

November 7, 2022March 1, 2023 PKComments Off on Fully Automated Bulk WhatsApp Sender in Excel
Do you work with WhatsApp regularly and want to send bulk WhatsApp messages quickly and easily?  Then You will love to learn about our Fully Automated Bulk WhatsApp Sender in
Read More
Make Same Size of Shapes
VBA

Make same size of selected shapes/Charts/Pictures using single click

August 16, 2022August 16, 2022 PKComments Off on Make same size of selected shapes/Charts/Pictures using single click
In this article, we have created a macro to make the same size of the selected shapes, charts, or pictures. It will change the size accordingly to first object in
Read More
Excel to PPT
VBA

Automatic Data Transfer Excel to PowerPoint

July 27, 2022July 27, 2022 PKComments Off on Automatic Data Transfer Excel to PowerPoint
In this article, we have created an Automation to transfer the data from Excel to PowerPoint. You can click on Create PPT button after filling the data in to different
Read More
Invoice Management System
Templates VBA

Invoice Management System V1.0

July 5, 2022July 5, 2022 PKComments Off on Invoice Management System V1.0
In this article, we have created Invoice Management System in Excel. In this template, we have given multiple features as given below -   Create new invoice Update existing invoice
Read More
Bulk Emailer with Multiple Attachments
Templates VBA

Automated Multiple Emails with Multiple Attachments and “From” option

May 30, 2022September 18, 2022 PKComments Off on Automated Multiple Emails with Multiple Attachments and “From” option
In this article, we have created an Automated Bulk Emailer with Multiple Attachments and the "From" option. You can choose the Send or display option buttons. We have given a
Read More
Countif by Cell Background Color
VBA

COUNTIF by cells background color in Excel

May 10, 2022May 10, 2022 PKComments Off on COUNTIF by cells background color in Excel
COUNTIF is an extremely useful function in Microsoft Excel. We use this function to get the count based on some conditions. Here in this article, we have created a user-defined
Read More
Leave Management System
Templates VBA

Leave Management System in Excel

April 19, 2022April 19, 2022 PKComments Off on Leave Management System in Excel
Leave Management System is the enhanced version of the Annual Leave tracker. In this version, we have added a VBA user form to mark the leave for multiple dates in
Read More
Excel to PDF for Selected Sheets
Templates VBA

Excel to PDF Converter for Selected Worksheets

February 14, 2022March 12, 2022 PKComments Off on Excel to PDF Converter for Selected Worksheets
Excel to PDF Converter for Selected worksheets is an extremely useful tool to quickly convert Excel to PDF for Active workbook sheets. You can select the sheets in the box
Read More
Address Book in Excel
Templates VBA

Automated Address Book with Auto WhatsApp and Email

January 4, 2022January 4, 2022 PKComments Off on Automated Address Book with Auto WhatsApp and Email
In this article, we have created an Automated Address Book using the VBA user form. You can enter the contact information for a person like - Name, Mobile Number, Whatsapp
Read More
Visitor Entry form
Templates VBA

Visitor Log Book in Excel VBA

October 17, 2021October 17, 2021 PKComments Off on Visitor Log Book in Excel VBA
In this article, we have created a VBA user form based Visitor Log Book Template. You can use this template in your office to track the records of Visitors. In
Read More

Posts navigation

1 2 … 8 Next
  • Advanced Excel
    • 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
  • VBA Course
  • Products
    • Restaurant Management
    • PK’s Utility Tool V2.0
    • PK’s Utility Tool V1.0
    • Task Management
    • AMS V1.0
    • AMS V2.0
    • Sale/Purchase Software
    • PK’s Function Kit
  • Blogs
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
    • Templates
  • Excel Dashboard
    • Sales Dashboard
    • Process Dashboard
    • Performance Dashboard
    • Project Management
    • Outbound Dashboard
    • Incentive Dashboard
    • Zonal Dashboard in Excel
    • Quick Dashboard
  • Free Templates
  • Power BI
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy