catraining

 

Microsoft Partner
Microsoft Excel VBA Introduction (1 day)

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. And save huge amounts of time every day.

Course Duration: This is a 1 day Fast Track Course to get you up and running with VBA.

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:
    • 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

  • Course Outline
    print this page
    Module 1: Recording Macros
    • Recording and running macros
    • Using Relative References
    • 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
    Module 3: Developing Procedures
    • Understanding and creating modules
    • Defining procedures
    • Calling subroutines
    • Memory variables
    Module 4: Managing the Flow of Control
    • 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 and Run mode
    • Identifying the value of expressions
    • Using the Immediate Window
    • Basic Error Handling
    Module 6: Introducing Objects
    • The Excel Document Object Model
    • Objects and Collections
    • The Object Browser
    • Methods and Properties
    • The With statement
     
      Microsoft

Call us now for further information Tel:08001601666