Templates

Dynamic Calendar in Excel

This calendar template is fully dynamic. If you will change the month or year in the drop down calendar will be change automatically. To creating the month and year drop down Form Control combo box has been used. It has been created purely in Excel with the help of formulas and conditional formatting. No VBA has been used. [caption id="attachment_2434" align="aligncenter" width="641"] Dynamic Calendar in Excel[/caption] Click to download Dynamic
Data Consolidation Macro
Templates

Data Consolidation from multiple files in Excel

This template has been designed for consolidating the data from multiple excel file into a single file. This is very time saving template and can make your work very easy. There are two worksheet available in template file, one is "Logs" and second is "Consolidated_Data". Logs worksheet: In this worksheet on Column A you will see the File Names from which you have consolidated the data and on column B
Templates

Data Entry Form in Excel

This data entry form has been designed in VBA. You can enter the EMP ID, EMP Name, Gender, Designation and Salary. Since Excel sheet is protected so data can not be changed manually. [caption id="attachment_2413" align="aligncenter" width="546"] Data Entry Form Output[/caption] There are three buttons available in this worksheet. 1.Add New Record By using this button a record can be added on the worksheet. Below given form will be opened
Templates

Bow and Arrow Game in Excel

Bow and Arrow Game has been designed in Excel with help of VBA. Few images have been taken form pixabay.com. In this game you have to shoot the apple which is dropping from the tree with the help of 10 arrows. There is a speed drop down available with the Low, Medium and High option. You can the apple dropping and arrow speed by changing this drop down. [caption id="attachment_2401"
Attendance Tracker
Templates

Attendance Tracker in Excel

Attendance tracker or Attendance sheet is essential to any organization. This Attendance tracker is designed for keep one month data. In this attendance tracker, Employee Name, Supervisor, Present count, Absent Count, Leave Count, unplanned%, Planned % and dates for particular month field are available. [caption id="attachment_2395" align="aligncenter" width="640"] Attendance Tracker in Excel[/caption] Emp Name and Supervisor name to be entered manually. Present Count, Absent Count, Leave Count, unplanned% and  Planned
Age Calculator in Excel
Templates

Age Calculator in Excel

Age Calculator template tells your exact age till today. You need to enter your date of birth in the DOB box. It will given you your age like "You are 26 Years, 3 Months and 4 days old." [caption id="attachment_2384" align="aligncenter" width="982"] Age Calculator in Excel[/caption] To create the Age calculator Datedif formula has been used. on the sheet1 you will find the calculation that how to calculate the age in excel
Absenteeism Report
Templates

Absenteeism Report in Excel

Absenteeism is very useful for any process. In this absenteeism report template there are 6 worksheets available Index: Index worksheet is used to navigate the other worksheet-like summary, month wise, date wise and supervisor wise. [caption id="attachment_2377" align="aligncenter" width="449"] Index Worksheet[/caption] Summary: In this worksheet a chart of month on month comparison for planned% Vs Unplanned% is available. Overall NCNS (No call No show) count , Planned % and Unplanned%