Professional Skills & Development

Wake Tech's professional development courses are specifically designed to enhance your resume. These courses give you skills such as how to compose executive reports and organizational procedures; how to communicate between generations and cultures; and more. 

Need help writing your resume or preparing for job interviews?
Explore our skills training for job seekers courses.

Course Details & Registration Information

Course
Excel Programming with VBA
Name
SEF-3001EI2
Available Classes
Not currently offered.
Description Course Outline Requirements Intended Audience More Details
Description
Are you interested in designing innovative user interfaces or developing the ability to automate repetitive tasks in Microsoft Excel recording macros? This course is for you! You’ll learn how to create procedures, including variables, constants, expressions, and objects; and how to work with control structures, develop user forms, and debug code. The course includes hands-on training in a computer lab and textbooks.
Course Objectives
  1. have a working knowledge of Visual Basics and how to use it with Excel.
Outline of Instruction
  1. Introducing Visual Basic for Applications
  2. Working with Procedures and Functions
  3. Understanding Objects
  4. Using Expressions, Variables, and Intrinsic Functions
  5. Controlling Program Execution
  6. Working with Forms and Controls
  7. Working with the PivotTable Object
  8. Debugging Code
  9. Handling Errors
Contact Hours
21
CEU's
2.1
Industry Standard, State, or National Certification
No
CE to CU Articulation
No
Prerequisites
Proficient knowledge of Microsoft Excel. Knowledge of PivotTables
helpful but not required.
Text and Supplies Needed
Textbook is included with registration fee. Please bring a USB/Flash Drive to class.
Clinical Site/Special Facilities
Requirements for Successful Completion of this Course
  1. Attendance 90% or above
  2. Participation
Accreditation/Special Approval Requirements
Intended Audience
Specific Industry or Business Support Needs
Industry or Job Titles Related to training Outcomes for Employment
Related Courses
Course Contact Information
Elizabeth Knocklein
919-866-7209