VBA for Excel (2019 and Microsoft 365 versions): Programming Efficiently with Excel

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