Saturday, January 5, 2019

Use and Importance of Named Ranges in MS Excel (Names in MS Excel)

Use of Named Ranges in Excel will make the formulas easy to read, understand and maintain. This is just another Great Time Saver in Excel something similar to Custom Views. Topics discussed are : 1. Creating a Named Range using Name Box 2. Creating a Names using Name Manager 3. Creating Names from Selection 4. Use in Formula option of Defined Names 5. Uses of Names & Named Ranges 6. Some Cool features of Names & Named Ranges



For receiving notification about video releases, Subscribe to the channel and press the Bell Icon.

https://bit.ly/2qvP29e

No comments:

Post a Comment

Most Used Formula in Excel (15 functions explained in 20 minutes)

Most Used / Most useful 15 Functions in MS Excel are explained with simple Examples, in this video. A must watch Tutorial for Beginner and...