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

Related Courses

MS Word Basic

  14 hours

Word Advanced

  14 hours

Word 2019 - Part 1

  7 hours

Advanced MS PowerPoint

  7 hours

Advanced PowerPoint for sales teams

  7 hours

Creating Slide Decks for the Financial World

  7 hours

Delivering Impressive Presentation Decks - Social Skills Workshop

  14 hours

Advanced Slide Design in PowerPoint

  7 hours

PowerPoint and Camtasia for Marketing

  21 hours

Excel Advanced with VBA

  21 hours

Visual Basic for Applications (VBA) in Excel - Introduction to programming

  21 hours

Visual Basic for Applications (VBA) in Excel - Advanced

  14 hours

Visual Basic for Applications (VBA) in Excel (intermediate level)

  14 hours

Excel and VBA Programming for Audit and Finance Professionals

  28 hours

Data and Analytics - from the ground up

  42 hours