Working with tables in Excel 365
Tables are a useful tool for quickly managing analyzing and manipulating data as a range in Excel 365. In this course you will discover how you can easily create tables from a data range; insert borders and change the appearance and formatting of a table. You will start by learning how to insert a table and convert a data range into a table. In addition youll learn how to transpose a data range which means inverting the columns and rows. You will see that tables are highly customizable as you learn how to use the formatting tools and styles to change the appearance of a table. Also see how to use the Border tool to make the data in your table stand out more. You will learn how to use slicers to filter and manipulate data in a table; and how to resize and format a slicer tile. Finally you will explore how to add subtotals to your data tables and how to manipulate the table date in other ways. In order to practice what you have learned you will find practice exercises and samples in the Resources section.