AutoFormat & Styles (2003 only)

AutoFormat a Spreadsheet

Using Styles to Speed Repetitive Formatting

Creating and Editing Styles

Format as Table  (2007 only)

Using The Design Tab

Design Your Own Table Style

Creating and Editing Cell Styles

Using Cell Styles in Other Workbooks

Customizing Toolbars (2003 only)

Choosing Different Toolbars

Creating Custom Toolbars

Changing Toolbar Display

Passwords

Protecting Sheets

Protecting Workbooks

Unprotecting Specific Cells

Password Protect Files

Data Validation

Setting the Validation Rules

Setting the Allowable Values

Choosing from a List

Input Message

Error Alert

Conditional Formatting (2003 only)
Conditional Formats Based on Values
Conditional Formats based on Formulas
 
Conditional Formatting (2007 only)
Highlight Cell Rules
Top/Bottom Rules
Data bars, Color Scales, Icon Sets
Manage Rules
Stop if True
Clearing Rules
 
Charts (Graphs)
Creating and Editing
Formatting Items in a Chart
Changing Chart Types
Naming Charts
Printing Charts
Unlinking Charts From Data
 

Drawing Tools

Lines, Arrows, Freehand

Boxes, Circles, Arcs

Text Boxes

Group, Ungroup, Order

Colours and Shadows

Moving, Sizing, Formatting Objects

Add Pictures and Clip Art (2007 only)

SmartArt Graphics (2007 only)

Lines, Arrows, Freehand

Boxes, Circles, Arcs

Text Boxes

Group, Ungroup, Order

Colours and Shadows