We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields

PDF
Course VBA Essentials using Excel
  • Public Scheduled Price£495 +VAT
  • Course Duration2 Days
  • Course Options
    Public Scheduled
    Public Scheduled
    Fixed content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Private
    Private
    Flexible content, flexible date, flexible location, variable length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
  • Latest Reviews7
    "For a new and quite complicated topic, the teaching was very easy to follow and understand, which made it a lot less daunting. Very good course, with a lot of very useful tools and techniques which ar..."

    A. Nissan, VBA Essentials using Excel

    "[The trainer] was very knowledgeable, engaging and approachable. The course was very well put together, the content was suitable for someone with little VBASIC knowledge"

    L.W. CPI, VBA Essentials using Excel

    "Course is aimed at the correct level, and was clear and concise."

    S.F. Nissan, VBA Essentials using Excel

    "A very good course, thanks."

    S.F. Nissan, VBA Essentials using Excel

    "Everything was great, including the lunch that was provided."

    K.G. Royal IHC, VBA Essentials using Excel

    "This has been a very useful course."

    S.F. Nissan, VBA Essentials using Excel

Overview
This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures.
Prerequisites
    • Delegates should have attended the Excel level 3 course or have equivalent knowledge. Previous use of macros would be an advantage, but is not essential.
Objectives
    • Go beyond the user interface of Excel into the Visual Basic for Applications component. This will allow delegates to be able to write/modify programs using Visual Basic for Applications. Delegates will be able to :
    • Control and manipulate Excel using Visual Basic Code
    • Create forms to enter data directly onto your spreadsheet
    • Write complicated macros to check spreadsheet data
    • Create functions that will perform complex calculations
What's included
    • Laptops are available for training delivered at client's premises
    • Lunch and refreshments when training is delivered at our training venues
    • Comprehensive course materials and exercises
    • Telephone and Email Support
Course Content
    • Getting Started
      Introducing Visual Basic for Applications
      Recording a Macro
      Running a Macro
      Editing a Macro in the Visual Basic Editor
      The Development Environment
      Visual Basic Help
      Closing the Visual Basic Editor
    • Working with Procedures and Functions
      Understanding Modules
      Creating a Standard Module
      Understanding Procedures
      Creating a Sub Procedure
      Calling Procedures
      Using the Immediate Window to Call Procedures
      Creating a Function Procedure
      Naming Procedures
      Code Editor
    • Understanding Objects
      Navigating the Excel Object Hierarchy
      Understanding Collections
      Object Browser
      Working with Properties
      Using the With Statement
      Working with Methods
      Event Procedures
    • Using Expressions, Variables, and Intrinsic Functions
      Understanding Expressions and Statements
      Declaring Variables
      Data Types
      Working with Variable Scope
      Intrinsic Functions
      Understanding Constants
      Intrinsic Constants
      Message Boxes
      Input Boxes
      Declaring and Using Object Variables
    • Controlling Program Execution
      Understanding Control-of-Flow Structures
      Boolean Expressions
      If...End If Decision Structures
      Select Case...End Select Structure
      Do...Loop Structure
      For...Next Structure
      For Each...Next Structure
      Guidelines for use of Control-of-Flow Structures
    • Working with Forms and Controls
      Understanding UserForms
      Toolbox
      UserForm Properties, Events, and Methods
      Understanding Controls
      Setting Control Properties in the Properties Window
      Label Control
      Text Box Control. Command Button Control, Combo Box Control, Frame Control and Option Button Controls
      Control Appearance
      Setting the Tab Order
      Populating a Control
      Adding Code to Controls
      Launching a Form in Code
    • Debugging Code
      Understanding Errors
      Debugging Tools
      Setting Breakpoints
      Stepping through Code
      Break Mode during Run mode
      Determining the Value of Expressions
    • Handling Errors
      Understanding Error Handling
      Understanding VBA's Error Trapping Options
      Trapping Errors with the On Error Statement
      Understanding the Err Object
      Writing an Error-Handling Routine
      Working with Inline Error Handling

 

Course Dates

Latest Course Reviews
"Everything was great, including the lunch that was provided."

K.G. Royal IHC, VBA Essentials using Excel

"[The trainer] was very knowledgeable, engaging and approachable. The course was very well put together, the content was suitable for someone with little VBASIC knowledge"

L.W. CPI, VBA Essentials using Excel

"This training has given me the skills to streamline data collection processes in my current role"

L.W. CPI, VBA Essentials using Excel

"This has been a very useful course."

S.F. Nissan, VBA Essentials using Excel

"Course is aimed at the correct level, and was clear and concise."

S.F. Nissan, VBA Essentials using Excel

"A very good course, thanks."

S.F. Nissan, VBA Essentials using Excel

"For a new and quite complicated topic, the teaching was very easy to follow and understand, which made it a lot less daunting. Very good course, with a lot of very useful tools and techniques which are taught in a way that will be easily transferable to the work place."

A. Nissan, VBA Essentials using Excel

 

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 23 Aug 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields