Dublin
01 524 1338
Cork
021 242 9691

MS® Excel VBA Training

Got a Question? Ask anything, we'll reply instantly. Ask now

How can we help?

Thanks for getting in touch.

All of our team are currently busy with customers, so please leave your email address and we will get back to you within 10 minutes.

We promise :)

All courses

Onsite Training?

We can come to you - wherever you are with work- shops and training sessions tailored to your specific needs.

Find out more

Trusted by ...

Computer programming is the world’s fastest growing profession with thousands of vacancies for developers from all backgrounds. Microsoft Excel is the world's most popular spreadsheet program. Our feedback shows that people who have taken our courses, are getting their work done up to 50% faster now that they fully understand VBA Excel. VBA Excel will allow you to get consistent results at a much greater speed than any other spreadsheet software on the market.

The key topics that it covers include recorded macros, the macro editor, using and defining variables, creating custom forms and working with the various objects within Microsoft Excel. VBA Excel is very widely used to automate repetitive tasks in Excel.

Get Answers to Your Questions in the VBA Excel Training Course Brochure. The brochure contains: Course Format; Certification; Trainer Profiles; Previous Clients; Course Syllabus; Full 2017 Timetable & Course Fee. 

Get the Excel VBA Training Brochure & 2017 Timetable Instantly

What's Inside the Brochure?
  • Full course outline
  • Training Centres (5 Locations)
  • Fee and 2017 Timetable
Download Now

Objectives:

The aim of this course is to give delegates a thorough grounding in Excel VBA. It uses multiple exercises to ensure that delegates can practice the key techniques that are taught and also ask any questions that they may have. Our aim is that you leave the course as a confident, albeit inexperienced, Excel programmer and can start automating your spreadsheets as soon as your return to your office.

What will you learn on this course?


  • Recorded Macros

    Setting Macro Security Levels; Recording and Running a Simple Macro; Relative Cell References; Running a Macro With Relative References; Viewing and Modifying in a Macro Module

  • Understanding VBA

    VBA Terminology; Accessing the Excel Object Model; Using the Immediate Window; Working with Object Collections; Setting Property Values; Working with Worksheets; Using the Object Browser; Programming with the Object Browser

  • Understanding VBA Editor

    Opening and Closing The Editor; Working with the Project Explorer; Working with the Properties Window; Working with the Work Area; Working with a Code Module; Running Procedures from the Editor; Setting Breakpoints in the Editor; Stepping through a Procedure

  • Using Variables

    Creating & Using Variables; Implicit and Explicit Declarations; The Scope of Variables; Procedure Level Scoping; Module Level Scoping; Passing Variables by Reference; Passing Variables by Value; Data Types; Declaring Data Types; Using Arrays

  • User-Defined Functions

    User-Defined Functions Theory; Creating Simple User-Defined Functions; Using User-Defined Functions; Using Multiple Arguments; Modifying a Function; Creating a Function Library

  • Using Excel Objects

    Application Methods & Properties; Workbook Methods & Properties; Viewing Excel & the Editor Together; Using Workbook Objects; Worksheet Methods & Properties; Using Worksheet Objects; Range Methods & Properties; Using Range Objects; Project – using Objects in a Procedure

  • Programming Techniques

    The MsgBox Function; Sending Messages to the User; InputBox Techniques; Using the InputBox Function; Using the InputBox Method; The IF Statement; Using IF for Single Conditions; Using IF for Multiple Conditions; The FOR NEXT Statement; Looping Known/Specified Iterations; The DO LOOP Statement; Looping With Unknown Iterations

  • Creating Custom Forms

    Creating A Custom Form; Adding Text Boxes To A Form; Changing Text Box Control Properties; Adding Label Controls To A Form; Adding A Combo Box Control; Adding Option Buttons; Adding Command Buttons; Running A Custom Form

How does it Work?

