2002 excel microsoft training - spreadsheets

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 2002 excel microsoft training - Spreadsheets

2002 excel microsoft training - Spreadsheets

resolvedResolved · Low Priority · Version Standard

Anna has attended:
Excel Introduction course
Excel Intermediate course

Spreadsheets

How do I create a link between spreadsheets

RE: Spreadsheets

By simply adding the relevant cells to the formula.

=A1+Sheet2!B1

This will link cell B1 from Sheet 2 to Cell A1 in the current sheet, and then add the two together.


 

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.09 secs.