Nabil Mourad. Data Validation a back door to Master Excel

Independently published, 2020. — 378 p. — ISBN: 1777410916, 978-1777410919.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 course, 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.
You can download the exercise files from the link:
https://officeinstructor.com/books/
Password on last page
Be ready to elevate your Excel Skills and learn lots of Tips and tricks along the way.Who are my target readers?
My students are Excel users who want to impress their clients and colleagues by creating: Powerful, dynamic, and unique functionalities.
Whether you are an Accountant, Financial Analyst, Business Administrator, project Manager an Educator, if you are working in Human resource, Insurance, sales, or marketing this course is for you.
Excel is the most widely used spreadsheet application, being used by over 750 million people across the globe: This course will ensure making the bottom line of your worksheets look Great.Who are NOT my target students?
This course is not for beginner Excel users as I do not spend much time on how to navigate in Excel, or any of the foundational principles.Course Goal
By the end of this course you will be able to create effective and dynamic worksheet functionality cutting the data entry time to just a tiny fraction of what it currently is. You will ensure the data input is only what you want while the output will be impressive to your clients, colleagues, and boss.