Excel Tables

Excel Tables form the basis for using data effectively and efficiently. A basic understanding of Tables is essential for any Excel user.

Excel Tables have many advantages:

  1. Headers always remain visible as you scroll down: table headers replace column letters when scrolling.

  2. Sorting & filtering data quickly and effectively including the use of Slicers and Advanced filtering.

  3. Automatic updating of data into the table.

  4. Using a Form to enter data.

  5. Adding Themes and Styles.

  6. Tables have their own contextual tab: Table Design which allows for several options e.g. Table Name; Remove Duplicates; Insert Slicer; Table Style Options; Quick Styles.

  7. Formula entered in one cell is automatically entered in entire column and changes when one cell is changed.

  8.  Structured References (use of table and column header names): used to make formula more readable (e.g. =SUM( Sales2[Order Amount]).

The workshop also covers Conditional Formatting and Data Validation which complement Tables.