SECRET Excel Named Range Shortcuts to Save Time

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: https://www.linkedin.com/in/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