Microsoft Excel 2003
Documentation is also available for Excel 2007
Working with Excel
- Getting Started with Excel
- The Office 2003 Environment
- Pointer Shapes
- Worksheet Terms
- Formatting Your Worksheets
- Editing Cell Contents
- Calculating with Functions
- Working with Rows and Columns
- Importing an External Data File
Printing with Excel
- Printing Basics
- Using Printing Options
- About the Page Setup Dialog Box (
Windows, Macintosh) - 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 and 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
- Organizing Worksheets
- Working with Groups of Worksheets
- Working with Range Names
- Navigating Through Your Large Workbook
- Performing Calculations in Your Workbook
- Correcting Circular References
- 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
- Creating Exploding Pie Charts
- Charting Extras
Favorite Excel Functions
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 Grades
- Phase 6: Submitting Electronic Grades
- Transferring Data into Other Gradebook Software
- Other Helpful Calculations
- Creating a Weighted Gradebook
- Printing Tips
- Adding and Deleting Rows or Columns
- Additional Tips
Inserting Clip Art
