In this video, I will go over 7 different reasons to use tables in Microsoft Excel. When you turn your data range into an Excel table you are unlocking more properties. Benefit from using tables in Excel.

0:00 Introduction
0:32 Creating a table in Microsoft Excel
2:05 Easy formatting with a table (banded rows, add a total)
3:27 Table headers remain visible even when you scroll down
3:44 Tables automatically create filters for each column
4:50 Tables automatically expand when you add new rows or columns
5:35 Tables automatically name ranges (can be used in formulas)
6:30 You can add totals to tables automatically
7:05 Add slicers to your table
8:05 You can create dynamic charts from Excel tables

Learn more about mentioned excel topics below:
Create forms to enter data in your tables: https://youtu.be/dV90KPArP5Q
More about slicers in this tutorial: https://youtu.be/c8qePWuYleg
More about tables in this tutorial: https://youtu.be/dV90KPArP5Q
More about pivot tables: https://youtu.be/igSovq_H24A

Practice File: https://leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/EQKwmxoi8yJFrrYnyk8KUYUBsQW4XelB_jkA0JwQgbiT3A?e=n8Mu0q