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: kzbin.info/www/bejne/moecYX6GdteDa7M
More about slicers in this tutorial: kzbin.info/www/bejne/mWnUloONqr6fm8k
More about tables in this tutorial: kzbin.info/www/bejne/moecYX6GdteDa7M
More about pivot tables: kzbin.info/www/bejne/n5i2oKmnlK1laqM
Practice File: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/EQKwmxoi8yJFrrYnyk8KUYUBsQW4XelB_jkA0JwQgbiT3A?e=n8Mu0q

[@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.

[@TeachersTech]

I appreciate that!

[@MAzam-em3lg]

Lovely. Very precise. No lengthy talks.

[@1hjehje]

That was an excellent video ... Thank you!

[@shahrammottahed4663]

Great video. Clear, concise and comprehensible.

[@TeachersTech]

Thank you!🙏

[@oladejieeny]

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

[@TeachersTech]

You’re welcome! I’m glad to hear the videos are helpful.

[@hanashiro236]

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

[@armanmaulana8404]

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

[@neszi3]

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.

[@HamdanYouTuber]

Thanks alot for for your amazing videos

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@tahanaseem44]

You are great.

[@aloneogist1440]

very usefull 🙏🙂

[@nyusemotech849]

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.

[@TeachersTech]

Thanks, will do!

[@ismailhossen7578]

thanks for sharing your experience with us

[@TeachersTech]

You’re welcome!

[@terefememru541]

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

[@TeachersTech]

Thank you, I will

[@erikaacharya948]

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

[@TeachersTech]

I can look into doing this.

[@oladejieeny]

What about data visualization on excel?

[@xaquison]

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

[@TeachersTech]

Thanks!

[@ananthabhavani1613]

Can u pls make videos on quip sheets??

[@TheKodingGuy]

Thanks

[@TeachersTech]

Welcome

[@reelzerotuned3675]

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

[@MHJ19]

Hi, thanks for the helpful videos, I would like to format a cell so when I hit return it moves the text to a new line within that cell, how do I do that?

[@Taco_Town]

Sorry that I don't know a way to do that exactly, but Alt+Enter accomplishes this!

[@gregchenoweth8963]

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?

[@Allison2010tw]

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.

[@frankmoore1389]

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.

[@lightworker4512]

Lol, this is aimed for newbies

[@angelomachure424]

I can't find the link to the this tablet content