Microsoft introduced tables with the 2007 release of Excel and, in the course of doing so, likely forever changed how many Excel users should work with data in spreadsheets. Though not yet thoroughly understood by most, tables build upon the list functionality introduced in Excel 2003 and provide superior options for storing, sorting, filtering, querying, and managing volumes of data in Excel. In this chapter, you will learn about the fundamentals of working with tables – one of Excel’s best features.
- List five advantages of working with tables in Excel;
- Identify three approaches to creating tables and utilize each
- Apply names to tables and rename tables when desired;
- Use table styles to format tables and to create new table styles to meet specific formatting objectives
- Convert table data back to an ordinary range of data in Excel.
- Basic Understanding of Excel