Master VBA to automate data processing, build advanced macros, and develop efficient Excel-based applications
Excel is powerful, but when tasks become repetitive and data sets grow large, the limitations of standard formulas quickly become apparent. VBA allows you to automate what takes hours, structure complex processes, and produce custom reports. This training covers the VBA language progressively, from the basics of object-oriented programming to the automation of advanced processes involving pivot tables and complex filters.
Is it for you ?
Excel users and developers.
Prerequisites
A knowledge of VBA is necessary to understand this training.
What You'll Walk Away With
- ✓ Automate repetitive tasks and save valuable time in Excel
- ✓ Develop structured macros to manipulate large volumes of data
- ✓ Create custom reports that are automatically generated to meet organizational needs
Training content
1 VBA Excel (versions 2019 and Office 365) - Programming in Excel: Macros and VBA language
- Presentation
- The VBA language
- Object programming in Excel (2019 and Office 365)
- The objects of Excel
- Crosstabs and charts
- Dialog boxes
- Forms
- Improvement of the user interface
- Event management
- Debugging and error handling
- Communication with Office applications
- Internet applications
- Windows programming
- Code for a mini-application
2 VBA for Excel - Automate complex data processing
3 Introduction
- Presentation of the training
- Presentation of the project
4 Preparing and designing
- Advanced Filtering: In-Place Filtering
- Advanced filtering: filtering with extraction
5 Scheduling data processing
- Managing tabs with CodeName
- Using advancedFilter to extract data from a list
- Import the data
- Get the list of trigrams with removeDuplicates
- Load the trigrams dictionary
- Get the list of analytical codes
- Calculate the totals
6 Present the results
- Update the results table
- Empty the results table
- Browse the results table and open the results template
Generate reports
- Write data to the results workbook
- Save the workbooks
- Conclusion
7 VBA for Excel - Process your data with pivot tables
8 Introduction
- Presentation of the training
- Presentation of the project
9 Preparing and designing
- Designing the pivot table
- Programming the PivotTable object
10 Programming the data processing
- Programming the DCT
- Exploiting the DCT
- Fill in the results table
11 Present the results
- Empty the report storage directory
- Inserting hyperlinks
- Delete hyperlinks
- Conclusion
📌 Practical information
100% online training. Accessible anytime from anywhere for one year. If you have any questions about registration, the language of instruction, or the cancellation terms, please consult our FAQ