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