Course description
Microsoft Excel VBA Advanced
This 3 day Excel VBA programming course introduces advanced Excel users to the process of writing and editing Macros in Excel, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
Do you work at this organisation and want to update this page?
Is there out-of-date information about your organisation or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Suitability - Who should attend?
Prerequisites
- Internet connection
- Desktop, Laptop, Tablet or Mobile
- Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required.
Target Students
This course will appeal to students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. It may also appeal to students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Outcome / Qualification etc.
Certification
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.
Course Objectives
Upon completion of the course, you will have gained the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations.
Course delivery details
Instructor led, group-paced, classroom style online delivery learning model with structured hands-on activities.
Why choose Infero Training Ltd
97% Recommend Us from 4000 Corporate Clients
100% Money Back Guarantee
Training at 15 locations, Your Office or Live Virtual
Expenses
Course fee: £649.00 + VAT