Courses
  1. Undergraduate
  2. Postgraduate
  3. Research Degrees
  4. CPD
  5. Short Courses
Courses

Visual Basic for Applications (VBA) in Excel | Part 1 Short Courses

Choose a start date

Key information

Duration:
TBC
Time:
TBC
Fees:
TBC
Course code:
TBC

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?

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. It is ideal for those who work with Excel and need to manipulate and analyse data.

This practical course takes the form of a series of weekly classes that can be taken on weekday evenings or Saturday daytime, all facilitated at our Central London location.

Course overview

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.

  • “ Perfect level and breadth of information ”

    Andrew Johnson

    Former student

  • “ An enjoyable course which helped me gain the skills I signed up for ”

    Lucy Briggs

    Former student

What will I learn?

What will I learn?

  • Recording and running macros
  • Assigning macros to menus, toolbars and buttons
  • The Visual Basic editor
  • Input boxes and Message boxes
  • Object-oriented concepts: objects, properties, methods and events
  • Excel objects
  • Variables and constants
  • If statements
  • Looping
  • Conversion functions
  • User-defined functions
  • User forms and dialog boxes
  • Error-handling and debugging
  • Workbook and Worksheet events

By the end of the course, you will be able to:

  • Record and run macros
  • Use the Visual Basic environment to edit programs
  • Write Visual Basic code, using variables, loops and if statements
  • Understand Excel VBA functions and write their own functions
  • Understand and apply object-oriented concepts
  • Be acquainted with the most important Excel VBA objects and properties
  • Understand events in Excel
  • Debug (i.e. correct) errors.

Eligibility

Eligibility

Prerequisite knowledge

Strong knowledge of MS Excel, otherwise delegates are having to learn Excel as well as VBA. Delegates should be able to:

  • Comfortably use separate worksheets
  • Add/delete columns and rows
  • Basic formatting of spreadsheets.
  • Use formulas and basic functions including IF() and ideally VLookup() and or CountIf()

Our Applied MS Excel for Business is a good grounding for this.

English requirements

You must have proficient written and spoken English.

Teaching & assessment

Teaching & assessment

Informal assessment will take place through group discussion, class room activities, and questions and answers sessions as guided by your tutor.

Short course.

Small commitment.

Big Reward.

Book Now

Tutor information

  • Sean Walsh

    Sean Walsh has over 10 years’ experience of Excel and VBA.  He was a member of the Support, Training and Documentation team within City’s IT department and has an MSc in Computing Science from Birkbeck.

    Sean has taught other evening classes for City such as Oracle and SQL, XML, Excel and MS Office. He has also managed an academic programme within City, University of London’s Continuing Education department.

Short course.

Small commitment.

Big Reward.

Book Now

Next steps

This Visual Basic for Applications (VBA) in Excel Part 2 evening Short Course further develops your VBA programming knowledge with the introduction of a wider range of objects.…