Excel® 2007-Level 4

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 4
Requisite: Excel 2007-Level 3 or equivalent experience This course teaches advanced users of Excel more complex formulas, functions, and arrays, and covers more advanced editing and formatting options, such as using the Paste Special command to copy validations and link data. Students will learn about various analysis tools such as Wizards, problem models, and methods for correlating data. Finally, they will learn advanced customization techniques by changing default settings and automating selected features.
Fee:	Date / Course#:
$150	Monday 10/12/09 Friday 2/5/10	F10G4 W10G4
Time:	Registration:
8:30 a.m.-4:30 p.m.	Click Here for Registration Information
Course Outline:
Unit 1 : Advanced formulas, functions, and arrays Topic A: Text functions Topic B: Date and time functions Topic C: Information functions Topic D: Array formulas Unit 2 : Advanced editing and formatting Topic A: The Paste Special command Topic B: The Go To Special dialog box Topic C: Merging styles Topic D: Additional chart formatting Unit 3 : Analyzing and sharing information Topic A: Wizard add-ins Topic B: Solver models and reports Topic C: Statistical analysis tools Topic D: Embedding and linking Unit 4 : Advanced customization Topic A: Popular and Save options Topic B: Formulas options Topic C: Automating Excel Topic D: Advanced options

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

2009 Office of Continuing Education