How to use named cells and ranges in Microsoft Excel

This is a Microsoft Excel tutorial covering how to use named cells and ranges. The tutor starts off by recapping how and why to use dollar signs to lock a cell. The tutor then removes the dollars signs and creates a named cell. The named cell is used in a formula and used as a navigation aid, potential issues with naming a cell is also mentioned. The tutor goes on to explain how to use the computer to quickly name ranges. The Create from selection feature is used and demonstrated. The final part of the video covers how to use named ranges to create formulae. Microsoft Excel tutorial. Use names in Excel.
#msexcel
#namedcells

Join this channel to get access to perks:

Online training courses:

Playlists for this channel:

#itseasytraining

Courses are available through Microsoft Teams, Online and Face to face in the UK

Training Guide Books

Excel for New Managers

Very cheap E_books are here:

[ITsEasyTrainingst]

Can you use named cells and ranges in Microsoft Excel? Check out courses at www.itseasy.co.uk