Call:0207 096 0986 / 0207 097 8757

    Excel VBA Programming Training

    Course Overview

    Visual Basic for Applications (VBA) is an object oriented programming language developed by Microsoft. VBA language has been integrated with Excel in order to have programming features which enables the developers to handle the data manipulation along with Excel function very easily. VBA is good for developing reporting systems in a capital markets environment and developing core business performance reporting etc.

    WCC has been offering VBA courses since 1996. The course content has been changed over the years and is very much in line with demands and expectations of software developers in the corporate marketplace.

    Our VBA programming course will teach you the relevant skills necessary for you to shine in the current job market in the financial industry.

    Course Mode

    Our course is taught by experience Excel VBA trainers with many years of experience. This course involves working with a various practical hands on exercise in a class room based environment. At the end of the course students will end up with lots of practical experience and learn the useful tips and short-cuts.

    Prerequisites

    • Basic Programming
    • Programming Principle
    • Understanding OO Concept

    Target Audience

    • Programmers
    • Apps Developer
    • Internet Developers
    • Portal Developer
    • Technical Consultant
    • e-Commerce Developer
    • Application Developers
    I attended the VBA training at Westminster College in Oxford Street. Good,,,,,,,
    --Kemmy---

    I done VBA course at Westminster College. I am so happy
    --Salman--
    The payment must be made at least one week in advance. Up on receiving the payment you will be sent a receipt via email. Cheque or Cash payment can also be made in advance. Choose one of the preferred dates below if you want to pay by credit or debit card. In completing the enrolling process and paying for your course, you are confirming that you have received enough information to make an informed decision and that the course is suited to your needs and abilities. No refund will be given after starting the training.
    Course Start Dates
    Select Start Date Time Days Duration Location
    15/10/2014 10.00-5.00pm Wed/Thu/Fri 3 Days Waterloo
    12/11/2014 10.00-5.00pm Wed/Thu/Fri 3 Days Waterloo
    11/11/2014 6.30-9.30pm Tue/Thu 8 Classes Waterloo
    10/12/2014 10.00-5.00pm Wed/Thu/Fri 3 Days Waterloo
    06/01/2015 6.30-9.30pm Tue/Thu 8 Classes Waterloo
    14/01/2015 10.00-5.00pm Wed/Thu/Fri 3 Days Waterloo
    28/01/2015 10.00-5.00pm Wed/Thu/Fri 3 Days Waterloo
    10/02/2015 6.30-9.30pm Tue/Thu 8 Classes Waterloo
    11/02/2015 10.00-5.00pm Wed/Thu/Fri 3 Days Waterloo





    £590.00 (Includes course materials)

    London Waterloo
    Westminster College
    117 Waterloo Road,
    London, SE1 8UL
    email: waterloo@wcc.co.uk
    Tel: +44 (0)207 096 0986


    Just opposite Waterloo station



    East London
    Westminster College
    44 Broadway
    London E15 1XH
    email: stratford@wcc.co.uk


    Just opposite Stratford station


    Course Content


    Introduction to Excel VBA Programming

  • Understanding Macros
  • The Visual Basic Editor
  • Excel VBA Fundamentals
  • Variables, Data types, and Constants
  • VBA Procedures: Sub routines and functions
  • Decision Making with VBA
  • Repeating Actions in VBA
  • Working with Arrays
  • Working with Collections

  • Manipulating Files & controlling Other Applications with VBA

  • Manipulating Files and Folders with VBA
  • Controlling Other Applications with VBA
  • Using Excel with Microsoft Access

  • Enhancing the User Interface

  • Dialog Boxes and Custom Forms
  • Creating Custom Menus and Toolbars with VBA
  • Event-Driven Programming

  • Working with Local and Remote Databases

  • Exporting Data to Access Databases
  • Importing Data from Access Database
  • Connecting to Oracle / SQL Server databases
  • Reading data from Oracle/SQL Server databases
  • Exporting Excel Data to Remote Databases

  • Debugging, Printing and e-mailling

  • Debugging VBA Procedures and Handling Errors
  • Printing and Sending e-mails

  • Programming Special Features

  • Programming Pivot Tables and PivotCharts
  • Programming Special Features
  • Using and Programming Excel Lists
  • Programming the Visual Basic Editor

  • Excel and Web Technologies

  • HTML Programming and Web Queries
  • Excel and ASP
  • Using Microsoft Office Web Components
  • Using XML with Excel
  • Using and Programming Smart Tags

  • Excel and C# Integration

  • Writing C# programming to manipulate Excel data
  • From VBA to C#
  • The Excel Object Model
  • Using C# to access Excel
  • Creating stand-alone Excel applications
  • COM Add-ins
  • Worksheet functions and Automation Add-ins
  • Formulae in C#
  • Two-way Data Interoperability (NumericMatrix/Range)
  • Regex library
  • Using LINQ in C#
  • Creating WCF Services
  • Share this information...


    Need more information

    If you would like to speak to a member
    of our specialist team, please feel free
    to call or email us:

    0207 096 0986     info@wcc.co.uk
    Our Past Students





      Statistics (Comparison only)

    Year | Delegates attended VBA Training
    2013
    2012
    2011
    2010
    2009
    2008
    2007
    2006
    2005
    2004
    2003
    2002
    2001
    2000
    0 100%

    Past Customers

    Some of our recent corporate customers or employees of them in 2011-2013 include;

    Heronden
    On-site training
    CourseExcel VBA
    No of Delegate(s) 3


    Cranfield University
    CourseExcel VBA
    No of Delegate(s) 1


    Royal Bank of Scotland
    CourseExcel VBA
    No of Delegate(s) 1