MS Excel: VBA Bootcamp

Start Dates: TBC

Duration: 1 Day

CPD Hours: 6 Hours

https://www.ifsskillnet.ie Book Now

Programme overview

This course is intended for the experienced Excel users that want to gain knowledge of visual basic for applications (VBA).

Learning outcomes:

Upon successful completion of this course, students will understand the programming environment of Visual Basic for applications and know how to create custom procedures and functions that can expand their ability to use Excel more effectively

Who is the course for?

To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.

Course Content:

1 – Introduction to Macros

Recording Macros

Absolute and Relative

How to Run a Macro

2 – Basics of Code Writing

The VBA Environment (the “VBE” window)

Essential Tips, Tricks, Shortcuts

Understanding VBA and Best Practice

3 – Crucial VBA Objects and Structures

Variables and Data Types

Conditionals (If, Select Case)

Loops (For, Do)

4 – Interaction

Interact with Data, Sheets, the Excel Application

Interact with User (Message Box, Input Box)

5 – Errors

Run

Editing

Debuging

Handeling Errors

Trainer Profile

Please contact info@ifsskillnet.ie for further information on training providers.