Onsite Training is when we come to you to provide training on your premises or at a location of your choice. Not only will we run the course at a time and venue that suits you, we will also develop a unique programme particular to the developmental, cultural and business requirements of your company.

What's Involved?


Step 1 | After initial discussions, you meet with our training specialist. Here you both work together to design and sculpt a more comprehensive programme outline.

Step 2 | From this outline, a course is designed which addresses your exact needs. Sometimes this involves a completely new course designed from scratch, this depends on your needs.

Step 3 | Once you're happy with everything, the trainer will deliver the course at a venue of your choice on a date that suits.

Step 4 | Once complete, feedback will be gathered from delegates to ascertain the ‘true’ impact. And finally a report will be compiled for you outlining outcomes alongside your stated objectives.

Get a tailored training quote for your Excel VBA training today Get Your Quote

Introduction to MS Excel

Introduction to MS Excel

Microsoft Excel is a useful tool for generating spreadsheets from a number of data sources. Using calculations and predefined formulas, users can easily manage any type of data including budgets, fina...

Introduction to MS Excel
Power Point Presentation Skills

Power Point Presentation Skills

PowerPoint is a most useful tool for the presenter - it is also the most misused tool. It has coined phrases such as ‘Death by PowerPoint’, ‘Bullet Point maze’, and MEGO*. The reality is most PowerPoi...

Power Point Presentation Skills
Prezi

Prezi

Take your presentations from mediocre to magnificent - discover how Prezi is revolutionising the world of business presentations and how you can do the same with your presentation. People remember spa...

Prezi
MS Word

MS Word

Advance your skills using powerful formatting features including tables, text and images. With Microsoft Word’s more advanced features, you can enhance your documents with tables, pictures and drawing...

MS Word
Data Analytics

Data Analytics

Big Data Analytics allow organizations to build competitive strategies around data-driven insights and derive value from vast amounts of untapped data. Whether you are tracking the efficiency of a wa...

Data Analytics
Advanced MS Excel

Advanced MS Excel

This advanced course is aimed at learners who have a good grounding in Excel either from experience or attending our Intermediate Microsoft Excel training course. If your job involves manipulating and...

Advanced MS Excel
Jira

Jira

Are you new to JIRA? Are you working in Software Development or Testing and not aware how to use JIRA effectively? Do you want to keep yourself competitive in the IT market by leveling up your JIRA sk...

Jira
Intermediate MS Excel

Intermediate MS Excel

This intermediate Microsoft Excel training course is suitable whatever version of Excel you use, from 2003 – 2013, you will expand your knowledge and skills. By the end of this course, you will be abl...

Intermediate MS Excel
Location Date Max Attendee Registered
(so far)
Booking
Dublin | Training Centre 31 March 2016 14 14 Fully Booked
Dublin | Training Centre 7 June 2016 14 14 Fully Booked
Dublin | Training Centre 9 November 2016 14 14 Fully Booked

Get the Full Course Brochure & 2017 Timetable Instantly

Get Your Brochure Now

Get the Excel Training Course Brochure Now

What's Inside the Brochure?
  • Full course & certification outline
  • Career opportunities & trends
  • Fee's and 2017 Timetable

Download

Mediation Skills Onsite Guide

  • Full details of the Mediation Skills Course

  • Case studies from companies we have delivered the Mediation Skills Course onsite with

  • 2014 Timetable for our public courses

  • Our onsite Mediation Skills trainer profiles

Download Now

Get the 2014 Mediation Skills Course Timetable

  • Nationwide locations and venues for 2014

  • Areas include | Dublin, Cork, Galway, Limerick, Meath and many other counties

  • Onsite training is also an option

Download Now

Ask Anything? Get an Answer Instantly!




Get Answers

on the Course Today and Our Team will Call You to Confirm Your Place

VBA Excel

How can we help?

Thanks for getting in touch.

All of our team are currently busy with customers, so please leave your email address and we will get back to you within 10 minutes.

We promise :)