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.
UWM-SCE computer lab provides a hands-on learning environment that includes training from an instructor with real-world experience.
Instructor
Hannah Goodman builds custom database applications. She earned her master’s degree in computer science from UWM in 1986. Hannah worked for the Medical College of Wisconsin as a systems analyst, designing databases, writing custom programs and performing statistical analysis. In ... read more
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
Testimonials
"The course is easy to follow and the instructor is knowledgeable. I will definitely be using skills taught during the course in my everyday job – which was the goal of taking the course." — Karen Kroes, Senior Budget Analyst - UW-Milwaukee, 2018
"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!" — Participant, 2014
Dates and locations to be announced.
