Microsoft Excel Advanced: Macros
Learn how to use Visual Basic macros to automate routine activities. Save time and effort. Improve your consistency and accuracy with repetitive procedures.
-
Sat 25 Nov4 hours, Sat 9:00 AM - Sat 1:00 PM At Selwyn College, Auckland. Jose Entrican
Replacing August course
- $70.00 incl. GST
Description
Learn how to use Visual Basic macros to automate routine activities. Save time and effort. Improve your consistency and accuracy with repetitive procedures.
Key content
- Recording and editing VB code
- Options to run macros including buttons
- Add simple input and alert boxes to make the macros interactive
- Add basic programming structures such as conditional statements and looping
- Create a simple function macro to perform a custom calculation
Objectives
- Learn the fundamentals of visual basic macros within Excel
- Learn to modify these macros where necessary
Who should attend?
You should be a strong Excel user. Classes will be held in a school computer suite running Windows and using Microsoft Excel 2016 (part of Office Professional Plus). Please bring a USB stick with you to class to save your work.
