6. Advanced Worksheet Formulas

  1. E. Joseph Billo

Published Online: 1 NOV 2011

DOI: 10.1002/9781118093955.ch6

Excel for Chemists®: A Comprehensive Guide, Third Edition

Excel for Chemists®: A Comprehensive Guide, Third Edition

How to Cite

Billo, E. J. (2011) Advanced Worksheet Formulas, in Excel for Chemists®: A Comprehensive Guide, Third Edition, John Wiley & Sons, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118093955.ch6

Publication History

  1. Published Online: 1 NOV 2011
  2. Published Print: 16 SEP 2011

ISBN Information

Print ISBN: 9780470381236

Online ISBN: 9781118093955

SEARCH

Keywords:

  • advanced worksheet formulas;
  • drop-down name list box;
  • name manager;
  • implicit intersection;
  • paste names

Summary

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