Study at City
  1. Courses
  2. Applying
  3. Fees and funding
  4. Living in London
  5. Visit us & online events
  6. Student support
  7. International students
  8. Order a prospectus
  9. Ask a student
  10. Coronavirus and studying at City
  1. Short courses
  2. Courses
Study at City

Visual Basic for Applications (VBA) in Excel, Building Applications | Part 3 Short Course

Key information

Choose a start date
To be confirmed
To be confirmed
To be confirmed
To be confirmed
Course Code:
To be confirmed
To be confirmed
Booking Deadline:
To be confirmed
To be confirmed
Covid-19 update: The learning doesn’t have to stop, join our online community. We will be delivering courses remotely until further notice. Live tutor support and virtual lessons will take place during advertised teaching hours. The classes are taught in small groups, so you’ll get lots of support from your tutor. Book now.

City is one of the very few universities in London offering this short course, which teaches you how to automate Excel so that even very complex functions can be achieved quickly and simply

Why choose this course?

This advanced short course builds on Visual Basic for Applications (VBA) in Excel Part 2, introducing a wider range of objects and applying previously learnt programming constructs to more complex and robust programmes.

This practical short course takes the form of a series of evening classes taking place once a week in our Central London location.

Course overview

For those who have successfully completed Visual Basic for Applications in Excel, Part 2 or have equivalent knowledge.

Part 3, Building Applications, includes customisation features such as classes and Add-ins, database-enabled web publishing, integrating Excel VBA with functionality from other applications and Ribbon adaptation.

In the process, you will write complex, structured programs leading up to a large-scale working application.

  • “ Extremely professional, comprehensive, value for money course. ”

    Anupama Basu

    Former student

What will I learn?

What will I learn?

  • Review: the Excel API; loops; control structures; arrays; subroutines and functions
  • Interacting with other applications such as MS Word and MS Access
  • Providing Help documentation for the user of the spreadsheet application
  • Manipulating data in conjunction with databases, using ADO
  • Parsing and publishing data over the Internet
  • Class modules
  • Add-ins
  • Working with XML
  • User Forms



Prerequisite knowledge

Successful completion of Visual Basic for Applications (VBA) in Excel Part 2 or knowledge of subjects therein.

English requirements

You must be proficient in written and spoken English.

Tutor information

  • Dionisis Dimakopoulos

    Dionisis Dimakopoulos graduated from the department of Mechanical Engineering at the Technological Educational Institute at Patras, Greece. He holds an MSc in E-Commerce programming from the University of Essex and is currently completing his research as a computer scientist at Birkbeck, University of London. His research interests are personalisation of web content, usability, blended learning, semantic web and artificial intelligence.

    He has implemented numerous projects in Java throughout his career, including desktop, mobile and web applications. He has also worked as a consultant for a wide range of applications written in VBA for Excel; some examples being applications that combine the power of Java web services with the familiar interface of Excel for engineering or financial applications, or offer interoperability with other Office applications.