Visual Basic for Applications (VBA) in Excel, Building Applications | Part 3

Short course

In Islington

Price on request

Description

  • Type

    Short course

  • Location

    Islington

For students who have successfully completed “Visual Basic for Applications in Excel, Part 2” or have equivalent knowledge, Part 3, Building Applications, includes customisation features such as classes and Add-ins, database-enabled web publishing, integrating Excel VBA with functionality from other applications and Ribbon adaptation. In the process, students write complex, structured programs leading up to a large-scale working application. Course Information Start DateStart TimeDurationCostCourse CodeApply Monday 8 May 2017 18:30 - 20:30 10 weekly classes £540.00 CS2566 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 programming 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, blended learning, semantic web and artificial intelligence.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. Eligibility Successful completion of Visual Basic for Applications (VBA) in Excel Part 2 or knowledge of subjects therein. English Requirements Applicants must be proficient in written and spoken English.

Facilities

Location

Start date

Islington (London)
See map
Northampton Square, EC1V 0HB

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Java
  • Basic
  • Visual Basic training
  • IT
  • Basic IT training
  • Basic IT
  • English
  • Web
  • University
  • Engineering
  • Visual Basic
  • MS Excel

Course programme

What will I learn?
  • Review: the Excel API; loops; control structures; arrays; subroutines and functions
  • Interacting with other applications such as MS Word and MS Access
  • Providing Help documentation for the user of the spreadsheet application
  • Manipulating data in conjunction with databases, using ADO
  • Parsing and publishing data over the Internet
  • Class modules
  • Add-ins
  • Working with XML
  • User Forms

Visual Basic for Applications (VBA) in Excel, Building Applications | Part 3

Price on request