ms excel training london - Budget

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

Resolved · Low Priority · Version Standard

Budget

Colette has attended:
Excel Introduction course

by - delegate Colette [1 post] (2007 Feb 26 Mon, 09:31) Reply

hiw can you create a sum for budgets to accuratley add up?

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

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

You can use the sum function either by pressing the button on the toolbar or typing =sum(

then highlight the cells you want to add up and press enter. You can check what cells you have added up by clicking into the folmula and pressing the function key F2.

Good luck

Tracy

· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· What's Better Than the Help Function in Excel? Microsoft Training
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)

In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips