Master the functionalities of VBA in Excel with this training. Create programming modules and automate spreadsheet entry.
Show all sessions
Guaranteed to run
Duration: 3 days
Regular price: $1,080
Preferential price: $918
Duration : 3 days
Excel advanced or equivalent
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.
Lectures - Demonstrations - Directed and individual exercises
Starting the recording
Understanding the structure of macros
Knowing how to move macros
Using relative and absolute references
Introduction to programming
Using the Visual Basic help
Use of variables
Controlling the flow of the program
Responses to user actions
Adding event-driven procedures
Using objects, properties and methods
Using the active element
Data validation without code
Data validation with code
Use of debugging tools
Testing the project
Executing step by step
Using the Run window
Handling runtime errors
Types of errors
Adding error handlers
Making loops in the code
Using Do loops
Surround yourself with the best
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 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 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.
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.