In this video, we look at how to use relative references in named ranges. What the benefits with an example and then see how we can write a formula in the named range.

Enrol in the ultimate Excel course and learn it all – https://bit.ly/UltimateExcel

Creating named ranges can simplify how you refer to cells when writing formulas, creating charts and Conditional Formatting rules.

Typically named ranges use absolute references, because a named area is assumed to be a fixed area of a sheet.

Being able to name your own calculations I think is a strong example of using different reference techniques when defining names.

Find more great free tutorials at;
https://www.computergaga.com

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1

Please take the opportunity to connect and share this video with your friends and family if you find it useful.