| Core Services |
| Course Agendas |
| Register/Schedule |
| Cancel/Reschedule |
| Quote Request |
| Assessments |
| Student Resources |
| Classroom Rentals |
| Software Tips |
| Directions |
| Feedback Form |
| Contact Us |
Introduction to Microsoft Office Excel
Macros
and VBA
1 Day
Version 2007 and 2010
This instructor-led course, through lecture and hands-on exploration, will introduce students to the Microsoft Office macro programming environment and show students how to use Visual Basic for Applications to create more complex macros. Microsoft Excel is used as the platform for this course, although the concepts apply across the entire Microsoft Office suite. In order to successfully complete this course, we strongly recommended that students have a strong familiarity with Microsoft Excel prior to taking this course.
Macros Management Recording and Editing Macros Using a Personal Macro Workbook Running Macros Using the Quick Access Understanding Macro Security Setting Considerations and Options Introduction to Visual Basic for Applications Understanding the Visual Basic Editor Examining Module Design Reviewing Excel Objects, Properties, Editing VBA Code Using the Visual Running a Macro From Within Another Learning How to Debug a Macro
|
Using Loop Structures in VBA Code Using a For...Next Statement Using a Do...Loop Statement Declaring and Using Variables in VBA Understanding “With…End With” Syntax Interactive Macros Creating a Custom Message Box Creating a Custom Input Box Working With VBA Decision Making Code The Select Case Decision Structure The If...Then Decision Structure |
Related Courses
Excel - Macro Recording and Programming
Not Sure What Level to Take?
Before taking the Intermediate or Advanced level class for this application, we ask that you take our free assessment to determine whether you are comfortable with the topics covered in the Introductory level class. Or, feel free to contact our office at (202) 747-5000 to speak with a representative to discuss the prerequisites.
Are you interested in a class for one or a few students? Consider taking a public class. View our public training schedule for dates.
Or, are you interested in scheduling a private group class at your office or at Softek? Learn more about our private group training.
©2008 Softek Services, Inc. All Rights Reserved. - 1156 15th Street, NW Suite 100, Washington, DC 20005 - (202) 747-5000