By Andrew Gould

Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-range-names-basics/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Range names provide a convenient way to reference cells using names rather than references, making your formulae easier to read and understand. This video teaches you the basics of creating, editing and using named ranges in Excel.

Chapters
00:00 Topic list
00:43 Getting Started
01:45 Typing Range Names
04:16 Using Names in a Formula
05:52 Relative and Absolute References
09:15 Creating Multiple Names
12:19 Deleting a Name
13:33 Changing a Name
15:08 Changing the Range
18:22 Inserting Cells in a Range
19:57 Using Names in Functions
23:39 Using Names in Data Validation
25:13 Printing a List of Names

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!