Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Advanced - Applying Names

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel Advanced - Applying Names

Resolved · Low Priority · Version 2003

Reply Sat 13 Dec 2008, 16:08Delegate Stefania said...

Stefania has attended:
Excel Introduction course
Outlook Advanced course
Outlook Introduction course
Excel Intermediate course
Excel Advanced course
Word Introduction course
Word Intermediate course
Word Advanced course
Powerpoint Introduction course
Powerpoint Intermediate Advanced course
Dreamweaver Introduction (2 days) course

Excel Advanced - Applying Names

Hi,
I am reading the reference manual and page 5 talks about applying names.
I do not understand this section, how it is useful or what I am supposed to do.

Can someone please help me?

Thank you

Stefania

For upcoming training course dates see: Pricing & availability

Reply Mon 15 Dec 2008, 10:02 Edited on Mon 15 Dec 2008, 10:03Trainer Pete said...

RE: Excel Advanced - Applying Names

Hi Stefania,
Thank you for your question;
In answer: We use names to give unique properties to our cells or ranges of cells. When you name a cell or range that name becomes unique throughout the workbook and can be used in a formula or function. (Or to put it another way) If you consider an absolute cell reference which is fixed in a worksheet formula, a named cell would be fixed through the workbook....I hope that helps..

Reply Mon 15 Dec 2008, 15:14Delegate Stefania said...

RE: Excel Advanced - Applying Names

Hi Pete,
thank you for your reply.
I will practice this evening about it.

Kind regards

Stefania

Excel articles

· How To Get The Best Out Of Excel With The Internet
· Identifying Suitable Candidates For VBA For Excel Training
· How Many Different Ways Can You Sum In Excel 2007?
· How To Use Filtering In Excel 2010
· Using Excel In Any Condition

Please browse our web site to find out more about
course excel training vba london and other Microsoft training courses.

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips