excel training course - Charts and budgets

Resolved · Low Priority · Version Standard

Thu 20 Sep 2007, 09:55 Delegate Katie said...

Katie has attended:
Excel Intermediate course

Charts and budgets

How do I add 2 numbers in different cells

Tue 25 Sep 2007, 11:50 Trainer Anthony said...

RE: charts and budgets

Hi Katie. To add the value in cell A1 to the value in cell A2, add the formula "=A1+A2" to cell A3. Alternatively, using the inbuilt "SUM" function.

Hope this helps.

Anthony

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips

Application Training

Training ProgramsProfessional & Management Development

eLearning Solutions

Our Promotions

Our Schedule

Course Formats

Our Clients

excel training course - Charts and budgets

Charts and budgets

RE: charts and budgets

Excel articles

Excel tip:

Bracketed negative numbers

Training Programs
Professional & Management Development