7 Reasons Why you Should use Excel Tables

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