Microsoft Excel VBA Macro Advanced Level 2

  • Select Location
  • Southampton - Solent (Whiteley)
Select a location then date
  • Select Date

  • Warning: Cannot use a scalar value as an array in /home/crystaln/ipsofacto.uk.com/cms/wp-content/themes/advantec/single-course.php on line 144

    Warning: Cannot use a scalar value as an array in /home/crystaln/ipsofacto.uk.com/cms/wp-content/themes/advantec/single-course.php on line 145

    Warning: Cannot use a scalar value as an array in /home/crystaln/ipsofacto.uk.com/cms/wp-content/themes/advantec/single-course.php on line 146

    Notice: Undefined index: icons in /home/crystaln/ipsofacto.uk.com/cms/wp-content/themes/advantec/single-course.php on line 152
  • 30-11-1999
Price (exc vat): £550
PrintDURATION: 2 days
TIME: 09:30 to 16:30 GMT

Using the VBA skills you've learnt in the level 1 course you can now learn additional useful techniques to automate Excel.

About Microsoft Excel VBA Macro Advanced Level 2

Microsoft Excel VBA 2 – “robust and user friendly applications”

IPSO FACTO Microsoft excel training courses Southampton, Portsmouth, Hampshire

This Microsoft Excel advanced VBA course follows on from our VBA Introduction course. The focus of the course is to develop robust and user friendly applications. Issues surrounding performance are discussed and implemented. Integration with both Word, Access and Outlook files are built into the case study which forms a mini project to be completed during the course. User Forms and related controls are used extensively as well as an introduction to the development of Class Modules. You are encouraged to consider the development of your own Functions and several examples are written during the course. Adopting good programming practices will be encouraged throughout the course.

Is this course for you?

You can already create and edit macro’s using Excel VBA programming techniques, but want to fill in gaps and expand your VBA capabilities.

Training options

Scheduled course: £550+VAT per delegate, discount for groups.

Onsite: £1850+VAT for up to eight delegates on the same course. Minimum charge: £1600+VAT for four delegates.

Course Includes

  • Lunch and Refreshments – let us know if you have any special dietary needs. [Excluding London]
  • Microsoft Training Manual
  • Post course training downloads
  • Certificate on completion
  • Post course support relating to course content

Aim & Objectives

Aims

  • Complete advanced elements of VBA
  • Adopt programming best practice

Course Objectives

By the end of this level you will be able to:

  •  Conduct Error Trapping
  •  Employ a range of additional variables
  •  Use data from a Word document
  •  Create forms with controls
  •  Use built-in dialog boxes
  •  Add a calendar for data entry
  •  Create runtime applications and add-ins
  •  Run Access from VBA
  •  Build a function library

Course Content

Review VBA 1 course key elements

Error Trapping and the CASE statement – Building a generic Error handler – Testing for Errors with “Raise”.

Single and Multi-Dimension Array Variables

 

Using Data from MS Word

Building an Array from a Word document

Performance Improvement

Using Object Variables – Creating Object Variables – Setting Object Variables

Controls Dialogue Boxes and Forms

Built-In & Predefined Dialogue Boxes – Adding Form Controls, including Calendar – Multi-choice Controls – Control & Dialogue Box Events

Using VBA References

Creating Runtime applications and Add-Ins – Running Access from VBA – Processing Access Recordsets

Building a Function Library

Advantages of writing generic Functions – Open any Workbook – Open all Workbooks – Manipulate String Data

Procedures, Parameters, Variables

Passing Parameters by Reference and by Value (ByRef ByVal) – Optional and Default Parameters

Dealing with Files

Reading Text Files – Using CSV files

Charts

Creation of a Chart as a Sheet or as an Object within a Sheet – Maintenance of Key Attributes of a Chart

Pivot Tables

Create a Pivot Table and Definition of its source data – Maintenance of Key Attributes of a Pivot Table

Working with Events

Overview of event types – Workbook events – Worksheet events – UserForm events – Activate events – Save events

Course Summary

Video Testimonials

Client Testimonials

  • Name: 200 + delegatesCompany: Via Reviews.co.uk

    View all testimonials

  • Name: Scott SellarsCompany: More on Reviews.co.uk

    APM Project Management Qualification (PMQ) course review

    I completed the PMQ course through IPSO FACTO and they were a pleasure to work with from the moment I first made an enquiry. Every piece of course administration was made simple for me and the classroom facilities were just perfect. The course instructor was professional, knew the subject very well and focused our learning in a practical way to help put it into perspective. Overall, a very professional experience and I would recommend IPSO FACTO as a quality training company. Thank you. [Scott Sellars]

    Link to more reviews: ipsofacto live reviews

    View all testimonials

  • Name: Simon M.Company: Career Change

    PRINCE2 Foundation and Practitioner course review

    I attended the project management qualification in December (having already attended the PRINCE2 course in November). Although a challenging subject, I found that the training was engaging because there was adequate time to not only listen but to also give examples and hear examples from other individuals from the class. This aids to help people’s understanding or misunderstanding in some cases and help breakdown the subject into easier chunks. It also helps that IPSO FACTO have in my opinion some of the most experienced instructors in the country, meaning that if you just don’t get something they bring their personal experience into the story to help your understanding. Simon M.

    Link to more reviews: ipsofacto live reviews

    View all testimonials

  • Name: Chelsea B.Company: More on Reviews.co.uk

    APM PFQ (Introductory Certificate) course review

    The PFQ (APM IC) was for me a good introduction into understanding the ‘Project Management’ world better. It helped me to identify areas and processes that I am not yet familiar with but I now have more confidence in tackling. Passing this course has further confirmed that I do want to go on to study for the APMP qualification. Chelsea B.

    Link to more reviews: ipsofacto live reviews

    View all testimonials