Working with Excel Tables in Excel 2019 for Windows

Excel tables are a useful tool for quickly managing analyzing and manipulating data in a range. Once configured as a table you can easily sort filter and perform calculations on your data as well as change its appearance and formatting. Key concepts covered in this 6-video course include how to convert a data range into an table and edit its contents giving you greater control over the inserted information; and how to perform calculations and manipulate data in an table such as create calculated columns to perform automatic calculations on data quickly clean up your data with a sweep and transform your data range into a PivotTable. Learners continue by examining how tables are highly customizable as you learn how to use formatting tools and styles to change the appearance of a table then learn to customize the table settings and tools. Finally you will learn how to use slicers which can be used to filter and manipulate data in a table; and how to resize and format a slicer. In order to practice what you have learned you will find the Word document named Excel 2019 for Windows: Working with Excel Tables Exercise as well as the associated materials in the Resources section.