Microsoft Office Add-Ins for Developers

Microsoft Office Add-Ins for Developers

3h 27mIntermediate2018-09-13

Authors

Bill Ayers

Bill Ayers

Consultant Developer, Solution Architect

Course details

Office Add-ins allow developers to customize and place time-saving automation logic for tasks right where users need it—inside Microsoft Office applications. This is a unique opportunity to deliver tangible business benefit with minimal effort. This course shows you how to get started using Office Add-ins. The course covers how to build add-ins with Visual Studio; how to use other libraries with add-ins; how to use add-ins for Word, PowerPoint, OneNote, Excel, and Outlook; and how to distribute an add-in that you developed.

Learning objectives
How Office extensions work
Using the Office.js libraries
Working with ScriptLab
Creating an add-in with Visual Studio
Working with manifests and commands
Deploying and debugging add-ins
Developing new add-in controls
Converting from JavaScript to TypeScript
Working with Yeoman, Angular, and React
Sideloading add-ins to different locations
Guidelines for designing add-ins
Using Office application APIs
Publishing and licensing add-ins

Skills covered

Microsoft DevelopmentVisual StudioOffice 365Personal Productivity SoftwarePersonaBusiness Software and ToolsMicrosoftSoftware Development

Concepts

Introduction

  • Microsoft Office add-ins
  • What are Office add-ins
  • Get the most from this course

Getting Started

  • Office extensions
  • How Office extensions work
  • The Office.js libraries
  • Introduction to ScriptLab
  • Limitations and documentation

Building Add-Ins with Visual Studio

  • Create an add-in with Visual Studio
  • Add-in manifests
  • Add-in web projects
  • Deploying and debugging
  • Add-in commands
  • Create a new control
  • Convert from JavaScript to TypeScript

Using Other Libraries and Tooling with Add-Ins

  • Open web development toolchain
  • Create an add-in with Yeoman
  • Sideload your add-in on the web
  • The Angular framework
  • An example in Angular
  • The React framework
  • An example in React
  • Office UI Fabric
  • Design guidelines
  • Design toolkit
  • Consuming external services

Add-Ins for Word, PowerPoint, and OneNote

  • The Word API
  • An example glossary add-in for Word
  • Create the glossary add-in
  • Explore glossary add-in code
  • Tour the glossary add-in
  • OneNote
  • PowerPoint

Add-Ins for Excel

  • The Excel API
  • A built-in sample in Excel
  • Repurposing
  • Excel custom functions

Add-Ins for Outlook

  • Introduction to Outlook add-ins
  • Sample Outlook add-in
  • Outlook contextual add-ins
  • Working with Microsoft Graph
  • Actionable messages

Distributing Your Add-In

  • Add-in distribution options
  • Sideloading and trusted locations
  • Publishing to the App Catalog
  • Publishing to the Store
  • Licensing
  • Centralized deployment
  • Updating your add-in

Conclusion

  • Staying up to date
80,000 Toman