Excel - Designing VBA applications in Excel

Master the functionalities of VBA in Excel with this training. Create programming modules and automate spreadsheet entry.
Microsoft Partner

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

Pierre-Edouard Brondel
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
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
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
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.