Course Outline

  • Examination of issues related to various versions of Microsoft Office for government use,
  • Comparison of Visual Studio Tools for Office (VSTO) with Visual Basic for Applications (VBA),
  • Overview of VSTO architecture and its application in public sector workflows,
  • Discussion of best practices for handling data within workbooks for government operations,
  • Guidelines for data formatting to ensure compliance with government standards,
  • Integration of custom functions (written in .NET) into formulas for enhanced functionality in government applications,
  • Handling MS Excel events to improve user interaction and data management for government users,
  • Development of tailored applications to meet specific needs for government operations,
  • Utilizing external data sources to enrich government applications and enhance decision-making,
  • Discussion of error handling strategies to ensure robustness and reliability in government systems,
  • Incorporating MS Office applications into custom .NET solutions for streamlined government processes,
  • Review of the security policies and principles governing Microsoft Office, VSTO, and the .NET platform for government use.

Requirements

  • An understanding of object-oriented programming and the .NET Framework for government applications
  • Experience with Microsoft Office applications and Visual Studio for government use
  • C# or Visual Basic programming experience for government projects

Audience

  • Developers for government agencies
  • Office users in the public sector
 21 Hours

Number of participants


Price per participant

Testimonials (5)

Upcoming Courses

Related Categories