Intro To Excel VBA
Intro To Excel VBA gives insight into Macros, interactive worksheets, and working with multiple worksheets.
Section 1 - Developing Macros
- Creating a Macro Using the Macro Recorder
- Edit a Macro
- Debug a Macro
- Customize the Quick Access Toolbar and Hotkeys
- Set Macro Security
Section 2 - Formatting Worksheets Using Macros
- Insert Text
- Format Text
- Sort Data
- Duplicate Data
- Generate Report
Section 3 - Creating an Interactive Worksheet
- Determine the Dialog Box Type
- Capture User Input
Section 4 - Working with Multiple Worksheet
- Insert, Copy, and Delete Worksheets
- Rename Worksheets
- Modify the Order of Worksheets
- Print Worksheets
Section 5 - Performing Calculations
- Create User-Defined Functions
- Automate SUM Functions
Contact Information
For any additional information, please contact:
Director of Business & Technology
Workforce Development Innovation Center
Email:
Susan Blake
Phone: 828-327-7000
x4330
Office Number: CDC 103
CE Enrollment Manager
Enrollment Management
Email:
Janet Lail
Phone: 828-327-7000
x4116
Office Number: SS 819