Excel Tables

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

Requirements

  • Excel 2010 or later

Description

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
    01:44
  • Different methods to create an Excel Table
    04:36

Instructor

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.