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:
-
Headers always remain visible as you scroll down: table headers replace column letters when scrolling.
-
Sorting & filtering data quickly and effectively including the use of Slicers and Advanced filtering.
-
Automatic updating of data into the table.
-
Using a Form to enter data.
-
Adding Themes and Styles.
-
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.
-
Formula entered in one cell is automatically entered in entire column and changes when one cell is changed.
-
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.