Working with Excel Tables

Explore how to use tables in Excel for Office 365 to manage, analyze, and manipulate data in a range, in this 6-video course, which demonstrates how to convert data ranges into a table, giving you greater control over data, and provides more tools for manipulating the data. You will learn how to create calculated columns to perform automated calculations, quickly clean up your data with a sweep, and transform your data into a PivotTable. Next, learn how to use the Table Design tab to change the appearance of your data. This course demonstrates how to use Excel’s standard styles, how to create a custom style, and set it as the default. You will also learn how to use the Table Design tab to improve legibility with banded columns and rows, add total row calculations to add summaries to your data, and show or hide the filter buttons. Finally, this course demonstrates how to use slicers to filter and manipulate data.