Duration
1 Days
6 CPD hours
This course is intended 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.
Overview
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.
This course is intended for the experienced Excel users that want to gain
knowledge of visual basic for applications (VBA).
INTRODUCTION TO MACROS
* Recording Macros
* Absolute and Relative
* How to Run a Macro
BASICS OF CODE WRITING
* The VBA Environment (the ?VBE? window)
* Essential Tips, Tricks, Shortcuts
* Understanding VBA and Best Practice
CRUCIAL VBA OBJECTS AND STRUCTURES
* Variables and Data Types
* Conditionals (If, Select Case)
* Loops (For, Do)
INTERACTION
* Interact with Data, Sheets, the Excel Application
* Interact with User (Message Box, Input Box)
ERRORS
* Run
* Editing
* Debuging
* Handeling Errors
ADDITIONAL COURSE DETAILS:
Nexus Humans Excel - VBA Bootcamp training program is a workshop that presents
an invigorating mix of sessions, lessons, and masterclasses meticulously crafted
to propel your learning expedition forward.
This immersive bootcamp-style experience boasts interactive lectures, hands-on
labs, and collaborative hackathons, all strategically designed to fortify
fundamental concepts.
Guided by seasoned coaches, each session offers priceless insights and practical
skills crucial for honing your expertise. Whether you're stepping into the realm
of professional skills or a seasoned professional, this comprehensive course
ensures you're equipped with the knowledge and prowess necessary for success.
While we feel this is the best course for the Excel - VBA Bootcamp course and
one of our Top 10 we encourage you to read the course outline to make sure it is
the right content for you.
Additionally, private sessions, closed classes or dedicated events are available
both live online and at our training centres in Dublin and London, as well as at
your offices anywhere in the UK, Ireland or across EMEA.