![monthly task planner template excel monthly task planner template excel](https://i.pinimg.com/originals/82/2b/f4/822bf40ee46d910308b41ab5701bf9dd.jpg)
![monthly task planner template excel monthly task planner template excel](https://www.tasklist-template.com/wp-content/uploads/2017/10/excel-project-schedule-template-complete-ss-PpBLdl.jpg)
Click on this to open and select a month.Now, if you go to the month cell in the worksheet, you will see a drop-down option to open.And, type “= Month” in the Source option and press OK.then, select the “ List” option in the Allow menu.As an outcome, a window named “ Data Validation” will appear.Then, go to the Data tab and click on the Data Validation option.For this, you have to make a drop-down option in the cell to select a month. And the data for the whole year will be on the same worksheet. We want to make a template for tracking attendance where you can shift from one month to another easily. STEP 4: Insert Formula for Month, Start Date & End Date And insert the data of participants’ names and ids. Now, make columns and cells with the necessary things listed before. STEP 3: Make The Template Structure to Track Attendance Then, type “ Type” as the name and press OK.Lastly, select the Type cells and go to the Defined Name option.Then, type “ Holiday” as the name and press OK.Similarly, select the holiday cells and go to the Defined Name option.Here, give a suitable name for the list of cells.
![monthly task planner template excel monthly task planner template excel](http://www.exceltemplate123.us/wp-content/uploads/2018/01/examples-template-excel-calendar-shchm-elegant-annual-calendar-template-annual-calendar-template-printable-of-template-excel-calendarv1j374.jpg)
After that, you will see a window named “ New Name”.Then, go to the Formula tab > Defined Name option.To do this, select the cells of months.First, define a name for the list of the months.Defining the name will allow you to use the Data Validation tool to make a drop-down menu in the cells. You can add or remove holidays as per the calendar of your institution.Īfter inserting the necessary information, you have to define name for them. ? NOTES: I haven’t listed all the holidays in this workbook.