Microsoft Office Add-Ins for Developers
3h 27mIntermediate2018-09-13
Authors

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
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