Excel® 2003-Level 1

CEd Home Buckeye Link Campus Map Find People Webmail

CEd

Mount Hall | 1050 Carmack Road | Columbus, OH 43210-1002 | (614) 292-8860

CEd Programs Credit Programs Credit Online Courses Noncredit On-campus Courses Noncredit Online Courses Academic Advising Accelerated CFP® Bridge Certified Manager Program Military Nonprofit Leadership Program Program 60 Contact CEd

Corporate Training

University Collaboration

Information for Businesses Distance Learning Facility Contact CEd

Information for Faculty and Staff Conference Management Distance Learning Facility Contact CEd

Buckeye Link Master Schedule of Classes Tips for Adult Students Academic Advising Career Exploration Office CEd Office Hours Class Registration

Directions and Campus Map Financial Aid Information Military Engaged Campuses Contact CEd

Credit Courses Noncredit Courses Noncredit Online Courses

CEd Programs CEd Staff Mission & Vision Statements CEd In The News Contact CEd

On-campus Courses

Business and
Communication
Courses

Computer Courses

Language and
Culture Courses

Noncredit On-Campus Courses

Excel® 2003-Level 1
Fee:	Date / Course#:
$150	Friday 2/19/10	W10H
Time:	Registration:
8:30 a.m.-4:30 p.m.	Click Here for Registration Information
Learning 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. 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

The Ohio State University | CEd Home Page
Site Map | Contact Webmaster

2009 Office of Continuing Education