Search

Part 2 of the VBA in Excel course will build on your current knowledge of VBA to explore a wide range of object and programming techniques.

1 starting date

  • Starting date:

    • Duration: 10 weeks
    • Time: to
    • Fees: £560 (no VAT)
    • Occurs every: Wednesday
    • Location: Online
    • Booking deadline:

Testimonials

  • The course was fantastic and a rewarding experience.

    Eric Cheung

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

    David Hollins

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 2019

Who is it for?

This course is ideal if you have some basic knowledge of VBA and good knowledge of Excel.

Find out more about our Computer science and computing at City, University of London courses

Timetable

This practical short course takes the form of a series of weekly classes that can be taken on weekday evenings or Saturday daytime..

Benefits

The course will expand on your existing knowledge of VBA by introducing a wider range of objects to help you build more complex and robust VBA procedures and functions.

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.

Assessment and certificates

You will be awarded an official City, University of London certificate if you attend over 70 per cent of the classes. The course is not formally accredited.

Assessment

There is no formal assessment as part of this short course.

Eligibility

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 the topics in part 1 will also provide you with eligibility for the VBA in Excel Part 2 course.

English requirements

Applicants must be proficient in written and spoken English.

Tutor

  • 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.

City Short Courses: Why Study at City?

A short course is an excellent way to gain new expertise, advance skills or simply follow a passion. Glimpse inside our short course community.

Have a question?

Related courses