Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
21 Hours
Testimonials (5)
Adam was very knowledgeable and had a great layout.
Corey Reis - Lockheed Martin
Course - Advanced Slide Design in PowerPoint
some small tricks regarding image formating and templates - very useful :)
Natalia Wawrzyniak - Akademia Morska w Szczecinie
Course - Advanced MS PowerPoint
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
Julie - Environment, Marine and Fisheries
Course - Excel VBA Introduction
Content and the way it was provided.
Marcin Samborski
Course - Visual Basic for Applications (VBA) in Excel - Advanced
Training agenda was well thought out.