Microsoft Excel VBA Macro Introduction Level 1

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

  • Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 144

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 145

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 146

    Notice: Undefined index: icons in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 152
  • 30-11-1999

  • Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 144

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 145

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 146

    Notice: Undefined index: icons in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 152
  • 30-11-1999

  • Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 144

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 145

    Warning: Cannot use a scalar value as an array in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/wp-content/themes/advantec/single-course.php on line 146

    Notice: Undefined index: icons in /home/linweb08/i/ipsofacto.uk.com-1050448562/user/htdocs/wp_ipsofacto/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

Automate repetitive work in Microsoft Excel by creating VBA code (Macro's) to do the work for you. This is a highly regarded course.

About Microsoft Excel VBA Macro Introduction Level 1

Microsoft Excel VBA – “its all about automation”

IPSO FACTO Microsoft excel training courses Southampton, Portsmouth, Hampshire

Our Microsoft Excel VBA course has been specifically designed for the advanced Excel user who wishes to make use of the more powerful facilities of MS Excel made available from VBA. This course explores VBA language and delegates will develop a small project to ensure that future editing, amending, updating and data extractions can be carried out with the minimum of effort. The course is aimed at those with little or no previous programming background, although experienced programmers wishing to learn VBA will find it a quick and valuable introduction to the language. Previous experience of recording Excel macros is desirable though not essential. Throughout the course the theme of adopting good programming practices will be encouraged.

Is this course for you?

You want to learn how to create and edit macro’s using Excel VBA programming techniques to automate repetitive tasks. Also, you have no Excel VBA programming experience and want to learn useful industry standard techniques.

Training options

Join this scheduled course at our training centre in Whiteley, near Fareham, Portsmouth and Southampton.
Or, consider onsite training using our computers at no extra cost. £400+VAT/delegate or £2,000+VAT for up to eight delegates on the same course. Minimum charge: £1,600+VAT for 2 days training.

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

Aim

To create and edit VBA code to automate elements of Microsoft Excel.

Course Objectives

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

  •  Record and Edit Excel macros
  •  Make informed decisions on when to Record macros and when to write VBA programs
  •  Run macros or VBA programs from a worksheet using command and/or toolbar buttons
  •  Open, Close, Save Workbook(s)
  •  Insert, Delete, Rename Worksheet(s)
  •  Close/save all Open workbooks and Quit Excel
  •  Interact with the PC user through messages and keyboard input including selections from dropdown lists
  •  Construct efficient and easily maintainable VBA Programs
  •  Identify beginning and end of a range of worksheet cells
  •  Extract user specified data from a range of cells (similar to but beyond filtering)
  •  Build multiple worksheets from data extracted from other sheets/workbooks
  •  Format ranges of cells
  •  Carry out arithmetic within VBA or insert Excel functions into a sheet
  •  Trap and handle user generated errors
  •  Develop your own functions similar to those offered by Excel

Course Content

Introduction

What is a Macro? – Recording & Running a Macro – Relative References

Assigning Macros to Buttons and Objects

Assigning a Macro to a Button or a Drawn Object on a Sheet – Assigning a Macro to a Button on a Toolbar

Editing Macros

Visual Basic Editor – Project Explorer – Procedures; Inserting Comments – Printing a Visual Basic Module

Improving Macro Performance

Aesthetic improvements – Increasing speed

Creating VBA Projects

Structuring an application – Identifying Modules and procedures – Writing and testing tight and concise VBA code – Adopting good programming practices

Developing the course Project

Collecting user input – Verifying success of each procedure – Understanding an application’s requirements

The Range Object

Cells & Range Method; Flexible Ranges – Virtual Worksheets; Range Contents

Workbooks and Sheets

Activating a Workbook & Worksheet – This Workbook

Objects, Properties & Methods

Controlling Objects with their Properties – Performing Actions with Methods – Performing Multiple Actions on an Object

Variables

Variables and associated Data Types – Object Variables

Control Structures

Conditional & Looping Control Structures – Non-Structured Statements – Sub Procedures

Using Controls

Adding Worksheet Controls – Worksheet Control Properties

Designing VBA Forms

Using Drop Down Lists

Debugging & Error trapping

Errors, Break Mode; Instant Watch – Stepping & Error Handling

Function Procedures

User Defined Functions

Course Summary

Save VBA projects

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