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.

In the video, we cover 9 main reasons for using them. The last 3 are quite special and should definitely be explored further.

Find more great free tutorials at;
https://www.computergaga.com

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1

Видео 9 Reasons You Should be Using Excel Tables канала Computergaga