Visual Basic for Applications (VBA) in Excel – Part 2  Short Courses

Course Information

Start DateStart TimeDurationCostCourse CodeApply
Wednesday 4 October 2017 18:30 - 20:30 10 weekly classes £560.00 CS2565 Enrolment Closed
Wednesday 17 January 2018 18:30 - 20:30 10 weekly classes £560.00 CS2565 Apply Now
Saturday 24 February 2018 10:30 - 16:30
with one hour lunch break
5 weekly classes £560.00 CS2565 Apply Now
Wednesday 2 May 2018 18:30 - 20:30 10 weekly classes £560.00 CS2565 Apply Now

Course Content

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

Applications covered include:

*   Importing data into Excel
*   Manipulating pivot tables
*   Reporting
*   Complex data manipulation.

Software version: Office 2013

Tutor Info

Sean Walsh has over 10 years’ experience of Excel and VBA.  He was a member of the Support, Training and Documentation team within City University University’s IT department and has an MSc in Computing Science from Birkbeck. He has taught other evening classes for City University such as Oracle and SQL, XML, Excel and MS Office. He has also managed an academic programme within City University’s Continuing Education department.

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

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.

Application Deadline: