Excel Tables

Over the next few articles we will explore the usage of Excel tables which are a powerful feature of Excel.

We will look at when to use them and when not to use them, the advantages over using plain tables - simple ranges - and a few of disadvantages of using them.

We will also go through a practical example of building a spreadsheet to manage your current account, which will highlight many key points of using Excel tables.

See:

• Part 1: Introduction.
• Part 2: Creating an Excel Table.
• Part 3: Structured references.
• Part 4: Totals.
• Part 5: Running totals.
• Part 6: Preserving entry order.