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/excel-named-range-shortcut 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