microsoft
Buylist – Microsoft Excel, VBA
Create the UBS AG BuyList application. This application is about the analysts' recommendations regarding the trading of securities. The individual recommendations are published weekly on the UBS website. Data from individual Excel files are read in, the overall recommendation is calculated by means of complex calculations and finally published on the Internet. The application is created using Microsoft Excel and VBA.
Folder filing system - Microsoft Access, VBA, Microsoft Excel, Microsoft Word Double function as project manager
Creation of an application for managing folders using Microsoft Access for the corporate management of the Adecco company. The folders, their contents, the storage location in the form of the shelf and the exact location on the shelf are catalogued. An interface for importing existing Excel files is implemented. The application is developed using Microsoft Access and VBA.
Teaching SIZ and examination expert
Lessons at the SIZ in Microsoft applications such as Microsoft Excel, Microsoft Word, Microsoft PowerPoint and Microsoft Access. The lessons cover everything from installing the programme and using it to programming simple and complex functionalities using Microsoft VBA. Additional assignments as an examination expert for the SIZ final examination.