Lesson 9 Applying Advanced Worksheet and Chart Options

This lesson concentrates on ways to work with formatting text, numbers, and dates in a workbook. Additionally how to create a custom format, use AutoFormats, and apply conditional formatting to cells. Data is transposed and formulas are copied as values. In addition, changing Excel’s default settings and data validation are reviewed and practiced. Finally, chart formats are explored.

This Lesson will cover the basics:

·     Create a custom format.

·        Use AutoFormats.

·        Apply conditional formats.

·        Use styles and data validation.

·        Transpose data.

·        Enhance the appearance of worksheet charts.

 

·        

Lesson 9 Review Questions

 

PowerPoint Overviews

Advanced worksheet formatting

Lesson 9 Review

 

Top

 Last updated Thursday, March 22, 2007
Copyright © 2005 Amy Sirott  All rights reserved.

Visitor No. Hit Counter