9 Reasons You Should be Using Excel Tables

In this video, we demonstrate 9 reasons why you should be using tables in Excel. Master Excel today with this comprehensive course - https://bit.ly/UltimateExcel Here are the timings for this video. 00:00 - Introduction 00:44 - Control the formatting of a table (**see comment below the timings) 02:08 - Convert a range to a table 05:25 - Name the table 06:25 - Headers stay on screen as you scroll 07:40 - Table expands automatically 09:05 - Using Slicers 10.22 - Summarise data with PivotTables 11:53 - Structured References with tables 15:08 - Clean & Transform data with Power Query 17:28 - Create relationships between tables **my apologies for the 'structured references with tables' reason occurring twice in this video. I made a mistake when editing and used this section instead of the intended 'control the formatting of a table' reasons. Click Table Design and change and create your own styles in the table styles gallery. Tables will then take care of the future formatting for you. The ability to format your range as a table has been in Excel for over 10 years. Yet many people that I train have never used them, or are aware of how useful they are.