Excel Intro to VBA Macros

IntroductoryFull Day1 DayVersion 365Official CPE Provider

Build practical, job-ready Excel skills with hands-on, instructor-led training focused on real business tasks.

Course Objective

Excel Macros can be used to automate redundant tasks. In this class you will learn to integrate recorded macros with VBA code. Not only will you be recording macros, but you will also be working with and writing visual basic code. By the end of class, you should find that with some basic VBA techniques, you can make macros do some pretty amazing things. The follow-up course Advanced VBA Macros is also available.

Prerequisites

To ensure your success, we recommend that you have experience with basic macros, intermediate level formulas, charting, and data management tools such as sorting and filtering. Students can obtain this level of skill through our Level 1, 2 and 3 courses. You should also be aware that our VBA classes are somewhat technical in nature since they involve programming. If you have any questions, feel free to contact us to discuss if this level is right for you.

Course Outline

5 lessons · 18 topics

1Lesson 1: Developing Macros

Create a Macro with the Macro Recorder
Edit a Macro
Debug a Macro
Customize Toolbars, Menus, and Hotkeys

2Lesson 2: Formatting Worksheets

Sort Data
Insert Rows and Columns
Insert Text
Format Text
Duplicate Data
Generate a Report

3Lesson 3: Creating an Interactive Worksheet

Determine Dialog Box Type
Capture User Input

4Lesson 4: Working with Multiple Worksheets

Insert, Copy, and Delete Worksheets
Rename Worksheets
Modify the Order of Worksheets
Print Worksheets

5Lesson 5: Performing Calculations

Create User-defined Functions
Automate SUM Functions

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals