tabulation

Table with multiple columnar headings/oblique headings

This item must allow for a ruled tabulation with main heading and multiple columnar headings applying oblique or vertical heading; sorting.

how to create and format table in microsoft excel

The image above shows the table to be created.

step by step video on how to create and format table in microsoft excel

Tabulation Video.mp4

This video outlines the steps in creating a table containing merged cells, bold headings, multiple columnar headings, oblique headings, word wrap, table borders, entering numbers and changing them to currency.

NOTE: Formula to calculate Total Per Dept.

=SUM(Cell ranges) OR =SUM(B4:E4) then press Enter

NOTE: Formula to calculate Total Per Annum

=SUM(Cell ranges) OR =SUM(B4:B7) then press Enter

NOTE: Formula to calculate Annual Average

= Total Per Dept. value/number of years OR =F4/4 then press Enter

Page updated

Google Sites

Report abuse