Excel Tables for Beginners

Learn to format your Excel data as a table for a consistent appearance, more readability, and additional functionality. In this course, you will use example sales data and learn fundamental techniques for setting up, formatting, and referencing data within a table. Through this, you will make Excel easier to use in your day-to-day life for data analysis – with benefits such as automatic pane freezes and advanced filter abilities.

You will learn how to: 

●     Convert a range to a table and vice versa

●     Set up your own tables styles for different aesthetics

●     Use data within a table in any compatible Excel formulas

●     Filter data more efficiently using slicers