| Excel 2003 Basic
1.0 Interface Review and Basic Tasks
1.1 Using the Standard Toolbar
1.2 Using the Formatting Toolbar
1.3 Customizing the Toolbar
1.4 Reviewing the Menus
1.5 Managing Workbooks
1.6 Working with Cells
1.7 Saving a File
1.8 Establishing Document Properties
1.9 Customizing Excel Options
1.10 Chapter Review Test
2.0 Managing Data
2.1 Managing Worksheets
2.2 Using the Edit Menu
2.3 Working with Color
2.4 Applying Autoformatting
2.5 Changing the View and Zooming
2.6 Using Page Setup
2.7 Chapter Review Test
3.0 Formatting Basics
3.1 Adding Borders
3.2 Formatting Data
3.3 Duplicating and Formatting Styles
3.4 Naming Data
3.5 Filtering Data
3.6 Aligning and Changing Position
3.7 Chapter Review Test
4.0 Reviewing Calculations and Templates
4.1 Using AutoSum
4.2 Reviewing More Functions
4.3 Including Data from Other Worksheets
4.4 Using Templates
4.5 Chapter Review Test
5.0 Saving and Printing
5.1 Saving Different Versions
5.2 Saving a Workspace
5.3 Maneuvering Between Folders and File Locations
5.4 Setting the Print Area
5.5 Using Print Preview
5.6 Printing a File
5.7 Chapter Review Test
Excel 2003 Advanced
1.0 Working with Formulas
1.1 Using Standard Formulas
1.2 Using Conditional Formulas
1.3 Reviewing Basic Functions
1.4 Including Data from Other Workbooks
1.5 Reviewing Macros
1.6 Using Formula Auditing
1.7 Chapter Review Test
2.0 Advanced Formatting
2.1 Sorting Data
2.2 Hiding Data
2.3 Merging Cells
2.4 Formatting Tabs
2.5 Including Comments
2.6 Using Smart Documents
2.7 Adding Header and Footer Details
2.8 Editing and Proofing Data
2.9 Chapter Review Test
3.0 Managing Data
3.1 Using Pivot Tables
3.2 Searching for Data
3.3 Using Find and Replace
3.4 Importing Data
3.5 Exporting Data
3.6 Working with Multiple Windows
3.7 Using Conditional Formatting
3.8 Collaborating with Other Users
3.9 Protecting Your Data
3.10 Chapter Review Test
4.0 Working with Charts
4.1 Reviewing Types of Charts
4.2 Creating a Chart
4.3 Editing Charts
4.4 Protecting Your Data
4.5 Chapter Review Test
5.0 Working with Images
5.1 Including Images
5.2 Managing Images
5.3 Using Clipart
5.4 Working with Diagrams and Objects
5.5 Including Symbols
5.6 Chapter Review Test |
