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.
The UWM-SCE computer lab provides a hands-on learning environment that includes training from an instructor with real-world experience.
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
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
Modify the Order of Worksheets
Lesson 5: Performing Calculations
Create User-Defined Functions
Automate SUM Functions
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
All sessions are Face-to-Face unless otherwise noted.
Tue., Dec. 6
Location: UWM School of Continuing Education
Instructor: Hannah Goodman
Enrollment Limit: 20
Program Number: 5070-9301
Registration Deadline: Tue., Dec. 6