Channel: Teacher's Tech

Category: Education

Tags: tables in excel tutorialexcel tutorialjamie keetteacher's tech tutorialsmicrosoft excelhow to make tables in excelexcelmicrosoft excel tutorialexcel 2016formatting tables in exceltables in excelhow to use slicers in excelbanded rows in excelpivot charts in excelhow to use tables in excel

Description: 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: youtu.be/dV90KPArP5Q More about slicers in this tutorial: youtu.be/c8qePWuYleg More about tables in this tutorial: youtu.be/dV90KPArP5Q More about pivot tables: youtu.be/igSovq_H24A Practice File: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/EQKwmxoi8yJFrrYnyk8KUYUBsQW4XelB_jkA0JwQgbiT3A?e=n8Mu0q