Excel VBA Programming

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.
Notes:
  • Training dates may be postponed due to some unavoidable circumstances
  • Once you started the training programme, absolutely no refund will be given in any circumstances.
£1290.00 GBP   Enrol
  • Course Details
  • Course Contents
  • Technical Details
Prerequisites
  • Basic Programming
  • Programming Principle
  • Understanding OO Concept Database design

     

    Target Audience

  • Finance Brokers
  • Financial Apps Developer
  • Internet Developers
  • Accountants
  • Technical Consultant
  • e-Commerce Developer
  • Application Developers

     

     

  • Excel VBA Programming


    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

     

  • Start Dates
    08/01/2013 6.30-8.30pm Tue/Thu 8 Classes London
    02/04/2013 6.30-8.30pm Tue/Thu 8 Classes London
    04/03/2013 6.30-8.30pm Mon/Wed 8 Classes London
    02/07/2013 6.30-8.30pm Tue/Thu 8 Classes London
    08/10/2013 6.30-8.30pm Tue/Thu 8 Classes London
    26/11/2013 6.30-8.30pm Tue/Thu 8 Classes London
    04/02/2014 6.30-8.30pm Tue/Thu 8 Classes London

    About Us

    A key strength in London IT Skills Training Centre Corporate Training is the ability to design and deliver bespoke development training at all levels of Programming and Databases.

     

    We're delighted to bring an updated iPhone Developer Training Course along with the traditional courses including C, C++ in London, offering developers in the UK and Europe endless opportunities in this exciting, dynamic market.

     

    We are also specilised in e-Commerce and Networking training through which a lot of customers benefited in the past.

    We have trained employees from various companies in the past.

     



    read more