CEd Home    Buckeye Link    Campus Map    Find People    Webmail    
CEd
Mount Hall | 1050 Carmack Road | Columbus, OH 43210-1002 | (614) 292-8860    
 

On-campus Courses

Business and
Communication
Courses

Computer Courses

Language and
Culture Courses

Registration

 

spacer

Noncredit On-Campus Courses

a
 

 

 

a
spacer
Computer Classes
Excel® 2007-Level 5

Requisite: Excel 2007-Level 4 or equivalent experience

This course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.

Fee:

Date / Course#:

$150

Friday 2/12/10
W10G5
Time:
Registration: 
8:30 a.m.-4:30 p.m.
Course Outline:

Unit 1: Visual Basic Editor
Topic A: Visual Basic for Applications
Topic B: Object programming
Topic C: The Object Browser

Unit 2: Programming basics
Topic A: Data basics
Topic B: Scope of variables
Topic C: Scope of procedures

Unit 3: Control structures
Topic A: Decision structures
Topic B: Loop structures

Unit 4: Custom dialog boxes
Topic A: User forms
Topic B: Events

Unit 5: Debugging and error handling
Topic A: Errors
Topic B: Debugging
Topic C: Error handling

 

 

a
         

Give Access Feedback and Report Concerns
The Ohio State University | CEd Home Page
Site Map | Contact Webmaster

    2009 Office of Continuing Education