Microsoft Excel XP/X (2002)

Documentation is also available for Excel 2003

Excel XP FAQ

Working with Excel

• Getting Started with Excel
• The Office XP Environment
• Pointer Shapes
• Toolbars and Buttons ( Excel XP, Excel X )
• Worksheet Terms
• Formatting Your Worksheets
• Editing Cell Contents
• Calculating with Excel
• Calculating with Functions
• Enhancing Your Worksheets
• Importing External Data

Printing with Excel

• Printing Basics
• Printing FAQs
• Using Printing Options
• About the Page Setup Dialog Box
• Customizing Page Layout
• Modifying Header and Footer Information
• Other Printing Options
• Using Print Preview

Special Features

• Working with Comments
• Using the Fill Command
• Using the Paste Special Feature
• Using the Find & Replace Features
• Hiding Columns, Rows, and Cells
• Splitting Cell Data

Working with the Database Feature

• Database Basics
• Establishing Criteria
• Filtering Your Database
• Using the Sort Command
• Analyzing Your Database with Functions
• Working with Range Names
• Calculating Subtotals in Databases

Managing Your Excel Worksheet

• Worksheet Basics
• Organizing Worksheets
• Working with Groups of Worksheets
• Working with Range Names
• Navigating Through Your Large Workbook
• Performing Calculations in Your Workbook
• Troubleshooting Formulas
• Protecting Your Worksheet

Charting with Excel

• About Charting
• Guidelines for Charting
• Getting Ready to Chart
• Creating a Basic Chart
• Formatting Your Chart
• Working with Chart Elements
• Using Pie Chart Options
• Charting Extras

Favorite Excel Functions

• Rank
• Countif and Sumif
• Concatenate
• Subtotal
• Inserting Dates and Times

Automating Excel with Macros

Excel Gradebook

• Phase 1: Capturing Student Names
• Phase 2: Cleaning Up the Data for Use
• Phase 3: Entering the Grades
• Phase 4: Calculating Subtotals & Percentages
• Phase 5: Assigning Final Grades
• Phase 6: Submitting Electronic Grades
• Transferring Data into Other Gradebook Software
• Other Helpful Calculations
• Printing Tips
• Adding and Deleting Rows or Columns
• Additional Tips

Inserting Clip Art

• Overview of Clip Art
• Using Clip Art
• Importing Clip Art From the Web
• Importing Clip Art From the Office XP Server

Using Office Online Help