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

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


VBA short course tutor Joe Wilkinson recaps on his experiences, talks about passion and commitment necessary to complete the course and give a boost to your career.

Course Information

Start DateStart TimeDurationCostCourse CodeApply
Wednesday 4 October 2017 18:30 - 20:30 10 weekly classes £560.00 CS2565 Apply Now
Wednesday 17 January 2018 18:30 - 20:30 10 weekly classes £560.00 CS2565 Apply Now
Wednesday 2 May 2018 18:30 - 20:30 10 weekly classes £560.00 CS2565 Apply Now

Tutor Info

Joe Wilkinson graduated from the University of Sheffield with a degree in Economics. He is now a senior director at one of the world's leading research and insight consultancies, measuring the effectiveness of marketing-related activities for numerous household brands. An enthusiastic learner, Joe has acquired a broad range of programming skills and languages, including: Python, C#, Javascript and VBA allowing him to automate data processing tasks, speed up business processes and visualise complicated data sets.

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: