Mastering Excel Tables: How to Make and Use Them Like a Pro | Al Chen | Skillshare

Playback Speed

• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x

# Mastering Excel Tables: How to Make and Use Them Like a Pro

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

### 0:55

• --
• Beginner level
• Intermediate level
• All levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

2,425

Students

10

Projects

Unlock the power of Excel TablesĀ for your dashboards, models, and reports!

Excel Tables is a relatively unknown feature within Excel, but mastering it elevates the quality of dashboards, data analysis tasks, and formatting for seamless handoff to colleagues. Join Al as he walks us through how to create Excel Tables, Structured References and beautifully formatted tables.Ā

What you'll learn

• The benefits of Excel TablesĀ
• How to create an Excel Tables from scratchĀ
• How to filter and sort your Excel Table as well as add Calculated Columns
• Different ways to create formulas with Structured References within Excel TablesĀ Ā
• How to use the VLOOKUP formula to look up an Excel Table and incorporate it into your main table of dataĀ
• How to build a dropdown list using Excel TablesĀ
• How to format your Excel Table well for your colleaguesĀ

Whether youāre interested in advancing your skills in Excel Tables or are just getting started, this class will speed up your workflow and enable you to collaborate with ease.Ā You'll be actively using the Excel workbook I created for this class (seeĀ Projects & Resources).

Who is this class for?

Intermediate to advanced data analysts, but all students are encouraged to participate and enjoy.Ā

Prerequisites

This class moves fast.Ā You should have a basic understanding of Excel including:

• Navigating around Excel
• Writing basic formulas (including VLOOKUP)
• Creating basic charts

Some classes to consider taking as a prerequisite:

Software

Iāll be using Mac Excel 2016 for Office 365. You can use any of the following versions of Excel for this class:

• Windows:Ā Excel 2019, Excel 2016, Excel 2013 Ā
• Mac:Ā Excel 2016, Excel 2011

## Meet Your Teacher

### Al Chen

Excel Trainer & Coda Evangelist

Teacher

I have been an Excel power user for 10+ years. I started learning Excel when I was a financial analyst at Google. 50,000+ students have taken my online Excel classes and I have facilitated in-person workshops to over 5,000 MBA students around the the U.S.

I founded KeyCuts, an Excel training and consulting company to Fortune 500 companies. If it isn't clear I'm addicted to Excel, perhaps my podcast about Excel and data analysis (Dear Analyst) will convince you :).

Outside of Excel and spreadsheets, I work full-time at Coda, an all-in-one doc for teams. If you would like to read my full journey with spreadsheets and Coda, check out this blog post.

Feel free connect with me on LinkedIn and ask me any questions about Excel, ... See full profile

## Class Ratings

Expectations Met?
Exceeded!
• 0%
• Yes
• 0%
• Somewhat
• 0%
• Not really
• 0%

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

## Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.