Everything You Need To Know About Excel Tables

Excel tables are a must know (and use) feature. Tables are the most important way of organizing and storing your data!
Not using tables means you're not organizing your data!
Check out the full written post here:
www.howtoexcel.org/tutorials/everything-you-need-to-know-about-excel-tables/ 👇
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
DOWNLOAD the example workbook here
📖 www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks
📧 www.howtoexcel.org/newsletter/
CONNECT with me on social
Facebook: howtoexcelblog
Twitter: howtoexcelblog
LinkedIn: www.linkedin.com/in/john-macdougall/
Thanks for all your support!

[@Migs3]

Excellent video. Thanks for taking the time to film and edit it and of course for positing it for our benefit. Keep up the good work! -Migs

[@HowToExcelBlog]

No problem, I enjoy making them.

[@MyChannel706]

Excellent explanations. Thank you.

[@laurelsimmons6314]

Agreed. This is an excellent video. Thank you.

[@wayneedmondson1065]

Hi John.. thanks for the great review of tables and their features. Thumbs up!

[@HowToExcelBlog]

Thanks Wayne!

[@minadev1]

Very information, appreciate sir

[@MelwynRodrigues]

Nice tutorial! Keep up the good work

[@CeliaAlvesSolveExcel]

Hi, John! Great timing for this video We'll be talking about tables on our next meetup. I'll share your video with the attendees. Thank you for putting this together. :)

[@zekebeukes7380]

John told me to tell you it's a pleasure

[@mohanvaze1]

Hi John, Thanks a ton for this video. Best regards

[@HowToExcelBlog]

You're welcome 👍

[@mathewchan503]

great introduction

[@minadev1]

Great video

[@allabout1135]

Found some thing new. Thanks!

[@HowToExcelBlog]

There's always something new to discover in Excel! I find new things all the time 😀

[@allabout1135]

@@HowToExcelBlog Like limitless ocean.

[@generalposter4792]

Are tables faster when traversing via VBA to do the normal CRUD (Create, Read, Update, Delete). I get the "use" advantage of tables. But Bottom line question is do tables allow better performance or not if ranges are converted to Tables

[@nghiphan5348]

Hi John, could you please help me with this. Do you know how to format cells at Number in the Header Row of the Table. It means when you input the number to cells in Header Row, they are not the number, you can check by Isnumber() command for that Header row's Cells and it gose False. I need the Header row's cells to show as number so I can use my command directly in this Header Row. Thank you for reading.

[@bondniko]

Much trickier is referring to table from outside

[@SIPRA424]

How can i set the date so i can have a continuous daily tracker?

[@manjeshbanawara7957]

How do you move Table rows?

[@stephenyoung3917]

where is this workbook? It is not in the list?

[@radu0505]

!!!!!!!!!!!!!!!!!!!Need so help plz!!!!!!!!!!!!!!!! I want to create a simple table with numbers from A1:A10. In cell B1 I want to type the number in, and have that number automatically enter in the table in cell A1. Than when i type the second number in cell B1, i want the number from A1 to drop to A2 and have the new number go on top "A1". I want to do this each time i type a new number in cell B1. How can i create this rule????

[@aminbelqassimsiali5369]

thanks for the course but the link u put for the sample so we can follow u aint giving us anything just advertising for ur website !!!

[@WalrusesAreTheOne]

But what if you haven't started filling in all the data, but you know that you want everything in that spreadsheet to be a table?

[@wassollderscheiss33]

Boy, this is boring. The video has no informational value. Everything it explains is totally standard and normal and just applies to everything you do with a computer. Like "if you click here, the thing you clicked gets highlighted". Also he doesn't even try to explain, what the whole point of tables is and why they are relevant. I wonder what the author was thinking. This video has a few thousand views. Maybe he just wanted to rip you off some life time. The video is well produced and narrated, though.

[@HowToExcelBlog]

Ha, oh well 😉

[@trogdorstrngbd]

Boring, slow, or repetitive might've been valid criticisms, but definitely not devoid of informational value. If anything, that you find most of the Table behaviors to be "totally standard and normal" is a compliment to the Excel devs.

[@felixaustin2406]

Where is your KZbin channel, buddy? Perhaps you could link us to a better video on Excel tables?