Excel: Power User

Learning Outcomes:

• With information provided during the Lesson Lab, utilize data about relative and absolute recorded macros, and successfully assign these macros to various objects.

• Given a set of criteria, accurately write procedures that test conditions and then run only certain statements based on the results: If, Then, For..Next, Do.. Loop, If..Then..Else, For Each..Next statements.

• Demonstrate without error, how to execute one or more lines of code repetitively, using loop structures as provided in the exercise and time allotted.

• Correctly analyze code and locate the source of errors according to instructions provided within the Lesson Lab.

In this one day class students will learn an overview of creating and editing macros, and gain an understanding of VBA code.

• Introduction to Visual Basic
• Running and recording a macro
• Assigning macros
• User-defined functions and constants
• Creating decision making code
• Using loop structures
• Interactive macros
• Debugging and testing code
• Macro management
• Personal macro workbook

Excel: Power User

Understand the basics of a Visual Basic Module. Learn about relative and absolute recorded macros, and assign these macros to various objects. Create custom functions. Write procedures that test conditions and then run only certain statements based on the results: If..Then, For..Next, Do..Loop, If..Then..Else, For Each..Next statements. Understand how to execute one or more lines of code repetitively, using loop structures. Create macros that interact with the user. Analyze how your code operates and locate the source of errors. Organize your macros for easy access.

Class targeted to:

The student who has progressed through all levels of Excel and desires to learn the complexity of the Visual Basic Applications code in Excel.

Prerequisites:

Windows: Introduction, Excel Introduction, Intermediate, and Advanced, or equivalent knowledge..