25.8.20
This website uses cookies to ensure you get the best experience on our website. Learn more

Working with Excel Tables

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.

Issued on

May 31, 2021

Expires on

Does not expire