| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 | Publish Date not found |  0 Views |
In my opinion, there are three main reasons to use Named Ranges in Excel Formulas:
1) They are easier to write – especially when range of cells is large
2) They are easier to remember – e.g. Gross Profit = Sales minus Costs
3) They are easier to explain to others – see example for point #2
1) They are easier to write – especially when range of cells is large
2) They are easier to remember – e.g. Gross Profit = Sales minus Costs
3) They are easier to explain to others – see example for point #2
In this lesson, I demonstrate two ways to create a Named Range. The first is to use the /”Name Box/” in all versions of Excel. The second is to Create a Named Range from Selection.
In my next lesson, I will show you how to modify named ranges and also how to apply named ranges to existing formulas.
Please visit my secure online shopping website – http://shop.thecompanyrocks.com – to preview all of the resources that I offer.
Danny Rocks
The Company Rocks
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
