Advanced Worksheet Formulas
E. Joseph Billo · 2011
This chapter contains sections titled: Using Names Instead of References Defining Names in Excel 2003 To Assign a Local or Worksheet-Level Name to a Cell or Range in Excel 2003 To Assign the Same Worksheet-Level Name to the Same Cell or Range in Several Sheets Defining Names in Excel 2007/2010 More about Using Names Worksheet Functions for the “Power User” Information Functions Lookup Functions Reference Functions Solving a Problem by Using Intentional Circular References Using Excel 4 Macro Functions in Worksheet Formulas To Find Links in a Workbook