Microsoft Excel 2003 combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Delegates will learn the basics of creating, editing, and saving worksheets.
Are you ready to start your course? Click the START button!
This course is free to access for individual study.
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