Search notes:

Excel tables

Excel tables were previously known as Excel lists. (This is probably why they're corresponding VBA object is a ListObject).
Excel tables cannot be inserted into a shared workbook.
Excel tables should not be confused with data tables. Data tables is a concept that belongs to what-if-analysis tools.
The keyboard shortcut to create an Excel table is ctrl+t. ctrl+shift+t adds a total column to a table.
An Excel table has banded rows if rows have alternating background-colors.

Parts of an Excel table

Header row allows to filter for particular row (think SQL: WHERE clause[SQL where clause).
Calculated columns Values in a column are calculated with a formula (TODO: @ symbol)
Total row At the bottom of the table (always?). Calculates an aggregate function such as sum, average etc.
Sizing handle at the bottom right corner of the table, allows to resize the table.

TODO

Structured references
Data validation rules
Excel tables can be exported to a Sharepoint site. 
application.commandBars.executeMso "DataFormExcel"
activeSheet.showDataForm

See also

In Excel's Object Model, an Excel table is represented by a ListObject (which «belongs» to a worksheet).
Creating a data table with Visual Basic for Applications.
rows() and columns() can be used to count the rows and columns in an Excel table.
This example tries to demonstrate how a CSV file can be imported into an with Visual Basic for Application.
Excel tables are found under the Menu Data -> Get & Transform Data -> Existing Connections (tab Tables).

Index