• +44 01379 671280
  • training@computertrainingsuffolk.co.uk
Microsoft Certified profesional

Microsoft Excel VBA Training Courses.

Excel Introduction

Excel Intermediate

Excel Advanced

Excel VBA

Our Excel VBA Training Course

we offer a range of Microsoft Excel training courses in the uk at your officeor online. We provide Word courses from beginner to Expert levels. Our Excel courses can be tailored to best suit your requirements and can be provided in a variety of delivery styles, including 1-2-1, at your location or via video link

Microsoft Excel VBA course outline.

COURSE OBJECTIVES

  • Use the macro recorder
  • Understand the Visual Basic Editor
  • Develop Procedures
  • Manage the Flow of Control using control structures
  • Debug procedures
  • Learn about the Excel Object Model
  • Declare and set the data type of variables
  • Create User Defined Functions
  • Write Error Handling routines
  • Use Message Boxes and Input Boxes

 

Audience

This Excel introduction VBA training course is aimed at experienced Excel users who need to automate repetitive tasks or simplify more complex tasks using VBA macros. Learn the elements of the Excel object model and control their automation using simple VBA control structures

Pre-requisite

A good knowledge of Spreadsheets is required to attend this course. You must have good Excel Skills to the level of advanced, good keyboard and mouse skills.

Duration

This is a 2 day Excel VBA Introduction course. The course Lasts 12 hours and can start between 9am and  1pm Alternate timings can be arranged upon request. The course can be held on a date that suits you.

Locations

Our Microsoft Excel VBA Introduction course can be run at your offices  or any preferred location in the UK or Via video link online.

online training

Course Content
  • Recording and running macros
  • Recording Absolute and Relative selection
  • Saving a macro-enabled workbook
  • Assigning a macro to the QAT
  • Creating a Macro Button
  • Using the Personal Macro Workbook
  • Introducing Visual Basic for Applications
  • Navigating the Visual Basic Editor
  • Using Help
  • Using statement completion
  • Memory variables
  • Understanding and creating modules
  • Defining procedures
  • Calling subroutines
  • Defining control structures
  • If…Then…Else logical structures
  • Case statements
  • Conditional loops: the Do…Loop structure
  • Counter loops: the For…Next structure
  • Collection loops: the For Each…Next structure
  • Stepping through code
  • Setting Breakpoints
  • Break mode
  • Identifying the current value of expressions
  • Using the Immediate Window
  • The Excel Document Object Model
  • Objects and Collections
  • The Object Browser
  • Methods and Properties
  • The With statement
  • How to declare variables
  • Defining the Scope and Lifetime of variables
  • Determining Data Types
  • Defining constants and using intrinsic constants
  • How to declare and use Object variables
  • Calling Excel worksheet functions
  • Creating a function procedure
  • Calling a User Defined Function
  • Using multiple and optional arguments
  • Defining error handling
  • VBA’s error trapping options
  • Capturing errors with On Error statements
  • The Error object
  • Coding an error handling routine
  • Creating a Message box
  • Message box return values
  • The Input Box function
  • Excel’s InputBox method
  • Handling input box return values
  • VBA conversion functions

 

 

TRAINING SERVICES

Microsoft Office Specialist Courses ( MOS ) courses – Office 2010, 2013, 2016, 365 and 2019 As well as accredited courses we deliver over 200 standard courses covering Microsoft, Apple and Adobe Delivery Styles – Group bookings, 1-2-1, Public courses, Tailored and Office Migrations. Complimentary Training Materials for delegates – We have a dedicated site with a wide range of Microsoft manuals available, new titles are released regularly.

Microsoft Computer training

Accredited and Experienced Trainers

– All our trainers are Microsoft accredited and experienced. You will have peace of mind knowing that our trainers have been personally interviewed and assessed by us for their product knowledge, communication and delivery skill

 

 

On-site Courses – our courses can be delivered on-site at your business premises. we adhere to strict covid guidance Live

Online Courses – our training courses can be delivered on-line with a live tutor via Zoom, Microsoft Teams or Web-ex virtual classroom software. COVID-19: Whilst the

Need to up-skill, re-skill or simply develop your digital skills for the workplace or personal use? We have a huge range of courses to support you in your learning covering all Microsoft Office packages including Word, Outlook, Excel, PowerPoint and MS Project and also offering courses in social media, Apple Macs, computer maintenance and much more.

we are an independent team of training providers in suffolk that are dedicated to helping you to build successful and profitable businesses. Our professionals have a wealth of expertise and knowledge in this field and can be sure to cater to all of your specific needs, no matter how big or small your business may be. So you can have peace of mind knowing that you are in the most capable of hands. We are confident that you won’t find a service quite like ours, anywhere else. Our training providers in suffolk will be on hand to help with all of your requirements whether you are a small establishment or large commercial company.