FREE Tools & Templates to Download

Distance Calculator

Macro Enabled Tool

Distance Calculator in Excel

This tool is to show how to use Google API to calculate the distance between two places. It is explained here in this article in detail. Download this Excel tool and learn with fun

  • Calculate distance between places by using transport modes like Car, Cycle, walking, etc.
  • Distance can be calculated between full address or partial address like between two cities
  • To know more about this tool read this article…

.

Folder Structure Creator

Macro Enabled Tool

Folder Structure Creator

Excel VBA tool to create folder structure defined in excel sheet.

  • Excel VBA tool to create folder structure defined in excel sheet.
  • To know more about this Tool read this article.

.

Distance Calculator

Add-in

File Manager – Excel Add-in

This is an Add-in Developed in Excel with a proper user form to manage all files in your system or any particular drive. Basically, it lists all the Files in a folder and sub-folders of any given drive in your PC. It fetches File Name, File Path, File Size, File Type, Last Modified Date of each file and list it in the Excel.

  • Possibility to list the specific type of files ONLY by selecting types of files.
  • Export to Text file or Excel. Using this you can export your File list in two formats: Excel and Text File
  • To know more about this tool read this article…
Excel To VCF File Converter

Macro Enabled Tool

Excel To VCF File Converter

A sample excel workbook, using which you can simply convert contact details stored in an Excel Sheet to a VCF File format which can be imported to your outlook or phone contacts.

  • Very simple Excel tool to convert excel contact in VCF File
  • To know more about this Tool read this article here
BSN Validator

Macro Enabled Tool

BSN validator in Excel

This tool is to validate whether a given number is a valid BSN number or not?

  • Validate BSN on clicking on a button.
  • User Defined Function to validate entered BSN number in a cell.
  • To know more about this Tool and BSN read this article here

 

.

Random BSN Number Generator

Macro Enabled Tool

Random BSN Generator

Excel VBA tool to generate random BSN Number. This is also called SoFi number as well. To know more about BSN number read these articles

 

Distance Calculator

Template

Invoice Template – Automated

There are many small businesses which are using Excel for generating invoices. Keeping that in mind, I have prepared this template to generate invoices. This is very easy to configure for your business and start using it.

  • You can set your logo by using automated button to upload your logo
  • You can configure your own company details, customer details etc.
  • To know more about this tool read this article…
Distance Calculator

Macro Enabled Tool

File Manager (Excel Workbook)

This is a Tool Developed in Excel with a proper UI (User Interface) to manage all files in your system or any particular drive. Basically it lists all the Files in a folder and sub-folders of any given drive in your PC. It fetches File Name, File Path, File Size, File Type, Last Modified Date of each file and list it in the Excel.

  • Possibility to list the specific type of files ONLY by selecting types of files.
  • Export to Text file or Excel. Using this you can export your File list in two formats: Excel and Text File
  • To know more about this tool read this article…
Distance Calculator

Macro Enabled Tool

Bulk Email Sender From Excel

Using this Tool you can send unlimited number of individual emails: What is Individual Mail? If you want to send an email to 1000 different email ID, ONE by ONE, means you are not keeping all the 1000 IDs in TO list and sending one single mail, is called individual mail. In such case it becomes very difficult to send same email 1000 times. This tool will help you doing this just by a single Click

  • Personalized Email Body Designer.
  • Select unlimited number of attachments in one click
  • To know more about this tool read these articles…

.

Distance Calculator

Macro Enabled Tool

Bulk Email Sender Using Word Template

Using this Tool you can send hundreds of personalized emails using an Email Template designed by you in any Word Document. In other words, you can design you email Template in a word document and send email to hundreds of people in the same template but having their relevant data in it.

Distance Calculator

Macro Enabled Tool

GTIN Calculator

This is a Tool Developed in Excel with a proper UI (User Interface) to calculate all types of GTIN Numbers. Basically there are 4 types of GTINs: GTIN-8, GTIN-12, GTIN-13 and GTIN-14. It calculates all of them. To know more about this tool and code logic, how it calculates

  • Possibility to generate GTIN-8, GTIN-12, GTIN-13 and GTIN-14
  • Check digit is calculated automatically and displayed on UI
  • To know more about this tool read these articles…

Buy a coffee for the author

Adsense

What is Excel Formula?

Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).

Dynamic Arrays and Spill Functions in Excel: A Beginner’s Guide
Dynamic Arrays and Spill Functions in Excel: A Beginner’s Guide

In today's tutorial, we'll be diving into the exciting world of dynamic arrays and spill functions in Office 365 Excel. These features have revolutionized the way we work with data, providing a more flexible and efficient way to handle arrays. I am going to explain...

How to Declare a Public Variable in VBA
How to Declare a Public Variable in VBA

While programming in VBA sometimes you need to declare a Public Variable that can store the value throughout the program. Use of Public Variable: Let's say you have 4 different Functions in your VBA Code or Module and you have a variable that may or may not be...

How to Copy content from Word using VBA

As many of us want to deal with Microsoft Word Document from Excel Macro/VBA. I am going to write few articles about Word from Excel Macro. This is the first article which opens a Word Document and read the whole content of that Word Document and put it in the Active...

Adsense

Join and get a FREE! e-Book

Don't miss any articles, tools, tips and tricks, I publish here

You have Successfully Subscribed!

Pin It on Pinterest