Excel Table – One of the most important concepts in Excel [L0004]

If you are expanding your formulas down a column manually all the time and not taking advantage of Excel tables to organize your data, you are missing all the fun in Excel and preventing many exciting doors from opening to you.

--------------------
Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Instagram: @solveandexcel
Twitter: @celia_excel

[kiluaxxx_kynangexecl]

Tôi ở Việt Nam, tôi phải biết kênh của bạn sớm hơn. Có nhiều thứ để học hỏi

[wattjock]

Just found your channel and was scanning through you videos and found this Title...

I have to say, I've been using tables in Excel for years. You can create a Table, rename it e.g.: tblData in the Name Manager, and refer to not only the table but to the columns in VBA... makes for some very readable Code!

Of the many content providers on YouTube, you are the first that I've seen that talks about using Tables, much less using Table/Column names in their VBA Code.

[wayneedmondson]

Hi Celia. Sorry I missed the live event. It was a bit early for me in California (6 AM). Looking forward to watching the recording. Thanks very much for producing your video lessons. I always learn something new and they are very much appreciated :)) Thumbs up!!

[mrmusicloverable]

Hi Cecilia! Do you offer courses on Microsoft Sharepoint as well?

[ganeshtiwari]

how can mam anyone learn excel from a beginner stage