Advanced Excel 2019: Tables in Excel (Microsoft Excel Tutorial)

✅ If you are new to Excel, get a FREE 2.4 hour Excel 2019 Beginners course here 👉

In this Microsoft Excel 2019 tutorial, your expert Excel author looks at how Tables in Excel work. Excel Tables are hugely advantageous in a number of ways. In this video, we look at creating Tables in Excel from existing ranges of data and then look at Table functionality including Totalling and Subtotal in Excel.

If you’re looking to learn Microsoft Excel, have an interest in spreadsheets, formulas and learning tips and tricks in MS Excel then this Excel 2019 or Excel 365 video tutorial is for you.

✅To see more videos in this series take a look at the following playlist:

Check out our Excel 2021 tutorials for beginners playlist here

Check out our FREE 300+ hour training course playlist here ➡️

💻Watch more popular tutorials from Simon Sez IT:

✅Microsoft Office 2021 and Office 365 Training Tutorials playlist

✅Microsoft Office 2019 Training Tutorials for Beginners playlist

💬Stay in touch!

🔔Subscribe to our channel:

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)

[michaelroberts]

Great conversation about tables. Thanks!

[complx]

I have a question. I’m utilizing a table with small row heights. In one of my columns, I either post nothing (N/A) or 4 different items. These items are separated by ALT ENTER. However when you click out, you can only see the top area. I have small row heights and would like to keep it that way because not all rows will have the 4 items listed. Any way I can make only the boxes with 4 items bigger? (Changing row heights for those don’t work since filtering does re-change the heights)

[sbhatwa]

How do I change the colour of my table I don't like any of their colours?