Microsoft VBA

Course

Online

£ 59 VAT inc.

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Class hours

    4h

  • Duration

    Flexible

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

VBA, or Visual Basic for Applications, is like Excel on steroids. As an advanced feature, it can seem intimidating at first. But with just a little VBA knowledge you’ll be able to automate tasks in Excel and turbocharge your data handling capabilities.

We’ll take you from beginner to advanced user in only 9 hours on this online video training course.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

To automate tasks and operations that you perform frequently.
How to define and manage variables, set up subroutines, and create functions.
How to use input boxes and message boxes to interact with end users.
Practical methods for using macro errors to improve your VBA code.
About the PivotTable object and basic approaches to utilizing it.
What variables are, and how they relate to functions versus methods and subroutines.
To create cross-functional flowcharts.

The course is designed for individuals and professionals who are new to VBA and who are seeking practical ways to automate tasks in Microsoft Excel that are performed frequently.

CPD UK

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • Excel
  • MS Excel
  • VBA
  • Environment
  • Macros
  • Language
  • Working
  • Conclusion
  • Microsoft VBA
  • Microsoft Access

Course programme

Syllabus:

Section 1: Introduction
  • Unit 1.1 - The VBA Course and the Environment
Section 2: VBA and Macros
  • Unit 2.1 - VBA as a Language
  • Unit 2.2 - Introducing Macros
Section 3: Functions
  • Unit 3.1 - Introducing Functions
Section 4: Common Keys to VBA
  • Unit 4.1 - Working with Objects
Section 5: Closure
  • Unit 5.1 - Conclusion

Microsoft VBA

£ 59 VAT inc.