028 9032 2228
EXCEL VBA
COURSE OBJECTIVES
This 2 day Excel VBA course is suitable for advanced users of Microsoft Excel that:
- Are responsible for very large and variable amounts of data
- Want to learn how to program features and functions to improve the accessibility and usability of their data
- Click here for detailed content
PREREQUISITES
- A high proficiency in Microsoft Excel is essential, or completion of our 2-day Advanced MS Excel course
Microsoft Excel VBA
Reduce manual tasks to the click of a button by leveraging Excel functionality with VBA (MACROS): automate repetitive tasks and create interactive models to analyse, consolidate & report on data.
- Introduction (2 days): Suitable for advanced users who (i) Are responsible for large/ variable amounts of data (ii) Want to learn how to program features to improve the accessibility &usability of their data
- Intermediate (1 day): Covers the use of arrays, control structures, adv error handling, validation
- Advanced (1 day): Looks at 3-D arrays, user forms, performance, etc
- See Course Outlines for detailed content
- Review Dates for our Excel VBA Public Schedule Courses
