Excel Ranges

The UK's most regular instructor-led training courses.
Training information: microsoft.excel.training · Microsoft excel training · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2007

3 posts

ReplyTue 19 Jan 2010, 16:28Delegate Shreyas said...

Shreyas has attended:
Project Intro Intermediate course
Excel Intermediate course
Excel Advanced course
Visio Advanced course

Excel Ranges

Why do you use a ! in ranges?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Thu 18 + Fri 19 Mar 2010	Southwark	0	FULL
2003	Mon 22 + Tue 23 Mar 2010	Bloomsbury	2		£495	£495
2007	Tue 6 + Wed 7 Apr 2010	Bloomsbury	4		£470	£475
2003	Wed 7 + Thu 8 Apr 2010	Southwark	7		£445	£450
2007	Thu 15 + Fri 16 Apr 2010	Bloomsbury	0	FULL
2003	Wed 21 + Thu 22 Apr 2010	Bloomsbury	8		£445	£450
Full Schedule: See all 36 Excel VBA Intro Intermediate course dates. Bookings currently available until 22nd December 2010.

642 posts

ReplyThu 21 Jan 2010, 08:49Trainer Simon said...

RE: Excel Ranges

Hi Shreyas,

Thank you for your question.

An exclamation mark is used when creating formulas relating to cells in another worksheet or workbook.

The following formulas shows a link to cell C1 in Sheet2:

=Sheet2!C1

The exclamation mark separates the Sheet Name from the cell.

I hope this answers your question.

Regards

Simon

Wed 27 Jan 2010: Automatically marked as resolved.

· Basic Excel Training
· Data Basics Using Excel
· Organisation At Your Fingertips - Take Control Of Your Life With Excel
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?
· Crazy Things People Have Done With Excel

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