| Dates for this class: |
| No dates are available for this class. |
| Course Details [choose new course] [printable version] |
| Excel 2002: Basic |
| Course Number: AP0052 |
| Category: Business & Office Applications |
| Duration: 1.00 day |
Description
This ILT Series course teaches students the fundamentals of using Excel 2002. Students will learn how to enter and edit data, labels, and formulas, work with functions, format cells, print worksheets, create charts, and save a workbook as a Web page. Course activities also cover moving and copying data, inserting ranges, and working with relative and absolute references. This course maps to Microsoft Office Specialist exam objectives.
Outline
- Unit 1: Excel basics
- Topic A: Spreadsheet terminology
- Topic B: Exploring the Excel window
- Topic C: Getting help
- Topic D: Opening and navigating workbooks
- Topic E: Closing workbooks
- Unit 2: Entering and editing data
- Topic A: Creating workbooks
- Topic B: Entering and editing labels and values
- Topic C: Entering and editing formulas
- Topic D: Saving and updating workbooks
- Unit 3: Modifying a worksheet
- Topic A: Moving and copying data
- Topic B: Moving and copying formulas
- Topic C: Using absolute references
- Topic D: Inserting and deleting ranges
- Unit 4: Using functions
- Topic A: Entering functions
- Topic B: Using AutoSum
- Topic C: Using AVERAGE, MIN, and MAX
- Unit 5: Formatting worksheets
- Topic A: Formatting text
- Topic B: Formatting rows and columns
- Topic C: Number formatting
- Topic D: Other formatting features
- Unit 6: Printing
- Topic A: Preparing to print
- Topic B: Page Setup options
- Topic C: Printing
- Unit 7: Creating charts
- Topic A: Chart basics
- Topic B: Modifying charts
- Topic C: Printing charts
- Unit 8: Web features
- Topic A: Saving worksheets as Web pages
- Topic B: Hyperlinks
- Topic C: Workbooks and e-mail
- Appendix AL Alternative user input
- Topic A: Speech recognition
- Topic B: Handwriting recognition
- Appendix B: MOUS exam objectives map
- Topic A: Core exam objectives
- Topic B: Expert exam objectives