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 (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
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.
Aleksander Jarecki - Amazon Development Center Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
I enjoyed the Excel sheets provided having the exercises with examples. This meant that if Tamil was held up helping other people, I could crack on with the next parts.
Luke Pontin
Course - Data and Analytics - from the ground up
Training agenda was well thought out.