Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel training course - Charts and budgets

Resolved · Low Priority · Version Standard

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

Katie has attended:
Excel Intermediate course

Charts and budgets

How do I add 2 numbers in different cells

For upcoming training course dates see: Pricing & availability

Reply Tue 25 Sep 2007, 11:50Trainer 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

Excel articles

· Some Mouse Click Tips In Excel
· Chart Creation Simplified - in 4 Simple Steps
· Don't Get Lost In A Sea Of Data, Use Excel Navigation
· The Secret Formula To Creating Correct Calculations In Excel
· Charting Another Dimension With Excel

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips