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:

[JB_inks]

I love your videos because you don't waffle, you don't have a long intro, you just get right into it and you even have a timestamps. Brilliant channel.

[hjehje]

That was an excellent video ... Thank you!

[oladejieeny]

Thanks alot jamie,
You’re videos have solved so many problems

[MonsterDToys]

very useful and straightforward, thanks for sharing your knowledge!!!

[MAzam-emlg]

Lovely. Very precise. No lengthy talks.

[hanashiro]

i really love your videos.. this helped as an aspiring virtual assistant

[erikaacharya]

Can you do more videos on excel based on accountant job requirements?
Your videos are totally helpful. Thanks a lot

[ismailhossen]

thanks for sharing your experience with us

[neszi]

OMG. Thank you. I love this tutorial. I don't often use table because I thought they're redundant. This is very helpful! New subscriber here. Will check out your other videos when I get the time.

[nyusemotech]

Thanks alot for for your amazing videos.They have built my skills alot in data Analysis.

Pleas do more tables on Data Analysis .



Thanks alot and keep the good work ongoing .More blessings from God through Jesus.

[terefememru]

am always following you videos and getting important lessons on Excel. keep doing like this !

[armanmaulana]

Awesome, it's a good tutorial, love it! Thanks!

[xaquison]

Great video. Perfect timing for this video as it was a question I had.

[HamdanYouTuber]

Thanks alot for for your amazing videos

[shahrammottahed]

Great video.
Clear, concise and comprehensible.

[ananthabhavani]

Can u pls make videos on quip sheets??

[frankmoore]

I would just like to add a word of caution. About 2 years ago I developed an estimating app using Excel 2007 and used VBA, all worked fine. When I sent it to the user they had a problem that after they added several lines the computer would lock up and he would have to force a shutdown and boot up again. I could not make it happen until I loaded Excel 365. After searching the internet I came across several posts referencing the same problem. The glitch started around 2010 and Microsoft Excel has not fixed it. I had to change the sheets back to ranges rather than Tables and the code. I have not tried it since but I am sure it has not been fixed. PS I do enjoy your videos and I still use tables as long as I am not going to use VBA.

[reelzerotuned]

Do you have video for dashboard excel? I mean all data summary there.

[gregchenoweth]

What kind of table do I need for tracking my multiple mutual funds. I will want to check balances on multiple dates and calculate the percentage of each funds balance to total?

[Allisontw]

Hi,

In Excel, will you able to hide a cell in a spreadsheet when the file is opened on READ ONLY? For those who have the password to unlock the file, they can see the hidden column straight away; otherwise, the hidden column stays hidden

Thank you.