Using a step-by-step approach, this highly popular course shows how the Visual Basic for Applications (VBA) programming language can extend the functionality of Excel.
You will learn to write macros to accept user input, read to and write from cells and manipulate data. You will also learn to write custom functions and create user forms. Useful examples of problems and their solutions are provided.
This short course is ideal for those with a good knowledge of MS Excel and would like to add additional functionality. No programming knowledge is required.
City is one of the very few universities in London offering this short course. Work more efficiently and save time by learning these vital VBA skills.
Who is it for?
This course is ideal if you work with Excel and need to manipulate and analyse data.
Find out more about our Computer science and computing at City, University of London courses
VBA Part 1 takes place one evening a week for 10 consecutive weeks.
City Short Courses follow the academic year, delivering courses over three terms. These include:
- Autumn - October
- Spring - January
- Summer - April
- Delivered by an industry professional
- Taught in small groups
- Awarded a City, University of London certificate