Master the functionalities of VBA in Excel with this training. Create programming modules and automate spreadsheet entry.
Upcoming sessions
Show all sessions
Guaranteed to run
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
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.
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.
Marwa Attafi
Trainer
I accumulated more than 10 years of experience in IT before coming to Quebec. I have taught computer science and have been in charge of several business intelligence projects and computer science projects to help with decision support. I have a strong experience as an analyst of business intelligence solutions, ranging from the specification and analysis of needs to the generation of dashboards. My passion for this job, my great technical skills and my sharp analytical mind add to my skills to make me a valued and precious resource for my organization.
