• 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
  • DownloadsPopular
    • Excel VBA Tools
    • Dashboard
      • Excel Dashboard
      • KPI Dashboard
      • Power BI Dashboard
    • Charts
      • Progress Charts
      • Info-graphics
      • Animated Charts
      • Comparisons
      • Gantt Charts
      • Heatmaps
      • Speedometers
      • Timelines
    • Inventory Management
    • HR and Payrolls
    • VBA Automation
    • Utilities and Converters
    • Checklist
    • Calendars
    • Data Analysis
    • Excel Templates
    • Financial Tools
    • Project Management
    • Sales and Marketing
    • Productivity
  • Excel Dashboard
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
  • Power BI
  • Template StoreNew
  • CoursesNew
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: VBA

Project Completion Chart with Animated Progress Circle
Charts and Visualization

Excel Magic: Stunning Animated Progress Circle Charts for Project Tracking

April 24, 2023March 1, 2025 PKComments Off on Excel Magic: Stunning Animated Progress Circle Charts for Project Tracking
Managing projects can often be a daunting task, particularly when it comes to keeping track of progress and presenting it in a visually engaging way. This is where animated progress
Read More
Excel Tips and Tricks

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

January 30, 2023October 9, 2024 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
VBA Templates

Fully Automated Bulk WhatsApp Sender in Excel

November 7, 2022March 29, 2024 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

6 types of Password Protection in Microsoft Excel

October 31, 2022August 6, 2024 PKComments Off on 6 types of Password Protection in Microsoft Excel
Microsoft Excel, a powerful spreadsheet program, offers a range of password protection features that ensure the security and integrity of your data. This article will delve into 6 types of
Read More
Make Same Size of Shapes
VBA

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

August 16, 2022April 9, 2024 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, 2022February 21, 2025 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, 2022February 25, 2025 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, 2022August 12, 2024 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, 2022February 21, 2025 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
Automatic Invoice Creator
Templates VBA

Automatic Invoice Creator V1.0

July 18, 2021February 25, 2025 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. Automatic Invoice Creator V1.0 There are three worksheets in this Automation file. 1-Setting:
Read More

Posts pagination

Previous 1 2 3 … 9 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
  • DownloadsPopular
    • Excel VBA Tools
    • Dashboard
      • Excel Dashboard
      • KPI Dashboard
      • Power BI Dashboard
    • Charts
      • Progress Charts
      • Info-graphics
      • Animated Charts
      • Comparisons
      • Gantt Charts
      • Heatmaps
      • Speedometers
      • Timelines
    • Inventory Management
    • HR and Payrolls
    • VBA Automation
    • Utilities and Converters
    • Checklist
    • Calendars
    • Data Analysis
    • Excel Templates
    • Financial Tools
    • Project Management
    • Sales and Marketing
    • Productivity
  • Excel Dashboard
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
  • Power BI
  • Template StoreNew
  • CoursesNew
  • 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