Master the functionalities of VBA in Excel with this training. Create programming modules and automate spreadsheet entry.
Upcoming sessions
Show all sessions
Duration: 3 days
Regular price: $1,080
Preferential price: $918
Course outline
Duration : 3 days
Prerequisites
Excel advanced or equivalent
Objectives
Understand the parameters of VBA programming for Excel.
Create projects with functions and procedures.
Create programming modules with a user interface.
Automate the input of spreadsheets.
Teaching Method
Lectures - Demonstrations - Directed and individual exercises
Contents
Recording macros
Starting the recording
Understanding the structure of macros
Storing macros
Knowing how to move macros
Using relative and absolute references
Introduction to programming
Using the Visual Basic help
Writing procedures
Use of variables
Controlling the flow of the program
Calling procedures
Workshop
Responses to user actions
Adding event-driven procedures
Using events
Using objects, properties and methods
Using the active element
Workshop
Data validation
Data validation without code
Data validation with code
Workshop
Use of debugging tools
Testing the project
Executing step by step
Using breakpoints
Using the Run window
Workshop
Handling runtime errors
Types of errors
Adding error handlers
Workshop
Making loops in the code
For loops
Using Do loops
Surround yourself with the best
Pierre-Edouard Brondel
Trainer and Desktop Application Consultant
Renowned as an educational expert in the IT and office technology field who has accumulated more than 25 years of experience, Pierre-Édouard is first and foremost passionate about human capital.
Vicky Moreau
Trainer
Vicky Moreau is a passionate freelancer and professional in the area of office automation. She holds a college diploma in office automation, most of her solid experience with the Office Suite was acquired while being an autodidact. In fact, she has successfully completed an MOS (Microsoft Office Specialist) Excel certification.
Yves Pilon
Trainer
Yves Pilon is passionate about technological tools. His knowledge of web and office softwares has made him an expert on all Microsoft Office tools. Yves' excellent pedagogy has earned him praise from our clients on several occasions. He stands out for his spirit of synthesis and active sense of listening to the needs of the participants. The expertise he has accumulated over the years gives him the ability to ensure a productive transfer of knowledge to our clients.
Frédéric Paradis
Certified Trainer and Cloud Architect
As a certified Microsoft trainer, Frédéric describes himself as a Cloud magician who easily navigates the mythical space between technology and reality.