Part 2 of the VBA in Excel course will build on your current knowledge of VBA to explore a wide range of object and programming techniques.
1 starting date
Testimonials
Course overview
The course aims to take your skills in VBA in Excel to the next level.
Applications covered include:
- Importing data into Excel
- Manipulating pivot tables
- Reporting
- Complex data manipulation.
Software version: Office 2019
Who is it for?
This course is ideal if you have some basic knowledge of VBA and good knowledge of Excel.
Find out more about our Computer science and computing at City, University of London courses
Timetable
This practical short course takes the form of a series of weekly classes that can be taken on weekday evenings or Saturday daytime..
Benefits
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.
What will I learn?
- Review: the Excel API, especially range objects; basic programming constructs: variables and variable types, if, for each, input and output in conjunction with type conversion techniques
- Looping structures: review of for-each; while loops; for-next loops
- More programming techniques: using a consistent programming style; Arrays
- Manipulating charts
- Workbooks: opening, saving, File search
- Manipulating pivot tables
- Complex applications: structuring programs using separate macros for separate tasks
- Error-checking and debugging: step into; step over; step out; on error resume; print debug; display alerts
- Workbook and worksheet events in detail
By the end of the course, you will be able to
- Be fully confident in the use of basic programming constructs
- Gain a thorough knowledge of key features of the Excel API: namely concerning ranges, workbooks and worksheets
- Write structured programs which integrate a number of separately defined tasks.
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.
Eligibility
As the Visual Basic for Applications (VBA) in Excel Part 2 short course is a more advanced course, successful completion of Visual Basic for Applications (VBA) in Excel Part 1 is required.
Knowledge of the topics in part 1 will also provide you with eligibility for the VBA in Excel Part 2 course.
English requirements
Applicants must be proficient in written and spoken English.