Defining names in Excel has a load of benefits, from faster formula writing, easier to read workbooks and more robust files. In this video I cover the various types of names you can define and some shortcuts the experts use. Download the Excel file here: https://www.myonlinetraininghub.com/e...
View my comprehensive courses: https://www.myonlinetraininghub.com/
Connect with me on LinkedIn: / myndatreacy
0:00 Introduction
0:21 Types of Defined Names
0:37 Defining Named Cells
1:37 Defining Named Ranges
2:07 Defining Names from Tables
2:56 Defining Named Constants
4:07 Defining Named Formulas
5:42 Defined Name Scope
8:53 Defined Name Shortcut