Excel Forum
Similar Content
List All Named Ranges in Excel - Displays the Name and Value for Every Named Range Within the Active Workbook in Excel
Macro: List all of the named ranges in a workbook in Excel and the corresponding values store...
Enter a Constant Value in a Defined Name in Excel - Text, Numbers, Formulas, Etc.
Tutorial: In Excel you can store values in Defined Names.  Often people use a Defined Name to refer...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...

Office 2010 Class #26: Excel Assumption Tables (Formula Inputs) & Cell Ranges in Functions

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
1. Orientating Assumption Tables for Formula Inputs for Maximum Efficiency so that you can use Mixed Cell References
2. How to use Cell Ranges instead of individual cells for Maximum Efficiency (=SUM(F3:H3) instead of F3+G3+H3)

Got a Question? Ask it Here in the Forum.