Course

MSO-1006 Working with Data Tables

Self-paced

$19 Enroll

Full course description

Course Description

Excel includes commands designed to make it faster and easier to work with data that is arranged in a table. If your data is arranged in a table, you will find the Excel's Table Tools very beneficial.

By the end of this module, you will be able to

• Describe a table

• Insert a table

• Change the table style and the worksheet theme

• Insert a total row and then insert functions

• Describe how to resize the table

• Insert a calculated column

• Sort and filter data

• Remove duplicate records from the table

• Convert a table to a range

Estimated completion time (hours): 1.6