microsoft excel courses - Formulas

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

Resolved · Low Priority · Version Standard

Formulas

Carol has attended:
Excel Introduction course

by - delegate Carol [2 posts] (2007 Feb 28 Wed, 10:06) Reply

How do you do a basic formula

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: formulas

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 28 Wed, 15:17) Reply

If you press = in a cell it shows the computer you are ready to enter a formula, from then you can enter a cell reference for example A1 and then an operator, like + (options you have are + - / * ) then another cell reference.

So you could type = A1+B1 which would add up the number in A1 to the number in B1.

Hope this helps

Tracy

· Tools From Advanced Excel Courses: Goal Seek and Solver
· How to Create Better Excel Spreadsheets: Part Three
· What's Better Than the Help Function in Excel? Microsoft Training
· Reasons Why VBA for Excel Training Fails
· Take the Anxiety out of Domestic Finances with Microsoft Excel

Excel tip:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

View all Excel hints and tips