Excel 2003 - Introduction to VBA
Overview:
Learn the skills necessary to create complex macros to automate difficult or time consuming tasks in Excel. This course begins with recording complex macros then continues with writing Visual Basic for Applications (VBA) code to extend the macro functionality.
Pre-requisite(s):
Able to use Absolute and Relative references, Autofill, Named Ranges, record a Macro, customize the toolbar
Audience:
Students looking to gain the skills necessary to extend macros beyond what can be achieved by recording a macro.
Length/Cost:
1 Day, $295
Outline:
|
Lesson 1 : Developing Macros
|
|
Create a Macro with the Macro Recorder
Edit a Macro
Debug a Macro
Customize Toolbars, Menus, and Hotkeys
|
|
Lesson 2 : Formatting Worksheets
|
|
Sort Data
Insert Rows and Columns
Insert Text
Format Text
Duplicate Data
Generate a Report
|
|
Lesson 3 : Creating an Interactive Worksheet
|
|
Determine Dialog Box Type
Capture User Input
|
|
Lesson 4 : Working with Multiple Worksheets
|
|
Insert, Copy, and Delete Worksheets
Rename Worksheets
Modify the Order of Worksheets
Print Worksheets
|
|
Lesson 5 : Performing Calculations
|
|
Create User-defined Functions
Automate SUM Functions
|
Schedule:
 = "Guaranteed to Run" |
|
ILT - Instructor-Led Training | MLT - Mentor-Led Training | OC - Online Classroom Learning |
|