We offer training on both Windows and Mac computers locally around Cambridge but also any location in the UK and abroad if required:

  • Microsoft Office: Word, Excel, Outlook, PowerPoint, OneDrive, Visio, Teams
  • Microsoft Project
  • Microsoft SharePoint
  • Adobe Creative Suite: Photoshop, InDesign, Illustrator, Acrobat
  • Power BI
  • And many others…just call us on 01223 841848 or email us

Excel VBA

Location Great Shelford, Cambridge
Price ex. VAT £495.00
Start Date 15 June 2020
Course type Standard
Course code FROG230
Duration 2 Day

Description

Delegates will gain a general knowledge of VBA to manipulate and improve processes using Microsoft Excel.

Target Audience

Designed for advanced users of Excel.

Prerequisites

Delegates should be experienced advanced level users of Microsoft Excel or have attended the Advanced Formulae and Functions and Validate and Summarise courses.  This is a very fast paced course and a knowledge of recording macros is required.

Outline

What is Visual Basic for Applications?

An Introduction to Macros

  • Recording Macros
  • Running Macros

Understanding the Visual Basic Environment

  • The Visual Basic Editor
  • Understanding the syntax of your Macros
  • Editing Macros
  • Adding comments and documentation to your macros
  • Assigning VBA and Macros to keyboard shortcuts, icons and menus

With Statements

Managing Error Messages

Debugging Techniques

Working with Variables and Data Types

User Defined Functions

Understand Objects and Collections

Add conditions to your macros

Communicate with the user

  • Message boxes
  • Input Boxes
  • Working with return values

Repeating Actions in VBA – Loops

  • Fixed loops
  • Flexible Loops

Customise Menus and Toolbars

Automation with Macros

  • Create Custom Dialog Boxes

Course Search

Contact Us
Contact Us