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: www.myonlinetraininghub.com/e...
View my comprehensive courses: 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
Негізгі бет Ғылым және технология SECRET Excel Named Range Shortcuts to Save Time
Пікірлер: 142