Microsoft Excel 2003

Formatting, Charts & Data Capture

Harness the power of Excel to reveal the meaning of your data, and extend your skills to multiple worksheets with linked data. Spot trends by sorting data; analyze large spreadsheets easily by using AutoFilter; visualize data relationships using and formatting charts; and refine worksheets and text by working with text alignment, rotation, styles, and comments. You’ll learn the ins and outs of Find and Replace, and how to protect your efforts by securing your workbooks.

Course Outline

• Lesson 1: Basics of Sorting Data (4 min. and 15 sec.)
• Lesson 2: Using AutoFilter (6 min. and 39 sec.)
• Lesson 3: Introduction to Charts (6 min. and 18 sec.)
• Lesson 4: Formatting Chart Labels and Title (5 min. and 37 sec.)
• Lesson 5: Use Colors, Labels, Dynamic Titles to Format a Chart (4 min. and 59 sec.)
• Lesson 6: Formatting Worksheets (5 min. and 16 sec.)
• Lesson 7: Text Alignment and Rotation (4 min. and 7 sec.)
• Lesson 8: Creating and Using Styles (6 min. and 19 sec.)
• Lesson 9: Functions: Using Multiple Worksheets and Cell Naming (9 min. and 43 sec.)
• Lesson 10: Find/Replace and Comments (5 min. and 5 sec.)
• Lesson 11: Protecting Workbooks (4 min. and 12 sec.)