Inserting columns

In order to insert a column Right Click on the top of a column (shown below as G) and a drop down list of options will appear. Click on ‘Insert’ and a new column will be put in.

Figure 1: inserting columns

Calculating age in year, month and days

To calculate the age in years, months or days you must first create those headings for a new column each. Then you have to insert the formulas below into the columns and Excel will calculate the age for you.

Formulas used

For year: DATEDIF(D2,H2,"y")

For month: =DATEDIF(D2,H2,"ym")

For days: =DATEDIF(D2,H,"md")

Splitting viewing screen

To split screen click on the ‘Window’ tab at the top of the screen, then select ‘Split’. You can then left click and hold the split and drag it to the area of the screen you want split. To remove the split, Click on ‘Window’ again and select ‘Remove Split’

Figure 2: splitting screen

Calculating the average of a column

To calculate the average of a column, you must highlight the entire column and then click on arrow next to the E symbol on the top of the screen. Then click ‘Average’ and an average will be calculate and placed in the next cell below the highlighted section.

Adjusting cell size

To adjust the size of a cell you must move your cursor to the point where 2 cells meet on the top. A different cursor type will appear and you must left click and hold while dragging the cell to the new desired size.

Merging cells

To merge cells together you must first highlight/select the cells you want to merge together. Then you must click on the ‘Merge Cell’ icon on your toolbar on the top of the screen.

Charts

Figure 6: creating charts

To create a chart, you must highlight a column, or choose a figure and then click on the ‘Insert tab on the top of the screen. Then click on ‘Chart’ and this image will appear. Select a chart type and click next to continue with the creation of the chart.