/
/
/

Microsoft Excel 2013 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 shortlistShortlisted by 59 people

https://www.hotcourses.com/courses-by-subject/Microsoft-Excel-2013-VBA-courses/55411260/

Course description

Microsoft Excel 2013 VBA:

Who is this course for?

This course will enable you to use Excel Visual Basic for Applications (VBA) to automate and customise spreadsheets. Were appropriate your own work requirements may be used as course examples.

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 -objects 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

It is assumed that you will be familiar with a wide range of Excel features, in addition to being a competent Microsoft Windows user.

Training for employers

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

Course info
536 views

Location:

Altrincham, WA14 1TD, Nottingham, NG13 8PF, Can be taught anywhere in Central England, North West England, Yorkshire And Humberside

Time:

During the day or In the evening

Duration:

By arrangement

Attendance:

Customised to suit your needs

Qualification:

Certificate of Attendance

From: £405

Other Visual Basic courses

Microsoft Access 2013 VBA

Vantage Training Ltd

Duration: Variable

Certificate of Attendance

Microsoft Word 2013 VBA

Vantage Training Ltd

Duration: Variable

Advanced

Certificate of Attendance

View 11 courses

Summary of all course reviews for Vantage Training Ltd

1 review

(100%)

Average student ranking

Course reviews

This course currently has no reviews.

Write a review

Ask a question

Get course info
Next steps
Add to shortlist