Media Room Support Login
Course Overview:
The Formatting, Charts, and Data Capture Excel course will teach you what you need to know in order to produce meaningful graphs and charts from your data using Microsoft Excel. This course covers: data sorting basics, using Auto Filter, charts and chart formatting, using colors, labels, and dynamic titles, worksheet formatting, creating and using styles, advanced functions, find and replace, and how to protect your work.
These courses were produced in Microsoft Excel 2003.
Remember, skills learned in other versions of Microsoft Excel still apply.
See Also: Introduction to Microsoft Excel, Introduction to Microsoft Word, Microsoft Word: Tables, Styles, and Long Document Formatting, Introduction to Microsoft PowerPoint, Acrobat 8, Photoshop CS3: What's New, Soft-Proofing, Digital Photo Editing Basics
 |
$50.00 PC Only |
Course Syllabus: Formatting, Charts, and Data Capture
| 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 Titles (5 min. and 37 sec.) | |
| Lesson 5: | Use Colors, Labels and 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 07 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 05 sec.) | |
| Lesson 11: | Protecting Workbooks (4 min. and 12 sec.) |