FORGOT YOUR DETAILS?

Microsoft Excel VBA Course | Training

Create and enhance macros to automate almost any task in Excel

This 2-day advanced Excel VBA course covers the VBA features of Microsoft Excel, including exploring and understanding the VBA language and learning to tailor solutions to almost any problem.

Visual Basic for Applications (VBA) is a powerful tool that allows users to develop custom solutions and automate routine task in Excel. Completing this Excel VBA course will allow you to create and enhance macros to automate almost any task in Excel, thereby increasing efficiency and saving time.

During this Excel VBA course, will show you how macros work within Excel, and how to create them to extend the functionality of Excel. Other key topics covered include activating worksheets, performing loops, controlling objects with their properties, handling form controls, error handling and much more.

Requirements

  • You should have attended the Excel Advanced course, or have gained similar knowledge in the workplace.
  • No prior knowledge of MS Excel macros or VBA is required.

Why take this Excel VBA course?

Increase efficiency – Learning VBA will help you automate repetitive tasks and save a tremendous amount of time, allowing you to focus on other tasks you wouldn't otherwise have time for.

Enhance your ability to quickly sort large amounts of data – You will learn how to use powerful tools to quickly sort through large data sets with minimal risk of error.

Improve your job prospects – Learning Excel VBA will open up more opportunities for employment, especially in the finance sector.

Who should take this course?

  • Professionals who are already proficient at working with Excel
  • Power users who wish to learn how to automate routine tasks to increase productivity
  • Anyone aspiring to achieve Microsoft Certification status.

Duration

2 days

Request Training

t: 0203 941 4100 | e: info@escalla.co.uk

2-Day Course Content

  • What is a macro
  • Recording a macro
  • Running a macro
  • Relative references
  • Assigning a macro to a button on a worksheet or toolbar
  • Button image editor
  • Attaching toolbars to workbooks
  • Visual basic editor
  • Project explorer
  • Code window
  • Procedures
  • Inserting comments
  • Printing a visual basic module
  • What is the range object
  • Cell property
  • Range property
  • Flexible ranges
  • Range contents
  • Activating a workbook
  • Activating a worksheet
  • This WorkBook
  • Controlling objects with their properties
  • Performing actions with methods
  • Performing multiple actions on an object
  • Variables
  • Data types
  • Data type summary
  • Constants
  • Conditional control structures
  • Looping control structures
  • Non-structured statements
  • Sub-procedures
  • Built-in dialogue boxes
  • Predefined dialogue boxes
  • Custom forms
  • Worksheet forms
  • Setting the properties of a control
  • User-defined forms
  • Adding form controls
  • Form control properties
  • Control and dialogue box events
  • Displaying and dismissing a user form
  • Handling form controls
  • What are errors
  • Types of error
  • Break mode
  • Instant watch
  • Stepping through code
  • Error handling
  • Worksheet object events
  • Workbook object events
  • Function procedures
  • User-defined functions
  • Function wizard
  • Excel functions
TOP