×

VBA for Excel

Gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets and perform calculations. Apply this new knowledge in order to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development.

Course Outline/Topics

Lesson 1: Developing Macros

Create a Macro Using the Macro Recorder

Edit a Macro

Debug a Macro

Customize the Quick Access Toolbar and Hotkeys

Set Macro Security

Lesson 2: Formatting Worksheets Using Macros

Insert Text

Format Text

Sort Data

Duplicate Data

Generate a Report

Lesson 3: Creating an Interactive Worksheet

Determine the 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

Prerequisites

Excel 2007/2010 – Level III (or equivalent experience), previous programming background helpful.

This was a very useful class. It taught skills that are important and meaningful to me. The instructor was very well organized, clear and helpful.

— Student, 2014

Excellent and very informative class. Hannah did a great job encouraging feedback and questions, which really helped with learning more above and beyond the course content. Thank you!

— Student, 2014

Thu., Jan. 21, 2016

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Hannah Goodman

Fee: $349

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8429

Registration Deadline: Wed., Jan. 20, 2016

Register Now

Mon., May 9, 2016

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Hannah Goodman

Fee: $349

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8428

Registration Deadline: Sun., May 8, 2016

Register Now

FacebookTwitterGoogle+Share