excel training in london - Formulas

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

Resolved · Low Priority · Version Standard

Formulas

Terrie has attended:
Excel Intermediate course

by - delegate Terrie [1 post] (2007 Feb 15 Thu, 09:53) Reply

how do I create a formula, to add and subract using the same column of figures

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Formulas

by - trainer Garry gold contributer [188 posts] (2007 Feb 15 Thu, 13:22) Reply

example
=(B3+B4)-B7
remember your brackets

· How to Create Better Excel Spreadsheets: Part Three
· How to Create Better Excel Spreadsheets: Part Two
· Crazy Things People Have Done With Excel
· Microsoft Excel Training: Essential for Today's Employees
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips