Microsoft Office Tutorials and References

In Depth Information

**Summary**

Summary

•
Don’t be afraid to experiment with Excel, and add in new rows and

columns as you need them.

•
Avoid burying important numbers in formulae: put the numbers

into cells so that you can easily see them and change them.

•
Keep one-off values like the exchange rate at the top of the

spreadsheet so they’re easy to ﬁ nd.

•
Use an equals sign to start entering a formula into a cell.

•
Multiplication is represented by * and division is represented by /.

•
Cells using formulae are recalculated immediately when other cells

they depend on are changed.

•
Use formulae to create relationships between cells so you can

minimise the number of formulae you might need to change later.

•
Use the ROUND, ROUNDUP or ROUNDDOWN functions in a

formula if you only want whole numbers in a cell.

•
You can copy a formula into a different row but might encounter

problems if it uses a cell reference from a row other than the row

you’re copying from.

•
To ﬁ x a row or column reference in a formula, put $ before it (eg B$2

for a row and $B2 for a column, or to ﬁ x on a speciﬁ c cell use $B$2).

•
You can use CTRL and drag the bottom right of the cursor to copy.

•
Use SUM to add up a row or column.

•
Use brackets in complex formulae to show

which bits belong together.

•
Use your spreadsheet to experiment and

see what happens if you change certain

costs or assumptions.