Excel® 2007-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® 2007-Level 1
Fee:	Date / Course#:
$150	Friday 1/15/10	W10G
Time:	Registration:
8:30 a.m.-4:30 p.m.	Click Here for Registration Information
Learning Objectives:
This course teaches the basic functions and features of Excel 2007. After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks.
Course Outline:
Unit 1: Getting started Topic A: Spreadsheet terminology Topic B: Exploring the Excel window Topic C: Getting help Topic D: Navigating workbooks Unit 2: Entering and editing data Topic A: Entering and editing text 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: Absolute and relative references Topic D: Inserting and deleting ranges, rows, and columns Unit 4: Using functions Topic A: Entering functions Topic B: AutoSum Topic C: Other useful functions Unit 5: Formatting worksheets Topic A: Formatting text Topic B: Formatting rows and columns Topic C: Formatting numbers Topic D: Conditional formatting Topic E: Copying formats and 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 worksheets Topic B: Printing large worksheets Topic C: Using multiple worksheets

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

2009 Office of Continuing Education