• 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

Tag: VBA

Excel Tips and Tricks

How Chat GPT can help to write Complex Excel Function, VBA code and DAX for Power BI

January 30, 2023January 30, 2023 PKComments Off on How Chat GPT can help to write Complex Excel Function, VBA code and DAX for Power BI
Introduction Have you ever tried to write a complex Excel function, VBA code, or DAX using natural language? It can be challenging and time-consuming. If this is your situation, then
Read More
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
6 Type of Password Protection in Excel
Excel Tips and Tricks

Six types of Password Protection in Microsoft Excel

October 31, 2022October 31, 2022 PKComments Off on Six types of Password Protection in Microsoft Excel
In this article, we have explained six types of password protection in Excel. You can use these tricks in your Excel reports and VBA Projects file. 1. File Protection to
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
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
Employee Timesheet
Templates

Automated Employee Timesheet Template in Excel

April 13, 2022April 13, 2022 PKComments Off on Automated Employee Timesheet Template in Excel
In this article, we have created an automated Employee Timesheet Template in Excel. You can use this template to capture the Employee's Productive hours. We have used several validations and
Read More
Setting Sheet
Templates VBA

Automatic Invoice Creator V1.0

July 18, 2021July 18, 2021 PKComments Off on Automatic Invoice Creator V1.0
Automatic Invoice Creator V1.0 is a useful template to create multiple invoices in Excel and PDF format. There are three worksheets in this Automation file. 1-Setting: In this worksheet, you
Read More
5 VBA Userform Super Tips
VBA

5 VBA UserForm Super Tips

March 29, 2021March 29, 2021 PKComments Off on 5 VBA UserForm Super Tips
In this article, you will learn 5 super useful VBA User form related tips. You can use these tips in your VBA Application or Automation. Below is the list of
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