Free

Microsoft Excel Level 4 VBA Training

Event Information

Share this event

Date and Time

Location

Location

125 IT Training Room

Event description

Description

COURSE DESCRIPTION
This course is intended for students with a proficient knowledge of MS Excel who wish to learn how to use the Visual Basic for Applications (VBA) programming language to automate repetitive tasks in
Excel 2010.

Students will write code in challenging exercises that relate to each other around a common business theme.

Upon successful completion of this course, students will be able to:

  • record and run a macro, and edit in the Visual Basic Editor.

  • work with procedures and functions.

  • understand Objects and Collections.

  • use Expressions, Variables, and Intrinsic Functions.

  • control Program Execution.

  • work with Forms and Controls.

  • work with the PivotTable Object.

  • debug Code.

  • understand Error Handling.

Share with friends

Date and Time

Location

125 IT Training Room

Save This Event

Event Saved