NewEra Technology Facebook
Microsoft Excel VBA - Course Information
PRINT
SEND TO A FRIEND
Name: Microsoft Excel VBA
Category: Microsoft Office Suite
Length (Days): 2
Course Price (CAD): 590
Description:
Visual Basic for Applications (VBA); Excel.

Upon successful completion of this course, students will be able to:
•Develop a macro
•Format worksheets using macros
•Create an interactive worksheet
•Work with multiple worksheets
•Perform calculations
Prerequisites:
Previous MS Excel knowledge required.

Participants should have basic Windows operating skills (Computers 101 class or equivalent). This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application.
Outline:
Lesson 1: Developing Macros
Topic 1A: Create a Macro Using the Macro Recorder
Topic 1B: Edit a Macro
Topic 1C: Debug a Macro
Topic 1D: Customize the Quick Access Toolbar and Hotkeys
Topic 1E: Set Macro Security

Lesson 2: Formatting Worksheets Using Macros
Topic 2A: Insert Text
Topic 2B: Format Text
Topic 2C: Sort Data
Topic 2D: Duplicate Data
Topic 2E: Generate a Report

Lesson 3: Creating an Interactive Worksheet
Topic 3A: Determine the Dialog Box Type
Topic 3B: Capture User Input

Lesson 4: Working with Multiple Worksheets
Topic 4A: Insert, Copy, and Delete Worksheets
Topic 4B: Rename Worksheets
Topic 4C: Modify the Order of Worksheets
Topic 4D: Print Worksheets

Lesson 5: Performing Calculations
Topic 5A: Create User-Defined Functions
Topic 5B: Automate SUM Functions

The above course outline will be expanded by also providing Programming Methodologies and working on your specific Macro-related projects.
Guaranteed to run courses