Back
Responsive image

Microsoft Excel VBA | Training Course

Harness the power of VBA to manage large and variable amounts of data.
Learn best practice for writing and editing VBA code and improve your data's usability.

MICROSOFT EXPERTS | PROFESSIONAL TRAINING | SMALL COURSE SIZES | LONDON LOCATION

  Course Dates Venue   Price  
Online £379 + VAT save £120
London Bridge £399 + VAT save £100

Microsoft Excel VBA | Training Course

Course Takeaways
Course Info

Course Offering

Course Takeaways
Takeaways

What will I learn?

  • Automate tasks with Macros
  • Create custom functions and procedures
  • Manipulate objects and properties
  • Expressions, variables, and functions
  • Working with forms and controls
  • Free digital course assets
  • Free post-course helpdesk support
Course Takeaways
Learner Reviews

How good is the course?

  • Average Score 5 out of 5
  • Delicious lunch provided
  • Certificate of Achievement
  • 3 reviews

Getting Started

• Displaying the Developer Tab

• Recording and running a Macro

• Macro-Enabled Workbooks

• Using the Visual Basic Editor

• The Development Environment

• Understanding Macro Security

Working with Procedures and Functions

• Understanding Modules

• Understanding Procedures

• Calling Procedures

• Creating a Function Procedure

• Working with the Code Editor

Understanding Objects

• Objects and Collections

• Working with Properties

• Using the With Statement

• Creating an Event Procedure

Using Expressions, Variables, and Intrinsic Functions

• Understanding Expressions and Statements

• Declaring Variables

• Understanding Data Types

• Using Intrinsic Functions

• Understanding Constants

• Declaring and using Object Variables

Controlling Program Execution

• Control-of-Flow Structures

• Working with Boolean Expressions

• Different types of Control-of-Flow structures

• Guidelines for use of Control-of-Flow Structures

Working with Forms and Controls

• Working with UserForm Properties, Events and Methods

• Working with different Controls

• SettingControl Appearance

• Populating a Control

• Adding Code to Controls

• Launching a Form in Code


Handling Errors

• Understanding Error Handling

• Writing an Error-Handling Routine

• Working with Inline Error Handling

Questions and answers

You Might Like These Too

Power BI Business Analytics

from £399 + VAT

2 day course
Learn to present and visualise data like a pro on this Power Bi course.

Master how to create interactive and visually appealing dashboards and reports.

  • Understand Power BI concepts and features
    Connect to various data sources easily
    Create visually appealing and interactive visuals
    Query and shape your data for analysis
    Generate comprehensive reports

Microsoft Excel Adv

from £179 + VAT

1 day course
Gain the confidence to tackle complex challenges and scenarios in Excel.

Learn time-saving hints and tips from professional Microsoft Excel experts.

  • Expanded functions for advanced calculations
    Minimise audit risk with data validation
    Analyse data efficiently with Pivot Tables
    What If Analysis with Goal Seek and Scenarios
    Clever time saving techniques

Microsoft Powerpoint Intro

from £179 + VAT

1 day course
Quickly and easily create professional, engaging presentations using PowerPoint.

Learn tips and tricks from experts to make your presentations shine.

  • PowerPoint interface and navigation
    Layouts and slide design
    Making text look great
    Using images, charts and graphs
    Mastering transitions and animations


"Very Knowledgable and friendly/flexible"
Daiwa Capital Markets Europe Limited
10th June - Microsoft Excel : VBA

Latest Reviews

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1