Excel Tables make it easier to work with data. They have some great formula referencing. This video post will share with you tips and tricks on how to create a table and format a table. I also reference tables in formulas as well as demonstrate how to use the total row feature.
Download my Excel Tables.xlsx workbook I used in my video example.