excel training course - charts and budgets

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Charts and budgets

excel training course - Charts and budgets

resolvedResolved · Low Priority · Version Standard

Katie has attended:
Excel Intermediate course

Charts and budgets

How do I add 2 numbers in different cells

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


 

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


Server loaded in 0.08 secs.