Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

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

via Skillshare

Overview

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

Syllabus

  • Introduction
  • The Benefits of Excel Tables
  • Creating an Excel Table
  • Filtering and Sorting an Excel Table
  • Formulas within Structured References
  • VLOOKUP and Structured References
  • Dropdown Lists and Data Validation
  • Formatting Excel Tables
  • Final Thoughts

Taught by

Al Chen

Reviews

Start your review of Mastering Excel Tables: How to Make and Use Them Like a Pro

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.