Studyportals
Certificate Online

Visual Basic for Applications (VBA) in Excel City St George's, University of London

Highlights
Tuition fee
595 GBP / full
595 GBP / full
Unknown
Tuition fee
595 GBP / full
595 GBP / full
Unknown
Duration
2 months
Duration
2 months
Apply date
Unknown
Unknown
Apply date
Unknown
Unknown
Start date
Unknown
Unknown
Start date
Unknown
Unknown
Taught in
English
Taught in
English

About

The Visual Basic for Applications (VBA) in Excel course offered by City St George's, University of London will help you learn to automate Excel so that even very complex functions can be achieved quickly and simply.

Overview

What you will study

  • Using a step-by-step approach, this Visual Basic for Applications (VBA) in Excel course offered by City St George's, University of London 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.

Programme Structure

The program focuses on:

  • 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
  • User forms and dialog boxes
  • Error-handling and debugging
  • Workbook and Worksheet events

Key information

Duration

  • Part-time
    • 2 months

Start dates & application deadlines

We did our best, but couldn't find the next application deadline and start date information online.

Language

English

Delivered

Online

Campus Location

  • London, United Kingdom

What students do after studying

Join for free or log in to access our complete career info list.

Academic requirements

We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.

English requirements

We are not aware of any English requirements for this programme.

Other requirements

General requirements

  • You should have a strong working knowledge of MS Excel to enrol on this course.
  • No programming knowledge is required.
  • Applicants must be proficient in written and spoken English.

Tuition Fees

Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.
  • International

    Non-residents
    595 GBP / full
    595 GBP / full
  • Domestic

    Citizens or residents
    595 GBP / full
    595 GBP / full

Funding

Other interesting programmes for you

Our partners

Visual Basic for Applications (VBA) in Excel
City St George's, University of London
Visual Basic for Applications (VBA) in Excel
-
City St George's, University of London

Wishlist

Go to your profile page to get personalised recommendations!