Transform Excel from a simple analysis tool into a full-fledged application platform using the power of VBA (Visual Basic for Applications). This course will teach you how to design robust, automated Excel applications tailored to your business needs. Develop custom solutions to automate repetitive tasks, secure data, improve the user experience, and significantly increase operational efficiency. Understand the fundamentals of VBA programming for Excel, create projects with functions and procedures, develop programming modules with user interfaces, and automate data entry in spreadsheets.

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

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.

Marwa Attafi

Trainer

Marwa Atafi has over ten years of experience in IT, including several strategic projects in business intelligence and decision support systems. Before arriving in Quebec, she taught a wide range of IT subjects and led complex projects, from needs assessment to the implementation of analytical solutions. She has in-depth expertise in Business Intelligence, covering all stages: requirements analysis, data modeling, design, and deployment of interactive dashboards. She is proficient with tools and technologies such as Power BI, Power Apps, Power Automate, SQL Server, ETL (SSIS), and advanced Excel, as well as results-oriented project management methods. Responsible, motivated, and passionate about her field, Marwa stands out for her technical skills and analytical mindset, making her a sought-after and strategic resource.

Human

Digital Tools

Technology

Data Science

Organizational Strategy

Project Management

Change region

Excel - Designing VBA applications in Excel

Upcoming sessions

Course outline

Surround yourself with the best