Excel Tables Tutorial #1 How to Create and Use Excel Tables 2013 2010 2007 365

[@Subjectmoney]

If my free tutorials have helped you in any way please repay by liking, commenting, sharing and saving the videos to your favorites. Your interaction improves the search ranking of my tutorials which motivates me to keep making more. Thanks for the support!

[@tortellini545]

Thank you for being so generous with your knowledge! I am happy with my table!

[@akedustudio4517]

Excellent video! Well done.

[@lickaroosky]

Excellent teaching - clear, logical and thorough

[@eatenalive85]

Thank you so much for this tutorial! I didn't know how to make tables in Excel until after I watched your video. You made it very easy to understand and learn. I appreciate it!

[@sophiadepp4828]

Thank you so much you're a life saver !

[@jackli7067]

Thank you learned

[@age_of_reason]

To select all the data in your table just use CTRL + * on your keypad or CTRL+SHIFT+ * on keyboard.

[@wisdomworldtiger9227]

excellent video!

[@juflores3605]

Excellent,right to the bottom

[@SuperMarquiD]

I know this was a while ago, but for future reference (if you haven't started doing this already) You could export the file after entering data, before you start the tutorial and upload it to a file sharing service. You could then put the link in the video description, and mention reference file link in the video before you get started.

[@xuseenyuusuf1670]

thank you teacher

[@emilym1518]

Easy to understand. Thanks.

[@ganapatihegde1024]

Excellent vidoe, lucid explanation. Thanks! for the upload !

[@neveradullmoment6]

at 3:56 when you discussed that the column headers replace the column letters, is that automatic or do you have to add that feature?

[@donnacroxford6242]

Very helpful! Thank you!

[@tycrestfallen6621]

Great video! Thanks a lot!

[@grcutts]

Awesome! Thank you!!

[@tilanjayaweera5087]

Really helpful.Thank you

[@Claditzio416]

very good tutorial. thanks bud!

[@syedsafwaan5162]

Well Teaching Master... !!!!

[@iwebuyhousespaul7115]

Very cool. Your static table headers vs. freezing panes tip was a home run. I was a SQL hacker in the 90's, comfortable with tables and key fields so this refresher was perfect. I need to build upon a sheet I use to enter real estate property info I need in deciding whether or not to buy, also to sell. As an investor, I have my own formulae I use to filter my prospects. Can you help? Maybe we could collaborate your tutorial of solving my problem once in a while? Thanks!

[@Schmoopies]

How do I select the data values to create a table from different columns? Like for example I need to create a table with the data values from B,C,D,G and I

[@Vamsibl]

how to remove drop down arrow in header can u help me??

[@afsanaazmi3122]

Watching this in 2020

[@danecustance2734]

New to excel some helpful info. Thanks. :)

[@inderpreetsingh5849]

can you please make a video on how to construct a table to find the SA, V and ER of each shape for each side on MS excel 2013

[@johnhines6148]

Need to spend more time on how to use it and less time of fluff like formatting.

[@lwinl3308]

thank you

[@KevBossche]

you should link the data you use in your video man!!

[@timothymugisha5413]

Why doesn't my total row doesn't add up. Instead adds the columns

[@vickieelee1671]

what happened if the table icon is shaded or disabled? did i do something wrong?

[@Geekygirrls2014on]

I know how hard it is to do a good tutorial video, and I applaud you for giving it a good effort. However, having said that, you should check out Doug H channel on youtube, because he has 'nailed it' re these types of tutorials. Anyway you did this 18 months ago so perhaps you've either given up doing tutorials or you got better. Frankly, I just gave up trying to do them, as the few I did SUCK 'BIG TIME'. :) Don't stop making videos though because when one is a beginner it is very helpful to watch several videos on the same subject, to get slightly different perspectives. It 'cements' the learning.

[@greysunshine]

Hello, I need help with a table design I want to create a table for the top 5 clubs in Spain, Germany and England with points, and goals scorex in a season. How can I create a table that displays information for the 15 clubs in the same table/sheet. I also want to do it for a span of 5 years. Is there a way to do it, or do I just create a sheet/table for the top 5 clubsin each country separately? I hope I explined myself clearly.

[@davegoodo3603]

I watched this video expecting to get a more comprehensive view of tables, but this seemed too fixated on Table Styles. I wanted to know how I could do calculations with the table and how to analyse the data. Microsoft must have had the idea in mind to use the analytical value of the data in the table. But I agree with your analysis, it ain't easy doing KZbin videos.

[@SikumFernando]

Usefull 4 me

[@sridharkrishnappanavanerth3388]

how to remove or clear a table ?

[@villaverdebruno]

How can you UNDO a table?

[@nooraiman-wq1kw]

HOW TO MERGE THAT TABLE

[@Subjectmoney]

What part do you want to merge?

[@bothonor8811]

A

[@nicolecxo]

Are you baked? lol