- Excel 2010 or later
Maybe because of its' generic name, Excel Table is one of the most underused features of Excel.
As soon as you convert a data set into an Excel Table, it will acquire a set of properties that will make that data easier to handle.
In this Tutorial you will go through the essential things you need to know about the Table feature in Excel.
Different methods to create Excel Table (including VBA)
10 different advantages of using Excel Table
How to use VLOOKUP on Excel Tables
How to create Running Total using Excel Table
How to AutoNumber Rows using Excel Table
How to Connect Excel Tables
Who this course is for:
- Excel Users
- 04:36Different methods to create an Excel Table
I am a Civil Engineer by Education and a Coder by Interest. I was working as a Highway Designer from 2007 to 2018 and was associated with many Highway projects all over India.
I have conducted many workshops on AutoCAD and Excel including the one I did for the UNITED NATIONS ENVIRONMENT PROGRAM (UNEP) at Geneva, Switzerland.
I regularly write articles on Excel and AutoCAD on my website and I am also active in QUORA with more than 700 answers on Topics regarding Excel. I have two YouTube channels for Excel (English and Malayalam) where upload videos regularly.
Considering my contributions to the Excel community, Microsoft presented me with the prestigious MVP Award in April 2020.