Objectives
This Excel VBA e-learning is for users of Excel 2019 or Excel Office 365, or developers who want to create user-friendly, reliable and powerful spreadsheet applications.
Is it for you ?
Excel users and developers.
Prerequisite
A knowledge of VBA is necessary to understand this training.
Your benefits
Content
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
Détails + / -
VBA for Excel - Automate complex data processing
Introduction
- Presentation of the training
- Presentation of the project
Preparing and designing
- Advanced Filtering: In-Place Filtering
- Advanced filtering: filtering with extraction
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
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
VBA for Excel - Process your data with pivot tables
Introduction
- Presentation of the training
- Presentation of the project
Preparing and designing
- Designing the pivot table
- Programming the PivotTable object
Programming the data processing
- Programming the DCT
- Exploiting the DCT
- Fill in the results table
Present the results
- Empty the report storage directory
- Inserting hyperlinks
- Delete hyperlinks
- Conclusion
💡 Useful information
100% online training. Accessible anytime, from anywhere. One year of access to the training and the digital manual. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
Trainers
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote