Excel Tables -

Excel Tables

Excel Table

An Excel table is a great way to manage database information in a familiar spreadsheet format. There are many benefits of working with tables in Excel to manage data.

  • Tables automatically update when you enter data in a new row or column
  • Excel forms make data entry easy
  • You can add new rows by pressing Tab
  • Column headings are always visible
  • Data analysis benefits
  • Formulas stay consistent across all of your data
  • Graphs will automatically update to include all of your data

Creating a table

It is quick and easy to create a table

    1. Select the cells that your need to include in your table
    2. Place your cursor anywhere in the data
    3. Press Control + T
    4. Tick the box for My Table has headers
    5. Click OK

page17image63605808

Your data will now be displayed in a table

page17image63614752

page17image63482016

TIPS and

TRICKS

page17image52699392

You can create a table by selecting the Insert tab, then the Tables group, then Table

 

Name your table

Excel automatically names your table, such as table1, table2 etc. The table name will display in the Name Box, making it easier to navigate.

1. Select Table Design > Properties > Table Name, type in your table name