


EXCEL FUNCTION – DATE
While using Microsoft Excel, you must have got the situation where you need to use the Date function. Date function is one of the common and most used function in Excel that helps in various…

Create Pareto Chart In Excel

VBA Code to Sum Cells by Color
VBA code that will sum cells by its color through excel function. This code will really help in making the analysis and presentation better.

How to Insert Symbol in Excel Numbers?
Have you ever faced the challenge while using special character symbols in number formatting or any customized number formatting? It is an easy method to insert any symbol in numbers i.e Delta Symbol or Special…

Usage of Delta Symbol in Excel – Complete Guide

How to Insert Symbol in Excel
I came across many queries regarding inserting special symbols in Excel. Here we are guiding how you may do this quickly in excel. Follow these steps and you may insert any kind of special characters…

What is VLOOKUP in Excel?
An ultimate guide for basic user to understand Excel Vlookup function. VLOOKUP is a vertical lookup which helps the user to extract the values from other columns (leftmost) basis on matching column string.

Time and Motion Study – Complete Guide
Here is one more wonderful free tool from ExcelSirJi.com which makes your life easy. Time & Motion Tracker helps you to track Start and End time of any type of transaction or activity. The good thing is, it is VBA based tool which helps you to protect from manual manipulation in the data by the user. It is also easy to use, just click on Start (shortcut: Ctrl+Shift+A) or Stop (Ctrl+Shft+S) buttons to record the time

VBA Code to Delete File
In this article we are going to show you how you can delete file or files using a single line of VBA code. 1. Delete a specific file from the folder, 2. Delete specific type of files from the folder, 3. Delete all files from the folder

VBA Code to Add Border to Excel Range
Through formatting the cells, you can make your Excel data more beautiful and easier to understand. If you record a macro to add borders to Excel range, you will notice that it generates 30 plus lines of code for just a small work. Here we are sharing one line of code which does the same thing.

Video – How to Use Conditional Formatting?
This video will help you to understand how you may use conditional formatting to highlight row based on conditions. Subscribe us for more updates

Protect Excel Sheet for Manual Input but Allow Programming Inputs
Did you come across any requirement where you want the user to interact with a sheet only through VBA Form? Here is a simple code which can help you.

VBA Code to Protect Excel Sheet for Manual Input but Allow Programming Inputs
Did you come across any requirement where you want the user to interact with a sheet only through VBA Form? Here is a simple code which can help you here.

VBA Code to Add Items in ListBox Control in Userform
Using ListBox in Userform is very common. You can use ListBox.AddItem function to add items in the listbox.; however, it is little difficult to add items in Listbox when the number of columns are more…

Find Duplicates in Excel

Remove Duplicates in Single Column

VBA Code to Find Duplicate Files

VBA Code to Find Last Column or Row of a Sheet
Sometimes as a developer, you need to take actions in Excel sheets based on last row or column. In Excel, there are two kinds of last cells available: The last cell of the sheet which…

VBA to Read Excel Data using Connection String
Sometimes as a programmer you need to read heavy (more then 5 MB) Excel files. There are two ways you can read data from Excel files: Open the file using VBA and read the data….

Excel VBA Tool to Rename Files
Here is another help code and tool for programmers to rename files. You can use this tool for renaming all files available in a selected folder. Just browse the folder and hit ‘Rename Files’ button…