WCC    Westminster College 020 8261 4684  
 Home  About us  Courses  Online Payment  Contact Pioneers in IT Training & Development   19/05/2012  
ARCHITECT BUSINESS INTELLIGENCE DATABASE PROGRAMMING NETWORKING E-COMMERCE

    Training Locations

    Brentford

    1000 Great West Road
    Brentford TW8 9HH
    Tel: +44 (0)208 261 4684
    email: info@wcc.co.uk

    Brighton

    Boot camp style training only

    Mercure Brighton Seafront Hotel
    149 Kings Road
    BN1 2PP - BRIGHTON

    Bristol

    Boot camp style training only

    Mercure Bristol Brigstow Hotel
    Welsh Back 5-7
    BRISTOL BS1 4SP

    Coventry

    Boot camp style training only

    Mercure Coventry Brandon Hall Hotel
    Main street
    Brandon
    COVENTRY CV8 3FW

    Heartfordshire

    Boot camp style training only

    Letchworth Lane
    Letchworth Garden City
    Hertfordshire SG6 3NP

    Isleworth

    Coomb House
    7 St Johns Road
    Isleworth TW7 6NB

    London

    45 Oxford Street
    London W1D 2DN

    Sri Lanka

    BMICH
    Colombo
    Sri Lanka

    Our Customers

    Some of our recent corporate customers in 2011 include;

    • Cranfield University
    • City Index
    • Umi Plc
    • Prosper Housing
    • NobleProg
    • Pantheon Advisory Ltd

    Some of our past corporate customers include;
    • Middlesex University
    • Imperial College
    • UCL
    • Ministry of Defence
    • Passport Office
    • Barclays
    • Logica
    • KPMG
    • House of Commons
    • Legal & General
    • Specialist School trust
    • Barbican Centre

      Testimonials

Enterprise Excel VBA for Finance

Course Fee : £1290
Pay Securely
Course Start Dates
Select Start Date Time Days Duration Site
21/05/2012 6.00-9.00pm Mon/Wed 5 Week Brentford
11/06/2012 10.00-5.00pm Mon to Fri 1 Week London
16/07/2012 10.00-5.00pm Mon to Fri 1 Week Brentford
17/09/2012 6.00-9.00pm Mon/Wed 5 Weeks London

Course Outline
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# Programming

  • Writing C# programming to manipulate Excel data
  • Using LINQ in C#
  • Creating WCF Services


    • Send me information
    Name
    email
    Telephone
    Course Interested
    Address (Street)
    Town/City
    Post Code
    Message


      Special Offers

      Course 1Course 2Special Price
      Enterprise Excel VBA Applications MCPD Web Developer £1890
      Enterprise Excel VBA Applications Selenium Web Testing £1490
      Enterprise Excel VBA Applications Game Development with C++ £4590
      Enterprise Excel VBA Applications Silverlight 4 Development £1490
      Enterprise Excel VBA Applications Robotics Engineering £4590
      Enterprise Excel VBA Applications SQL Server 208 £1490
      Enterprise Excel VBA Applications MCITP Bootcamp £4590
      Enterprise Excel VBA Applications C# £1490
      Enterprise Excel VBA Applications C# Automated Trading System £4590
      Enterprise Excel VBA Applications C++ £1490
      Enterprise Excel VBA Applications C++ Automated Trading Systems £4590
      Enterprise Excel VBA Applications Java £1490
      Enterprise Excel VBA Applications Enterprise JavaBeans (EJB) £2990
      Enterprise Excel VBA Applications Android Programming £1490
      Enterprise Excel VBA Applications iPhone Apps Development £2090
    West-London College of Computing is the Westminster College of computing (UK) Ltd. Registered in England & Wales, Company No. 07507288,
    © Copyright 2011 www.wcc.co.uk - All Rights Reserved
    table width=100%> IT Training & Bootcamp, we offer Excel VBA courses in London, Excel VBA courses in Isleworth, Excel VBA Courses in Hounslow, Excel VBA Courses in Brentford, London, Bristol, Coventry, Aberdeen, England, Scotland and Ireland locations: in Banbury Franklin Covey, Birmingham West Midlands, Bournemouth Dorset, Bristol South West, Camberley Surrey Sun, Cheltenham Gloucestershire, Chesterfield Derbyshire, Dublin Fitzwilliam Place, , Exeter South West, Farnborough Red Hat, Guildford Red Hat, Hinckley East Midlands, Leeds Yorkshire, Leeds Yorkshire (Ring Road), Leeds Yorkshire City Centre, London In Tuition , London King William Street, London Middlesex Street, London Old Broad Street Fast Lane, London Red Hat, London Rosebery Avenue, London Tabernacle Street, London Victoria Microsoft, Manchester Altrincham, Manchester City Centre , Manchester Stockport, Milton Keynes Buckinghamshire, , Reading Berkshire, Reading Oracle, Scotland Aberdeen, Scotland Edinburgh, Scotland Glasgow, Scotland Glasgow, Slough Berkshire, Swindon Wiltshire, Windsor Berkshire Fast Lane