Download Category: Scripts

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

Create a Positive/Negative bar chart in Excel – Example

Create a Positive/Negative bar chart in Excel – Example0 DownloadsIf you want to show how multiple units does comparison to each other based on the same criteria clearly, you can use the positive negative bar chart which can display positive and negative development very good as below screenshot shown. Download Now!

Read More

How to highlight specific text in Excel – Example

How to highlight specific text in Excel – Example2 DownloadsIn Excel, it may be easy for us to highlight the cells based on a specific text, but, here, I want to highlight a specific text within a cell to make it outstanding but not the entire cell. This maybe a troublesome for most of us. This article, I will talk about some tricks for solving this job in Excel. This file contains an Excel file with macros. Read my post here. Download Now!

Read More

Azure Resource Naming Convention Generator Template

Azure Resource Naming Convention Generator Template21 DownloadsEach resource or service type in Azure enforces a set of naming restrictions and scope; any naming convention or pattern must adhere to the requisite naming rules and scope. For example, while the name of a VM maps to a DNS name (and is thus required to be unique across all of Azure), the name of a VNET is scoped to the Resource Group that it is created within. This spreadsheet helps you to define the name (URL) for each resource. Download Now!

Read More

Reset External Display Cache in Windows 10

Reset External Display Cache in Windows 100 DownloadsUse this Registry file to reset the external display cache in Windows 10. It removes the following entries in the Registry: [-HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\GraphicsDrivers\Configuration] [-HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\GraphicsDrivers\Connectivity] [-HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\GraphicsDrivers\ScaleFactors] Download Now!

Read More