spacer
On-campus Noncredit Courses Certified Financial Planning Career Exploration Office Contact CEd Ohio State Links Register for CEd Programs Program 60 Online Noncredit Courses On-campus Noncredit Courses Contractual Outreach Conference Management Certified Manager Program Calendar of Events Bridge Program Information Academic Advising About CEd Academic Advising Bridge Program Information Calendar of Events Career Exploration Office Certified Financial Planning Certified Manager Program Certified Financial Planning Conference Management Contractual Outreach On-campus Noncredit Courses On-campus Noncredit Courses On-campus Noncredit Courses Online Noncredit Courses Program 60 Register for CEd Programs Contact CEd Ohio State Links
CEd Home Page
About Us
Academic Advising
Alumni
Bridge Program
Calendar of Events
Career Exploration Office
CFP® Program
CFP® Program
Conference Management Services
Contractual Outreach
Directions to CEd
Distance Learning Facility
Distance Learning Facility
On-campus Noncredit Courses
Online Noncredit Courses
Program 60
Register for CEd Programs
Mail CEd
Ohio State Links
spacer spacer
Computer Classes
Excel 2003-Level 1

Fee:

Date / Course#:

$145

 Wednesday 4/2/08
Friday 4/4/08
Monday 4/7/08
Monday 4/14/08
Wednesday 6/18/08
Friday 6/20/08
Monday 6/23/08
Monday 6/30/08		 S18G
S18G1
S18G2
S18G9
U19G
U19G1
U19G2
U19G9
Time: Registration: 
8:30 a.m.-4:30 p.m.
 Click Here for Registration Information
Learning Objectives:
bullet Start Microsoft Excel, identify the main components of the Excel window and an Excel workbook, and use the Help feature.
bullet Enter and edit labels, values, and formulas in a worksheet, and find and replace a formula.
bullet Move and copy data, insert and delete ranges, and work with relative and absolute references when creating and copying formulas.
bullet Use functions such as SUM, AVERAGE, MIN, and MAX to perform calculations in a worksheet, and use the AutoSum feature.
bullet Preview and control Page Setup options for a worksheet, print a worksheet, and set and clear a print area.
bullet Create, format, modify, and print charts based on worksheet data.
bullet Save a worksheet as a Web page, use the AutoRepublish feature, insert and edit hyperlinks in worksheets, and send a workbook via e-mail.
Course Outline :

Unit 1: Getting started
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: Using Format Painter and AutoFormat

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: Web features
Topic A: Saving workbooks as Web pages
Topic B: Hyperlinks
Topic C: Sending workbooks via e-mail

Appendix A: Instant messaging
Topic A: Instant messages

Appendix B: Alternative user input
Topic A: Speech recognition
Topic B: Handwriting recognition