Excel 365 – Using Excel tables

Overview

Explore how to use tables in Excel for Office 365 to manage, analyze, and manipulate data in a range in this 6-clip course that shows you how to convert data ranges to a table by providing give you more control over your data and more tools for manipulating your data. You’ll learn how to create calculated columns to perform automatic calculations, how to quickly clean data with a sweep, and how to turn data into a pivot table. Then you’ll learn how to use the Table Design tab to change the look of your data. This course shows you how to use standard Excel styles, how to create a custom style, and how to set it as your default style. You’ll also learn how to use the Table Design tab to improve clarity through shaded columns and rows, add total calculation to a row to add summaries to data, and show and hide filter buttons. Finally, this course shows you how to use slicers to filter and manipulate data.

Objectives

• convert a range of data into an Excel table and edit the contents
• perform calculations and manipulate the data in an Excel table
• use formatting and styling tools to change the look of the table
• customize settings and table tools
• use slicers to to filter data in an Excel table
• resize and format a slicer