microsoft+excel+training - Excell Introduction

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

Resolved · Low Priority · Version Standard

Excell Introduction

Joy has attended:
Excel Introduction course

by - delegate Joy [1 post] (2007 Feb 26 Mon, 11:42) Reply

When entering a formula does it always have to be the column first and then the row ?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excell Introduction

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 26 Mon, 12:01) Reply

Hi Joy,

If you are putting in a formula with cell references the column must go first, for example, A1. The computer would not recognise 1A.

Hope that help and enjoy your training

Tracy

· Do You Really Need Excel VBA Training?
· Tools From Advanced Excel Courses: Goal Seek and Solver
· How to Create Better Excel Spreadsheets: Part Three
· Excel in the Home Office
· Microsoft Excel Training: Essential for Today's Employees

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips