Drop List

Intelligent Drop Lists and Evolution of Data Validation

New Intelligent Drop List in Excel Table of Contents Introduction 3 The Work Situation 3 The Old Method 4 Creating The Drop List 7 The Recent Method 10 The UNIQUE function 10 Create the Drop List 12 T...

data validation

Simple ways to excel Data Validation… Let’s Push it to the Limit and Beyond

The Magic of Data Validation Introduction Dynamic Data Validation… is a Game changer in Excel, at the basic level it controls what a user can enter or cannot enter in a cell. It also makes data entry ...

Chart in Excel

Impressive Chart with Chart Title Drop List

Download the eBook   Table of Contents Switching Charts with A Drop-Down List 3 1. Creating a data preparation table 3 Creating a drop list for the different months 3 Creating row labels for the ...

Randomize Drop List Items

Extremely easy way to Randomize Drop List Items on Excel with Every Use

Randomize Drop list items in a drop list means every time you use the drop list the contents are the same but appear in a different order. This functionality is extremely user for collecting accurate ...

Do Magic with Excel Drop Lists …Dynamic Dependent Diminishing

In this project I show you how wow your boss, colleagues and clients by creating Dynamic Dependent Diminishing drop lists. At the Basic Level, using drop lists in your worksheet makes entering data an...

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.