• 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: Automation

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
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
Send WhatsApp and Email without VBA
Templates

Send WhatsApp and Email without VBA

January 17, 2022March 3, 2023 PKComments Off on Send WhatsApp and Email without VBA
In today's fast-paced world, communication has become an integral part of our lives. We need to stay connected with our colleagues, friends, and family. WhatsApp and Email are two of
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
Auto Email using Schedule
VBA

Hourly Auto Email with Scheduler

November 1, 2020November 15, 2020 PKComments Off on Hourly Auto Email with Scheduler
In this article, we have created an automation to send everyday auto multiple emails using scheduler in Excel VBA. We have used Microsoft Outlook to send the multiple email using
Read More
Email with Signature-
VBA

Bulk Auto Emailer with Picture Signature and HTML body

September 20, 2020September 20, 2020 PKComments Off on Bulk Auto Emailer with Picture Signature and HTML body
In the article, we have created a Bulk Auto Emailer with Picture Signature and HTML body. We have given the 2 form control option button to select the send or
Read More
Send Multiple Mails
Templates VBA

Send bulk emails using VBA and Outlook

July 6, 2020July 6, 2020 PKComments Off on Send bulk emails using VBA and Outlook
In this article, we have create an automation for send multiple emails on one click. This automation will send the emails using Microsoft Outlook. Watch the step by step video
Read More
Email Data Consolidation Tool
Power Pivot VBA

Email Data Consolidation Tool in Excel

April 26, 2020February 27, 2023 PKComments Off on Email Data Consolidation Tool in Excel
Now a days businesses rely more heavily on email communication. Managing data from multiple sources can become a real challenge. Fortunately, there is a solution: an email data consolidation tool
Read More

Posts navigation

1 2 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