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
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