 |
|
|
"Despite a weak economy, an education-funding crisis, and overall poor consumer confidence our January programs came in
... read more
|
|
|
|
|
|
Back to Class List |
|
|
|
Microsoft Excel 2007 - Beginner |
|
|
Prerequisites:
Introductory Classes - Introduction to Computers
Levels:
Beginner
Intermediate
Advanced
Class length: 1 day
Class Objectives
Start Microsoft Excel, identify the main components of the Excel window and an Excel workbook, and use the Help feature.
Enter and edit labels, values, and formulas in a worksheet, and find and replace a formula.
Move and copy data, insert and delete ranges, and work with relative and absolute references when creating and copying formulas.
Use functions such as SUM, AVERAGE, MIN, and MAX to perform calculations in a worksheet, and use the AutoSum feature.
Preview and control Page Setup options for a worksheet, print a worksheet, and set and clear a print area.
Create, format, modify, and print charts based on worksheet data.
Class Outline
Unit 1: Getting started
Topic A: Spreadsheet terminology
Topic B: Exploring the Excel window
Topic C: Getting help
Topic D: Navigating workbooks
Topic E: Closing workbooks
Unit 2: Entering and editing data
Topic A: Entering and editing labels and values
Topic B: Entering and editing formulas
Topic C: Working with pictures
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, rows and columns
Unit 4: Using functions
Topic A: Entering functions
Topic B: Using AutoSum
Topic C: Other useful functions
Unit 5: Formatting worksheets
Topic A: Formatting text
Topic B: Formatting rows and columns
Topic C: Number formatting
Topic D: Conditional formatting
Topic E: Copying formats adn applying table formats
Unit 6: Printing
Topic A: Preparing to print
Topic B: Page Setup options
Topic C: Printing worksheets
Unit 7: Creating charts
Topic A: Chart basics
Topic B: Modifying charts
Topic C: Printing charts
Unit 8: Managing large workbooks
Topic A: Viewing large workbooks
Topic B: Printing large worksheets
Topic C: Using multiple worksheets
|
|
