Enter your email address:

Delivered by FeedBurner


Home Page










Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!

 


eXTReMe Tracker
  Web http://www.klippert.com


  Wednesday, April 05, 2006 – Permalink –

Name that Range

How to use names in Excel


Named ranges are one of the more powerful tools in Excel.

Jan Karel Pieterse of JKP Application Development Services has written a tutorial that will help you understand this technique.

Here are some of the chapter titles:

  • How To Define Range Names

  • How To Use Range Names

  • Absolute And Relative Addressing

  • The Context Of Names

  • Special Names

  • A Step Further: A Formula In A Defined Name

  • Dynamic Names

  • Passing Arguments To A Defined Name Formula

  • Bugs in Excel's Name Object

Range Names in Excel




See all Topics

<Doug Klippert@ 6:17 AM

Comments: Post a Comment

Links to this post:

Create a Link