Excel Tables for Beginners

Improve data presentation in Excel by exploring tables!

Tables are a universal way to represent many forms of data. Not only are they easy to read for people across the world, but create a consistent appearance that helps polish the data’s appearance. As such, tables are a key skill for any Excel user’s toolbelt.

Using example sales data, you’ll learn fundamental techniques for setting up, formatting, and referencing data in a table. You’ll also get to explore how tables in Excel add additional functionality that makes manipulating data through features such as sorting much easier.

Whether for your professional or personal life, tables will make data reporting and data analysis with Excel that much easier and much more user-friendly.

This course assumes basic familiarity with Excel and formulas.

You will learn how to:

  • Understand why we use tables
  • Convert a range to a table
  • Format a table back into a range
  • Set up your own tables styles
  • Use table data with Excel formulas
  • Filter data using slicers

A basic working knowledge of Excel and formulas.

Tools and Frameworks

Microsoft Excel 2019

Buy Now For $50

OR access ALL Zenva courses with our subscription.

  • Access all 300+ courses
  • New courses added monthly
  • Cancel anytime
  • Certificates of completion

Subscribe

LUNAR NEW YEAR SALE - Get 60% off the annual plan! Claim Offer
+
Don't miss out! Offer ends in