Who is this training for?
For everyone
Training objectives
- Understand the parameters of programming in VBA for Excel.
- Create projects with functions, procedures.
- Create programming modules with a user interface.
- Automate spreadsheet entry.
Summary
Move from Excel as a simple analysis tool to a true application platform with the power of VBA (Visual BAsic for Applications). This training allows you to design robust, automated Excel applications adapted to business needs. Develop tailor-made solutions to automate repetitive tasks, secure data, improve the user experience and significantly increase operational efficiency. Understand the parameters of programming in VBA for Excel, create projects with functions and procedures, develop programming modules with user interface, and automate spreadsheet entry.
Course outline
Recording Macros
- Starting Recording
- Understanding the Structure of Macros
- Storing Macros • Knowing Movement Methods
- Using Relative and Absolute References
Introduction to Programming
- Using Visual Basic Help
- Writing Procedures
- Working with Variables
- Controlling the Flow of the Program
- Calling Procedures
Responding to User Actions
- Adding Event Procedures
- Working with Events
- Working with Objects, Properties, and Methods
- Working with the Active Element
Data Validation
- Workshop
- Validating Data Without the Help of Code
- Validating Data Using Code
Using Debugging Tools Workshop
- Testing the Project
- Stepping Execution
- Using Breakpoints
- Using the Execution Window
Handling Runtime Errors
- Types of Errors
- Adding Error Handlers
Making Loops in Code Workshop
- Loops For
- Using Do Loops
Approach and methodology
- Lectures
- Demonstrations
- Guided and individual exercises
Prerequisites
Advanced Excel or equivalent content
Recommendations
- Have a basic command of the Windows environment (file management, folders, copy and paste)
- Understand the simple notions of calculation (addition, percentage, average)
- Be comfortable with reading and structuring data (simple tables)
- Know the basics of logic (organize information, follow a sequence of actions)
