€275

Excel - VBA Bootcamp

Event Information

Share this event

Date and Time

Location

Location

New Horizons Ireland

22-24 Strand Street Great, Strand House

D01 W1W4 Dublin 1

Ireland

View Map

Refund Policy

Refund Policy

Refunds up to 30 days before event

Event description

Description

TARGET AUDIENCE

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 OBJECTIVES

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.


COURSE OUTLINE

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

More details click below:

https://www.nhireland.ie/training-and-certifications/course-outline/id/1023792507/c/excel-vba-bootcamp

Share with friends

Date and Time

Location

New Horizons Ireland

22-24 Strand Street Great, Strand House

D01 W1W4 Dublin 1

Ireland

View Map

Refund Policy

Refunds up to 30 days before event

Save This Event

Event Saved