/
/
/
/

Programming Microsoft Excel with VBA

(5.0)1 review
Recent reviews of this course provider

Very Good Course

Really good and thorough course. It moved at a good pace and covered many aspect...more

See all reviews
Add to shortlist

https://www.hotcourses.com/courses-by-subject/Programming-Microsoft-Excel-with-VBA-courses/55411504/

Course description

Programming Microsoft Excel with VBA:

Overview

Who is this course for?

This course has been developed for advanced Microsoft Excel users, who need to automate cell, worksheet and workbook handling using Word Visual Basic for Applications (VBA).

What will I expect to achieve at the end of the training?
At the end of this course you will be able to:

  • Appreciate the benefits of using Visual Basic (VBA) macros.
  • Record, run and edit basic Excel macros.
  • Interpret and edit VBA code.
  • Apply programming techniques such as conditional branching and loops to your macros.
  • Acquisition of user data and the display of messages.
  • Create User Forms to manage complex user input.

Content

Introducing Macros

Explaining the purpose and potential of Excel macros.

VBA (Macro) Basics

Recording simple macros to automate routines such as document formatting.

Using convenient ways of running macros - menus, toolbars, buttons within documents, and shortcut keys.

Cell Referencing

Using Absolute and Relative referencing in macros.

Methods for Excel navigation and selection.

Working with Excel Objects.

Editing VBA Program Code

An introduction to the programming behind recorded macros.

Understanding the syntax of VBA code.

Making changes and additions to code.

Adding comments.

Using the Basic Help system.

Extending Control

Introducing some commonly used commands to give more power and flexibility to your macros, such as making the actions of your macro conditional on some activity.

Creating non-recordable code for:

Toggling settings.

Managing user-input and displaying messages.

Declaring and using variables.

Use of conditional statements.

Responding to 'Events'.

User Forms

Creating and utilising custom User Forms to manage user interaction.

Processing data returned from user forms.

Troubleshooting Problems

Techniques to help find and resolve problems:

Identifying types of problem.

Interrupting programs.

Monitoring values while programs are running.

Using the De-bug and watch windows.

Additional entry requirements

What do I need to know before attending? Competence with Microsoft Windows. Experienced user of the many features covered on the Introduction, Intermediate and Advanced Microsoft Excel courses.

Training for employers

This course has been specifically designed for companies training their employees.

Course info
168 views
Start Date: Fri 29th March 2019
START DATES
MARCH 2019
Sun Mon Tue Wed Thu Fri Sat
APRIL 2019
Sun Mon Tue Wed Thu Fri Sat

Location:

Altrincham, WA14 1TD, Nottingham, NG13 8PF

Time:

9:30am - 4:30pm

Duration:

1 day

Attendance:

Full time

Qualification:

Certificate of Attendance

Level:

BeginnerIntermediate Advanced

From: £228

Other Visual Basic courses

Microsoft Access 2013 VBA

Vantage Training Ltd

Duration: Variable

Certificate of Attendance

Microsoft Excel 2013 VBA

Vantage Training Ltd

Duration: Variable

Certificate of Attendance

View 11 courses

Summary of all course reviews for Vantage Training Ltd

1 review

(100%)

Average student ranking

Reviews of this course

vantage-training-ltd

Very Good Course
5 5
Hotcourses
April 2015

Really good and thorough course. It moved at a good pace and covered many aspects each one explained with a good understanding gained.

Was this review helpful? Yes No

Please note reviews of Programming Microsoft Excel with VBA are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Ask a question

Get course info
Next steps
Add to shortlist