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

The Visual Basic for Applications (VBA) in Excel | Part 2 short course builds on Visual Basic for Applications 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 and complex data manipulation.

Software version: Office 2007

Course Information

Start DateStart TimeDurationCostCourse CodeApply
Wednesday 5 October 2011 18:30 - 20:30 10 weekly classes £420.00 CE2565 Apply Now
Wednesday 18 January 2012 18:30 - 20:30 10 weekly classes £420.00 CE2565 Apply Now
Wednesday 25 April 2012 18:30 - 20:30 10 weekly classes £420.00 CE2565 Apply Now

Tutor Info

Dionisis Dimakopoulos graduated from the department of Mechanical Engineering at the Technological Educational Institute at Patras, Greece. He holds an MSc on E-Commerce from the University of Essex and is currently completing his research as a computer scientist at Birkbeck, University of London. His research interests are personalisation of web content, usability, semantic web, artificial intelligence and fuzzy logic.

He has implemented numerous projects in Java throughout his career, including desktop, mobile and web applications. He has also worked as a consultant for a wide range of applications written in VBA for Excel; some examples being applications that combine the power of Java web services with the familiar interface of Excel for engineering or financial applications, or offer interoperability with other Office applications. As vice president of the Java Hellenic User Group, his role is to expand the use of Java among beginners, as an easy to use and learn programming language suitable for current development needs.

Eligibility

Successful completion of Visual Basic for Applications (VBA) in Excel Part 1 or knowledge of subjects therein.

What will I learn?

  • Review:  the Excel API, especially range objects; basic programming constructs: variables and variable types, if, foreach,  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, Filesearch
  • 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: