 |
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 ( bullet arrow Windows, bullet arrow 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
* 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 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
* Overview of Clip Art
* Using Clip Art
* Importing Clip Art from the Web
* Importing Clip Art from the Office 2003 Server
Using Microsoft Office Help
|
 |
|
 |