Course Outline
- Discussion of problems related to MS Office versions,
- Comparison of VSTO to Visual Basic for Application (VBA),
- VSTO architecture overview,
- Discussing the rules of working with data contained in workbooks,
- Data formatting,
- Using your own functions (written in .NET) in the created formulas,
- Responding to MS Excel events,
- Application development,
- Using external data as a data source,
- Discussion of the rules for responding to errors,
- Embedding MS Office applications in your own .NET applications,
- Discussion of the principles and security policies of MS Office, VSTO and the .NET platform.
Requirements
- An understanding of object-oriented programming and .NET Framework
- Experience with Microsoft Office applications and Visual Studio
- C# or Visual Basic programming experience
Audience
- Developers
- Office users
Testimonials (8)
Prepared examples and techniques that I did not know
Magdalena - LKQ Polska Sp. z o. o.
Course - Advanced MS PowerPoint
Machine Translated
Showing examples, pictorial way of translating
Aneta - LKQ Polska Sp. z o. o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Machine Translated
The instructor's interaction with the participants, knowledge, openness to discussion and ideas.
Paweł - LKQ Polska Sp. z o. o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Machine Translated
practical examples
weronika josiek - Denso
Course - Advanced MS PowerPoint
Machine Translated
exhaustion of topics
Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
Course - Excel Advanced with VBA
Machine Translated
The pace of classes is perfect, not too fast, not too slow, lots of examples and exercises. Each participant could freely perform the exercises without any pressure to answer questions. Everyone could act in their own time, and in case of a failed attempt, you could catch up when the trainer showed the solution.
Anna - VOLKSWAGEN POZNAŃ SP. Z O.O.
Course - Excel Advanced with VBA
Machine Translated
Creating tables and calculating their data.
Katarzyna Ciunajcis
Machine Translated
I really was benefit from the real life practical examples.