 | Introduction to Named Ranges |  |
|
Added to Library on 25 Apr 2007
Length: 7 mins
View Tutorial Movie
Download File Used |
Once you have mastered the basics of Excel Named Ranges you will be able to make complicated equations and expressions that are simple to understand (and possibly debug at a later date!)
This tutorial shows you how to add and delete named ranges and how to use them in simple equations, equations over multiple cells and excel functions.
|
|
Related Tutorials:
Adding Drop Down Lists to your Speadsheet
|
Feedback for this tutorial:
"Sweet! Clayton I have tried with no success to figure out a way to get around Excel's limited access to drop down data. You have shown me what I haven't been able to do on my own! Thank you so much. I can not wait to put this new information in action. Kay Lenort"
"Thanks Clayton, this is one tool I will DEFINITELY use in my workplace to help understand formulas when I come back to them long after they were created."
"Hi Clayton
Thanks for the naming ranges tutorial. It has lots of potential and as you say once you have the hang of it then it can open doors to more complex and larger workbooks and make the auditing of formulas easier. Again the KISS principle is really appreciated. Kind regards
Rob Kearnes"
"I thought I knew all about names, but I have learned new things from your tutorial.
This feedback page is also very good and I like it"
"While I used named cells before, you showed me how to use a named range with a validation list. This was new and will prove to be a useful skill to add to my excel knowledge. Thanks"
"Clayton,
This one is EXCELLENT, I can and will use this directly. thank you. I thought I was aware of most of the use. Thank you for this one.
Sharon "
|
|
|
| |
 | |  |
|
|
|
