All About Excel TablesI use Excel Tables in all of the templates you can find on

Excel Tables allow storing information and they also make it easy to retrieve information. However, if you are new to Excel or Excel Tables, there are some unique things you need to know in order to work effectively with Excel Tables. 

In this video, I demonstrate how to enter data and delete data from Excel Tables. I use the Retail Inventory and Sales Manager Excel Template to demonstrate, but the concepts are applicable to all Excel workbooks using Excel tables.

For more information on Excel tables, we have a separate article on 

  1. What is a Table?
  2. Why do we use Tables?
  3. Components of a Table
  4. 3 Basic Data Entry Operations
  5. 5 Essential Tips to avoid mistakes

If you are using Excel templates from, we highly recommend reading this article. 

All About Excel Tables