Name Manager: The How's & Why's

Excel Content // My Excel Course // Learn

Next>> Show All [+]Hide All [-]

This topic is all about spreadsheet integrity. In this lesson, you'll learn what the Name Manager is, how it work, when to use it, and why it's important.

Text

Name Manager: The How

00:13 The Name Manager works by allowing you to refer to a cell as something more intuitive than a "Letter" plus a "Number". For example, instead of referring to a cell as say "B10," you can manually change to reflect the data contained therein, such as "Total_Sales". Now, doesn't that make sense?


Name Manager: The Why

03:58 The Name Manager (NM) will give your spreadsheet better readability for others who work within it, making it much more intuitive. Second, NM will increase the integrity of your workbook by helping you write more accurate formulas. Third, NM helps build workbook continuity over time. Check out the real life examples in the next couple videos!


Video

Name Manager: ONE

Loading content...

NameManager-Outlines-1.xlsx

Video Comments


GIF