Download Tag: microsoft-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

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