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
-
Starting date:
- Duration: 10 weeks
- Time: to
- Fees: £560 (no VAT)
- Occurs: Thursday
- Location: Online
- Booking deadline:
Want to find out more?
Testimonials
Visual Basic for Applications (VBA) in Excel Part 2 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
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.
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 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.
City Short Courses follow the academic year, delivering courses over three terms. These include:
- Autumn - October
- Spring - January
- Summer - April
Benefits
- Delivered by an industry professional
- Taught in small groups
- Awarded a City, University of London certificate
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
Visual Basic for Applications (VBA) in Excel Part 2 follows on from Visual Basic for Applications (VBA) in Excel Part 1, and delegates should have successfully completed this or have equivalent knowledge.
English requirements
Applicants must have fluent written and spoken English.