I wish I could brag about how named ranges help me professionally. They do, but I don’t have a cute story about it. However, it is easier for me to set up tables and formulas when I think about what each cell’s contents represent rather than the actual cell references. Seriously, Z3432? Who cares? I want to know what it means.
Named ranges also come in handy when you start working with the table objects in Excel. This concept makes structured referencing that much easier.
Wanna learn how?
Excel Intermediate is a six-week course starting:
Tuesday, January 4, 2022
7:00-8:00 pm EST