SECRET Excel Named Range Shortcuts to Save Time
2 years ago
6
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
Loading comments...
-
26:25
Excel For Freelancers
5 months agoExcel Named Ranges: Everything You Need To Know In Less Than 30 Minutes
50 -
1:26
ScienceAndTech
9 months ago03 Excel Hidden Shortcuts For Your Worksheets | Gonna Speedup Your Work | I Bet You Didn’t Know
3 -
15:14
The Excel Zone
1 year agoExcel Tips, Tricks and Shortcuts Part 3: The Functions You Need to Know
151 -
2:40
Indigo Software
1 month ago[2024] Top 5 Excel Keyboard Shortcuts
3 -
10:04
The Excel Zone
1 year agoExcel Tips, Tricks and Shortcuts Part 2: Efficient Data Management
32 -
13:01
The Excel Zone
1 year ago10 Excel Tips, Tricks and Shortcuts: Productivity Hacks Part 1
59 -
0:18
Dexcelo
1 year agoHide cells with custom formatting in Excel #exceltips #learnexcel #excel #microsoft #shortcuts
1 -
9:21
Emeka8
1 year agoMost Useful Excel Keyboard Shortcuts
1 -
0:25
Dexcelo
1 year agoHow to fill blank cells in Excel #exceltips #learnexcel #excel #shortcuts #excelshortcut #microsoft
6 -
2:25
Excelliott Technology
1 year agoExcel - Creating Name Ranges
1