Excel VBA

Microsoft Office 365 - Microsoft Excel

Book Course Now

Course Overview

This course is designed to give an overview of Microsoft macros and the powerful uses of Visual Basic for Applications.

This course focuses on using VBA in Excel. It provides all the necessary tools required to create modules, view their contents, to create or edit macro source code, dialogue boxes and perform any other functions related to writing and maintaining VBA programs.

This is a two-day course running from 9:30 am - 4:00 pm.
Training is hands-on and tutor-led.
We provide a comprehensive training manual, lunch and certification.
Courses run at both Swansea and Cardiff locations.
This course can be run as a company specific option either at your site or our own.

  • Course Content

    Getting Started

    Introduce fundamental concepts of event-driven programming.

    Development Environment

    Become familiar with the VBA development environment.

    Visual Basic Editor

    Become familiar with the Visual Basic Editor.
    Change the properties of an object; add a module to a project; write the code for a procedure and then run it and use the Object Browser to search procedures

    Data Types

    Understand the data types available in VBA.
    Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope.

    Working with Functions

    Be able to use built-in functions and write new functions.

    Coding

    Promote tightly written code and good programming practices.
    Create an error handling routine in case things go wrong with VBA code.

    Basic Constructs

    Introduce the basic constructs using logic operators, decision-making and repetition constructors.

    Macros

    Record and edit a Macro.
    Use different techniques in order to run any macros available such as keyboard commands, the use of the Quick Access Toolbars or Buttons

    Procedures

    Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks.

  • Prerequisites

    To gain the maximum benefit from this course the delegate should be able to:
    Navigate, edit and manage Excel workbooks
    Format worksheets and workbooks
    Understand the difference between absolute and relative references
    Understand the basics of Excel formulas and functions e.g. Sum, text functions
    Understand the concepts of a Macro and its capabilities

  • Qualification

    A Computeraid certificate of achievement will be awarded.

Booking Options Available for Excel VBA

Please select the location you want to book the course

Please select the date you want to book the course

Please select the number of people attending the course

No. People
Download Booking Form

Alternatively you can download our booking form, fill in all the relevant information and mail it back to us.

Tailored Training

Tailored Training

Take advantage of a customised training programme to suit your needs at a location of your choice.

Learn More

Funded Training

Funded Training

Funding might be available for training depending on your circumstances.

Learn More

Funded Redundancy Training

Funded Redundancy Training

Are you about to be made redundant or have you been made redundant in the last three months? 100% funded training is available.

Learn More

Email Updates

Email Updates - Join Our Mailing List

Join our mailing list to keep updated on exclusive offers and latest news on our training courses.

  • ECDL
  • ECDL Advanced
  • Approved Test Centre

  • Computeraid Ltd, 4th Floor, 11 Wind Street, Swansea, SA1 1DP

  • Telephone: 01792 610550 / 029 2066 4285
  • [email protected]
Join Computeraid Ltd on Facebook
Follow Computeraid Ltd on Twitter
Tweets by @ComputeraidLtd
View Dizzee Designs on LinkedIn

Computeraid Ltd

Computeraid Ltd – LinkedIn

Computeraid is the largest supplier independent computer training and consultancy company in South Wales, training around 20,000
people days annually.

Swansea. South Wales