The Manage Table Styles and Options module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises:

  • Manage Table Styles and Options
  • Filter and Sort a Table

Lab time: It will take approximately 45 minutes to complete this lab.

Exercise 1 - Managing Table Styles and Options

A style is a combination of formats that you apply in a single step. For example, you might have a style that sets the font and size, number format, shading, and borders for a cell. Excel has many built-in-styles, and you can also define your own. Themes define a set of colors, fonts, and effects that go together to make your workbooks look good. You can choose existing themes or customize them.

Exercise 2 - Filter and Sort a Table

When you create a table, the headings in the header row all have small filter arrows next to them.

You can click these arrows to access a whole range of AutoFilter features that enable you to filter the table to show only those rows that meet a criterion.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.