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.

Human

Digital Tools

Technology

Data Science

Organizational Strategy

Project Management

Excel - Designing VBA applications in Excel

Upcoming sessions

Course outline

Surround yourself with the best