Loading...
  1. About the Course
  2. Syllabus
  3. Target Audience
  4. Book the Course

Course Overview

Excel VBA Training London

VVisual VVisual Basic for Applications (VBA) is an article situated programming dialect created by Microsoft. VBA dialect has been coordinated with Excel keeping in mind the end goal to have programming highlights which empowers the designers to handle the information control alongside Excel work effortlessly. VBA is useful for creating reporting frameworks in a capital markets environment and creating center business execution reporting and so on.

Our VBA programming course will demonstrate to you the critical aptitudes fundamental for you to shimmer in the present spot of occupation business division in the money related business. Our course is taught by experience Excel VBA mentors with various years of experience. This course incorporates working with an alternate feasible hands on action in a classroom based environment. Around the end of the course understudies will end up with heaps of helpful experience and take in the profitable tips and backup ways to go.

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