This tutorial is your one stop shop to learn everything about naming Cells and Ranges. I show you hidden tricks, shortcuts and powerful techniques for dealing with named ranges whether static or expandable, so let’s dive in.
You can download the Exercise File and Follow along by clicking on the link:
www.OfficeInstructor.com/public

******************** My New Textbook ***************************
*********** Data Validation a back door to Master Excel ***************
***************** Is Now available on Amazon ***********************

It is much more than the Data Validation you know! Through Data Validation I Cover over 60 different Functions, Charts, Slicers, Pivot Tables, Conditional Formatting, Macros, Power Query, Dynamic Arrays, DAX, Data Model and VBA.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Here is what Fellow MVPs Said About my 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.
Bill Jelen
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.
Mynda Treacy
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
######################################################
******************************************************************
########## To Book a Corporate Training #########
######### With Nabil Mourad #########
########## Visit www.OfficeInstructor.com #########
*******************************************************************

Music Credit:
Easy Lemon 30 Second by Kevin MacLeod is licensed under a Creative Commons Attribution license (https://creativecommons.org/licenses/by/4.0/)
Source: http://incompetech.com/music/royalty-free/index.html?isrc=USUAN1200078
Artist: http://incompetech.com/