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 each record in a single row.
• Do not leave blank rows within the range of the table.
•
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.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVE5bti3jz94Zw3Ud3fbsmpO1oRWaocAVnLTKrBqbrfK1EL6YNun-M70uqAtbFDTMBL3KjrNiChc__vFe8kz25uykI8t5k_srYRhy6fbldiSE2yEHg5-OqWmdgYzT7MrGA-3w3sQZHHYgA/s400/Screen+Shot+2018-10-29+at+17.12.20.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXxT3mXfM6oUHw9O7U4a6fH3Q7bw0uKhRVBD3Nd2OdtgxMGNFp__EVMGK6CuQRIhkOM4phQrZqPtX9bQEERCWTfcDpvBrc0LEOzdMzuKLso2ojSTZWGDIoB1pmBC6CIjZUO-6-1Fd_yJX-/s640/Screen+Shot+2018-10-29+at+17.12.48.png)
No comments:
Post a Comment