Download Tag: excel

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

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