Naming data in excel and how to use in formulas and lists (a beginners guide to named ranges)
This video explains named ranges in Excel and why it is useful to use them in Excel. This easy beginners tutorial will show you how to create named ranges and then use them in formulas and in creating drop down lists. It also touches on naming in Excel tables.
0:00 Introduction
0:39 Naming ranges
3:21 Editing Named Ranges
4:28 Using Named Ranges in Formulas and Lists
6:26 Shortcuts
7:57 Dynamic Named Ranges
12:10 Naming Tables
The file is available to download from my Google Drive if you want to follow along or use it for reference in your own time.
Download the file here: https://drive.google.com/file/d/1TAX6...
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!
What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
Check out our playlist on inputting, viewing and managing data: • FREE Excel course for beginners: Week...
Or check out the following videos:
- Drop down lists: • Excel Basics: EXCEL DROP DOWN LIST - ...
- Index function tutorial: • INDEX tutorial: Learn all you need to...
