Creation of an application using Microsoft Word, Microsoft Excel and VBA to present the annual accounts of the individual customers of Tandura Treuhand AG. These financial statements are calculated using VBA and clearly presented in the form of graphical diagrams in Microsoft Word. The calculations are supplied as an attachment in Microsoft Excel.

• Creation of automated business reports and annual accounts for the clients of the trust company.
• Embedding a graphic (chart) in an existing Word 2010 document (template).
• The chart (embedded in the Word template) contains data from Microsoft Excel 2010.
• The data and the formatting of the chart are selected using VBA code.
• By default, the data is obtained via a file path, but the data source can be redefined manually.
• The chart can be reformatted at any time using a different display type (eight predefined charts are available) or it can be completely defined manually.
• The entire logic was implemented using VBA.
• Implementation of customer requirements using Microsoft Word 2010.
• Microsoft Visual Basic for Application and Microsoft Excel 2010
• Testing and documentation (user and technical).