Download PDF – 398 pages
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, you are in control of the user’s input.
It also makes data entry easier and ensures the integrity of your worksheet by avoiding typing errors when users can simply select an option from a drop list.
In a more advanced scenario data Validation can make a regular worksheet look like a dynamic dashboard.
In this book, we explore the full potential of the 8 types of data validation.
We start with the basic functionality, then we discuss 2 types in profuse details: Custom and List Data validation. Along the way, we will be tackling almost every functionality in Excel and relate it to our topic. Through Data Validation I will be covering over 60 different functions, Charts, Slicers, Pivot Tables, Conditional Formatting, Macros, Power Query, Data Model, Dynamic Arrays, DAX and VBA.
Downloadable Exercise Files
Because practicing is an integral part of the learning process, I am providing all the exercise files so that you can follow step by step.
Download details are in the last page of the book.
What did Fellow MVPs Say about this book?
Data Validation … A Back Door to Master Excel is the most thorough book about using Data Validation in Excel. The author, Nabil Mourad explains clever uses of Data Validation far beyond simply limiting what can be entered in a cell.
Microsoft Excel MVP, Publisher MrExcel.com
Data Validation provides your users with convenience in the form of drop-down lists, but more importantly, it provides you with protection against those unruly users who try to enter any old data into a cell by ensuring the data entered meets criteria you set. As a result, you spend less time fixing messy data that was entered incorrectly in the first place and have more time to create the clever interactive techniques Nabil covers in this comprehensive guide to Data Validation.
Microsoft Excel MVP , MyOnlineTrainingHub.com
It’s thrilling to see this topic covered in such great detail. Data inputs and data quality aren’t as sexy as AI or data visualization, but data quality is important no matter what’s being done with data. And data validation is critical in supporting data quality. I’m so glad to see Nabil take this on. He’s a fantastic instructor and an experienced data professional. A true warrior in the battle to keep data clean and useful.
Oz du Soleil
Microsoft Excel MVP , LinkedIn Instructor