VBA Excel Course in Clare

VBA Excel Course in Clare

Our Microsoft Excel VBA course has been designed to help your team to use Excel's advanced programming features to build macro-driven applications, automate repetitive operations and create custom functions.

This Excel VBA training course will show your team how to make the most of the programming possibilities in Excel. It aims to give advanced excel user's a thorough introduction to Excel VBA programming. This one-day course gives learners an understanding of Macros and an introduction to the Excel VBA language within MS Excel.

Support

Dedicated team of trainers and staff, committed to delivering support and advice to our customers.

Experience

We have over 12 years experience providing training for individuals, small, medium and large companies.

Training Team

Our trainers combine professional know-how with experience in their chosen training field.

Quality Assured

Safeguard your training investment. We offer courses accredited by national and international certification bodies.

a few of the companies that trust dcm

Get the
VBA Excel Training Course Brochure & 2020/2023 Timetable Instantly

Get the VBA Excel Training Course Brochure & 2020/2023 Timetable Instantly

Full Course Outline

What's Inside the Brochure - Course Format; Trainer Profiles; Testimonials; Membership Details; Full 2023 & Fee.

Membership Details

By becoming a Member with DCM, you will gain access to exclusive free courses and substantial discounts on our certified courses.

Customer Stories

We work with the biggest brands in Ireland including Symantec, Keelings and Vodafone but don't just take our word for it.

Team Development Needs?

Do you have team development needs? An inhouse training solution is typically less expensive per head than publicly scheduled courses and provides greater business relevance.

WHY CHOOSE THIS EXCEL VBA TRAINING COURSE?

This is very practical and interactive course, ideal for those who already have a good understanding of excel and want to improve their skills with the software.

Practical Approach

Role-play exercises, with feedback from fellow delegates and the trainer, will be a feature of the course and delegates will be encouraged to share real life experiences.

Get Certified in Your Own Time

We offer virtual training in Management, Project Management, QQI Train the Trainer, Lean and Learning & Development - just choose your area of interest.

Benefits of Online Training

Our Virtual Training courses allow you to access award-winning classroom training, without leaving your home or office. We use the GoToTraining video training platform.

96% Of people who attended our training courses would recommend to others

20K Join the 20,000+ members who've advanced their career with DCM

87% Of learners report career benefits like getting a promotion or a raise

What is covered in this course?

The course will use multiple exercises to ensure that delegates can practice the key techniques that are taught and also ask any questions that they may have.

1

Recorded Macros

Setting Macro Security Levels
Running a Simple Macro
Relative Cell References
Viewing & Modifying a Macro

2

Understanding VBA

VBA Terminology
Working with Object Collections
Setting Property Values
Programming with the Object Browser

3

VBA Editor

Working with the Project Explorer
Working with the Properties
Working with a Code Module
Breakpoints in the Editor

4

Using Variables

Creating & Using Variables
Scope of Variables
Procedure Level Scoping
Passing Variables by Reference

5

Excel Objects

Using Workbook Objects
Viewing Excel & the Editor
Worksheet Methods & Properties
Range Methods & Properties

6

Programming Techniques

The MsgBox Function
Using the InputBox Function
The IF Statement
Using IF for Multiple Conditions

Please Note: Each delegate will leave the course with an action plan for the workplace

Need Some Advice?

We have an excellent team who are more than happy to give you advice about the course. It doesn't matter what the question please ask, we'd be delighted to help.

DCM Learning Who We Are and What We’re About

DCM Learning is an award provider of training and consultancy solutions to global brands.

What We Do

Founded in Dublin, DCM Learning is fast becoming recognised as a leading training organisation. We work closely with industry to define the skills and qualifications required to thrive.

At our core, we believe people learn best by doing. We design fun, powerful experiences that have a profound and lasting impact on people and their careers, inspiring new ways of thinking, building critical capabilities and unleashing business success.

Our Customers

We work with small and large companies, individuals, Government Agencies, Universities and blue-chip companies such as Keelings, Google, Zendesk, Novartis, IBM and Symantec, so you can have confidence in our ability to deliver the results you want to achieve.

Our Certification Partners

Got Questions? Please Don't be Afraid to Ask.

How can we help?

You’ve got some question’s and we’ve got plenty of answer’s. Ask us about the course, the price, the certification, future opportunities … anything we can help with! Don’t be shy - we promise we’re really nice.

978 THE NUMBER OF COMPANIES WE DELIVERED INHOUSE TRAINING WITH LAST YEAR

87.3% OF COMPANIES WHO RETURNED FOR MORE TRAINING

37 27 FULL TIME TRAINING CONSULTANTS PLUS 10 SUPPORT STAFF

Trusted by

Locations

Locations: The course is run in the Temple Gate Hotel, The Square, Ennis, Co. Clare | The Oakwood Arms Hotel, Shannon Town, Shannon, Co. Clare

What's included: A delicious lunch with tea/coffee, free parking, WIFI and course materials.

Got Questions?: Call (065) 671 9032

Locations

Make sure you Safeguard Your Training Investment. DCM offer courses accredited by:

Course Categories

Management Project Mgt. & Lean Agile Project Mgt.Learning & Development Communications + View All 186 Courses

Course Categories

Information Technology Finance Written Communication Personal Effectiveness Customer Service + View All 186 Courses