Microsoft Excel - Working with Tables

Working with Tables.

What is a Table.

A table is a series of rows and columns with data you manage separately from other data within the worksheet.

Examples of Tables:

Client contact details, phone list, products list.

Information in a structured fashion, in older versions we knew this as a database or list.

Once the Table has been created there are various tools available to analyze the information.

Guidelines on setting up Table(s).

 •      Enter the headings (field names) in a single row, the first row in the list.

      Common practice is to also make the headings a different font or bold.

•      Enter each record in a single row.

•      Do not leave blank rows within the range of the table.

    The range is the start to the finish point of the Table (A1:G28).

•      Do not use more than one worksheet for a single range.

Creating a Table.

1.     Open the file that contains the information.

Tip: Place your cursor with the data range, for example the first cell, this will save you selecting the range later.