When it comes to the quality and clarity of a workbook, layout and appearance play a major role. Excel puts an extensive array of formatting features at your disposal, letting you create practical worksheets with a professional look and feel. This lesson deals with some of the cell formatting tools that can help you present your data in a polished and meaningful way.

 

In this lesson you will cover conditional formatting, the format painter, and the AutoFormat feature. You will also learn about cell merging, AutoFit, and find and replace formatting.

 

The practice exercise for this lesson is a step by step guide to using conditional formatting.