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
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €6840 online delivery, based on a group of 2 delegates, €2160 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
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)
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
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.
