Course description
The course aims to take your skills in VBA in Excel to the next level.
Applications covered include:
- Learn programming constructs in more depth ;
- Use Excel range objects to dynamically find ranges for reports;
- Use the Excel object model beyond workbooks, worksheets and ranges;
- Create simple applications using multiple subroutines and functions;
- Automate processes such as the creation of charts and pivot tables;
- Use VBA libraries in a simple way to interact with Access, Outlook, PowerPoint and Word.
Software version: Office 2019
The course will expand on your existing knowledge of VBA by introducing a wider range of objects to help you build more complex and robust VBA procedures and functions.
This course is ideal if you have some basic knowledge of VBA and good knowledge of Excel.
Course delivery details
Assessment and certificates
You will be awarded an official City, University of London certificate if you attend over 70 per cent of the classes. The course is not formally accredited.
Assessment
There is no formal assessment as part of this short course.
Request info
City, University of London
City, University of London is a special place. With skill and dedication, we have been using education, research and enterprise to transform the lives of our students, our community and the world for a hundred years. We are proud of...