Microsoft Excel VBA Training Courses.
Our Excel VBA Training Coursewe 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-requisiteA 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.
DurationThis 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.
LocationsOur Microsoft Excel VBA Introduction course can be run at your offices or any preferred location in the UK or Via video link online.
Course Content
Recording Macros
- 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
Working with the Visual Basic Editor
- Introducing Visual Basic for Applications
- Navigating the Visual Basic Editor
- Using Help
- Using statement completion
- Memory variables
Developing Procedures
- Understanding and creating modules
- Defining procedures
- Calling subroutines
Managing the Flow of Control
- 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
Debugging
- Stepping through code
- Setting Breakpoints
- Break mode
- Identifying the current value of expressions
- Using the Immediate Window
Introducing Objects
- The Excel Document Object Model
- Objects and Collections
- The Object Browser
- Methods and Properties
- The With statement
Declaring Variables
- 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
Creating User Defined Functions
- Calling Excel worksheet functions
- Creating a function procedure
- Calling a User Defined Function
- Using multiple and optional arguments
Error Handling
- Defining error handling
- VBA’s error trapping options
- Capturing errors with On Error statements
- The Error object
- Coding an error handling routine
Message Boxes and Input Boxes
- 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.
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.