excel courses london - Linking Workbooks

FORMULA BASED

1. Make the cell you want the result to appear in active.
2. Enter "=" to start the formula
3. Click the worksheet you want, then select the cell/s you require.
4. Add any operators (,+-*/ that you may require for the formula.
5. Commit the formula by hitting ENTER.


SINGLE CELL

1. Make the cell you want the result to appear in active.
2. Enter "=" to start the formula
3. Click the worksheet you want, then select the cell you require.
4. Commit the formula by hitting ENTER.