Duration
12.0 hours
Regular fee
$250
Objectives of the training
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.Targeted audience
Excel users and developersPrerequisite
A knowledge of VBA is necessary to understand this training.Trainers
Upcoming information
Course architecture
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
VBA for Excel - Automate complex data processing
• 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
VBA for Excel - Automate complex data processing
Introduction
• Presentation of the training
• Presentation of the project
• Presentation of the training
• Presentation of the project
Preparing and designing
• Advanced Filtering: In-Place Filtering
• Advanced filtering: filtering with extraction
• 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
• 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
• 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
• Presentation of the training
• Presentation of the project
Preparing and designing
• Designing the pivot table
• Programming the PivotTable object
• Designing the pivot table
• Programming the PivotTable object
Programming the data processing
• Programming the DCT
• Exploiting the DCT
• Fill in the results table
• Programming the DCT
• Exploiting the DCT
• Fill in the results table
Present the results
• Empty the report storage directory
• Inserting hyperlinks
• Delete hyperlinks
• Conclusion
• Empty the report storage directory
• Inserting hyperlinks
• Delete hyperlinks
• Conclusion
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quoteDuration
12.0 hours
Regular fee
$250
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote