Visual Basic for Applications (VBA) in Excel Part 2

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

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.

Who is it for?

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

Timetable

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

City Short Courses follow the academic year, delivering courses over three terms. These include:

• Autumn - October
• Spring - January
• Summer - April

Benefits

• Delivered by an industry professional
• Taught in small groups
• Awarded a City, University of London certificate

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

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.

Visual Basic for Applications (VBA) in Excel Part 2 follows on from Visual Basic for Applications (VBA) in Excel Part 1, and delegates should have successfully completed this or have equivalent knowledge.

English requirements

Applicants must have fluent written and spoken English.