Excel Tables

Everything you need to know about Tables in Excel
Rating: 4.5 out of 5 (14 ratings)
1,262 students
English [Auto]
Excel Tables
Rating: 4.6 out of 5 (14 ratings)
1,262 students
How to Create and Use Tables in Excel


  • 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

Course content

4 sections • 8 lectures • 1h 4m total length
  • Intro
  • Different methods to create an Excel Table


Civil Engineer | Microsoft Excel MVP
Ajay Anand
  • 4.3 Instructor Rating
  • 32 Reviews
  • 1,381 Students
  • 5 Courses

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.