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.
See the full benefits of our immersive learning experience with interactive courses and guided career paths.