catraining

 

Microsoft Partner
Microsoft Excel VBA Introduction

Audience: This 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. Discover different ways of running macros and master the Dim statement. And save huge amounts of time every day.

Course Duration: 2 days(2)

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday club.

Course Location: This Microsoft Excel VBA Introduction training course is delivered at our training centre in London situated close to Liverpool Street station; training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

reaining course

 

After completing this course, students will be able to:
    • Use the macro recorder
    • Understand the Visual Basic Editor
    • Develop Procedures
    • Manage the Flow of Control using control structures
    • Debug procedures
    • Understand 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

  • Course Outline
    print this page
    Module 1: 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
    Module 2: Working with the Visual Basic Editor
    • Introducing Visual Basic for Applications
    • Navigating the Visual Basic Editor
    • Using Help
    • Using statement completion
    • Memory variables
    Module 3: Developing Procedures
    • Understanding and creating modules
    • Defining procedures
    • Calling subroutines
    Module 4: Managing the Flow of Control
    • Defining control structures
    • Decision making structures:
    • If...End If structure
    • Select Case...End Select structure
    • Looping structures:
    • Conditional loops: the Do...Loop structure
    • Counter loops: the For...Next structure
    • Collection loops: the For Each...Next structure
    Module 5: Debugging
    • Stepping through code
    • Setting Breakpoints
    • Break mode
    • Identifying the current value of expressions
    • Using the Immediate Window
     
    Module 6: Introducing Objects
    • The Excel Document Object Model
    • Objects and Collections
    • The Object Browser
    • Methods and Properties
    • The With statement
    Module 7: 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
    Module 8: Creating User Defined Functions
    • Calling Excel worksheet functions
    • Creating a function procedure
    • Calling a User Defined Function
    • Using multiple arguments
    Module 9: Error Handling
    • Defining error handling
    • VBA's error trapping options
    • Capturing errors with On Error statements
    • The Error object
    • Coding an error handling routine
    Module 10: 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
     
      Microsoft

Call us now for further information Tel:08001601666