Basic Excel procedures

Open an Excel Spreadsheet

To resize a row column:

Roll the mouse over the top column selector, or row selector to the left of the data
until it becomes a line with arrows either side of it.

Click and drag the cell division to the appropriate place

To delete a row or column:

Click on the unwanted row / column selector

Edit > Delete

Creating new columns:

Select the top cell of the next available column

Start typing the new colunm name

Ensure that the name is of the correct format (font / weight / size) using the text modifiers on the top menu

Entering formulae:

The maths

WORK OUT EXACTLY WHAT YOU WANT TO DO FIRST

ok 2 examples

a) Calculate the VAT (@ 17.5%) on an {item}, where {item} can be any cell =>

={item} * 17.5%

b) Calculate the total price, including VAT @ 17.5% on an {item}, where {item} can be any cell =>

so, total price is 100% of the {item} + {item} * 17.5% (from before)

i) we can say => total price

= {item} + {item} * 17.5%

OR ii) we can say => total price

= {item} * 117.5%

(100% + 17.5% = 117.5%)

Entering the formula

We enter this into the cell, say we need to calculate the price + VAT of cell C2 into cell D2 - We can use the ii)nd formula - it's quicker to enter !

• Select cell D2
• Press the equals key, '='
• Select cell C2 (single click only)
• Type: *117.5%
• Press Return / Enter

Job done!

To copy a relational formula down a column:

Select the cell you wish to copy

Drag the little square at the bottom right hand side of the cell to where you would the copying to end

Jobe done, again...

Back

Back to IT Principles Home