Excel Templates Archives

Templates

Free Dynamic annual calendar with holiday and Control Panel

March 12, 2023March 12, 2023 PKComments Off

In the modern era, managing tasks and schedules is a significant challenge. This challenge can be effectively addressed by using a dynamic annual calendar that can track important dates, events,

Templates

Inventory Management Template for Multiple Locations

November 28, 2022November 28, 2022 PKComments Off

In this article, we have created an Inventory Management Template for multiple locations or warehouses. You can use this template to see the daily inventory for multiple products and warehouses.

Excel Tips and Tricks

Fill Series in Excel

November 13, 2022November 13, 2022 PKComments Off

In this article, we have explained how to use Fill Series in Microsoft Excel. Fill Series is used to fill the series of numbers or dates quickly. You can

Templates VBA

Fully Automated Bulk WhatsApp Sender in Excel

November 7, 2022March 1, 2023 PKComments Off

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

Charts and Visualization Templates

Weightage Analysis Template in Microsoft Excel

October 10, 2022October 10, 2022 PKComments Off

In this article, you will learn how to use Weightage Analysis in Microsoft Excel. Weightage Analysis is used to get the Weightage Score calculation based on different parameters. In

Templates VBA

Invoice Management System V1.0

July 5, 2022July 5, 2022 PKComments Off

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

Templates VBA

Automated Multiple Emails with Multiple Attachments and “From” option

May 30, 2022September 18, 2022 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

Templates

Break-Even Analysis Template in Excel

May 8, 2022May 8, 2022 PKComments Off

What is break-even Analysis: Break-Even Analysis is used to check what number of units should be sold to fulfill all expenses of a business. We have used the Fixed and

Templates VBA

Leave Management System in Excel

April 19, 2022April 19, 2022 PKComments Off

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

Templates

Automated Employee Timesheet Template in Excel

April 13, 2022April 13, 2022 PKComments Off

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