Automation Archives - PK: An Excel Expert

Templates

Procurement AI Implementation Calendar in Excel

April 25, 2025April 25, 2025 PKComments Off

In today's rapidly evolving procurement landscape, Artificial Intelligence (AI) plays a vital role in driving efficiency and innovation. Yet, without proper planning and structured implementation, many AI initiatives fall short.

VBA

Macro to Create multiple worksheets from selection

August 16, 2024 PKComments Off

Have you ever found yourself in need of an Excel file with multiple worksheets, each customized to fit your needs? If the thought of setting this up seems overwhelming, don’t

Quick Create Sheet for Pivot Table Filters

Excel Tips and Tricks

Pivot Table Magic! Create Multiple Pivot Sheets in Seconds

January 12, 2024June 18, 2024 PKComments Off

Welcome to our latest blog post, where we're excited to share a simple yet powerful technique to enhance your Excel skills. Today, we dive into the world of Pivot Tables,

VBA

Hands-On Guide to Automating Your Excel Data Sorting with VBA

July 17, 2023July 30, 2024 PKComments Off

Introduction Data sorting in Excel is a common task for many users. However, when you need to sort large sets of data repeatedly, doing it manually can be both time-consuming

Download attachments form multiple emails

VBA

Download Attachments from Multiple Emails Automatically using VBA

June 21, 2023February 18, 2025 PKComments Off

Automation has become an integral part of our everyday lives, especially in the realm of business. Among many automation tools, Visual Basic for Applications (VBA) stands out for its utility

Power Pivot Dashboard

KANBAN Board with Power Pivot and VBA for Project Management

May 2, 2023February 21, 2025 PKComments Off

In today's fast-paced business environment, effective project management is essential for achieving success. One tool that has gained significant popularity in recent years is the KANBAN board. In this comprehensive

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

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

VBA

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

August 16, 2022April 9, 2024 PKComments Off

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

VBA

Automatic Data Transfer Excel to PowerPoint

July 27, 2022February 21, 2025 PKComments Off

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

Templates VBA

Automated Multiple Emails with Multiple Attachments and “From” option

May 30, 2022February 25, 2025 PKComments Off

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