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 fi 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 fi 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 fi x on a specifi 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.
 
Search JabSto ::




Custom Search