Download Category: Microsoft Excel

School Attendance Register and Report

School Attendance Register and Report4 DownloadsThis Excel template can be used as an attendance register tool. You can create printable class and student attendance reports. This is ideal for use in schools and educational institutes. It can also be used at work places to track employee attendance. The template can track attendance for up to 50 students. You can customize your academic year (up to 366 working days). You can choose whether only Sundays or both Sundays and Saturdays are holidays. In addition, up to 20 school Holidays can be…

Read More

Dynamic dropdown – examples

Dynamic dropdown – examples1 DownloadThe tutorial shows how to create an Excel drop down list depending on another cell by using new dynamic array functions. Creating a simple dropdown list in Excel is easy. Making a cascading drop-down has always been a problem. The above linked tutorial describes four different approaches, each including a crazy number of steps, a bunch of different formulas, and a handful of limitations relating to multi-word entries, blank cells, etc. Here is the post. Download Now!

Read More

How to change to sentence case in Excel – Example

How to change to sentence case in Excel – Example0 DownloadsThis is an example file related to the post “How to change to sentence case in Excel“. How to change a normal text to sentence case in Excel if we don’t have any function or option? In this port I explain how. Download Now!

Read More