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

Visual Basic for Applications (VBA) in Excel – Part 2 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?

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

As the Visual Basic for Applications (VBA) in Excel Part 2 short course is a more advanced course, successful completion of Visual Basic for Applications (VBA) in Excel Part 1 is required. Knowledge of subjects therein will also provide you with eligibility for the VBA in Excel Part 2 course.

This practical short 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

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 2016

  • “ The course was fantastic and a rewarding experience. ”

    Eric Cheung

    Former student

  • “ [The tutor] mixes the programming with the underlying object hierarchy, so I now understand both. ”

    David Hollins

    Former student

What will I learn?

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.

Eligibility

Eligibility

Prerequisite knowledge

As the Visual Basic for Applications (VBA) in Excel Part 2 short course is a more advanced course, successful completion of Visual Basic for Applications (VBA) in Excel Part 1 is required.

Knowledge of subjects therein will also provide you with eligibility for the VBA in Excel Part 2 course.

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 3 evening Short Course teaches the customisation features such as classes and Add-ins, database-enabled web publishing and more.…