top of page

Using Tables in Excel

The table functionality in Excel provides a great enhancement tool. It has named fields that can be used in formulas and visual basic as well as in pivot tables and charts. Basically in provides database functionality from within Excel, They can be used as a basis for a simple list that can be used in Dynamic Drop Downs to large complex tables consisting of many rows and columns. External data can also be read into Excel directly into a table. Once you are used to creating and using tables there is no turning back.

Creating.png
Creating
Tables Features.png
Features
bottom of page