Microsoft Office Tutorials and References
In Depth Information
• 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.