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 StudioPersonal Productivity SoftwareOffice 365PersonaBusiness Software and ToolsMicrosoftSoftware Development
Concepts
0. Introduction
- 01 - Microsoft Office add-ins
- 02 - What are Office add-ins
- 03 - Get the most from this course
1. Getting Started
- 04 - Office extensions
- 05 - How Office extensions work
- 06 - The Office.js libraries
- 07 - Introduction to ScriptLab
- 08 - Limitations and documentation
2. Building Add-Ins with Visual Studio
- 09 - Create an add-in with Visual Studio
- 10 - Add-in manifests
- 11 - Add-in web projects
- 12 - Deploying and debugging
- 13 - Add-in commands
- 14 - Create a new control
- 15 - Convert from JavaScript to TypeScript
3. Using Other Libraries and Tooling with Add-Ins
- 16 - Open web development toolchain
- 17 - Create an add-in with Yeoman
- 18 - Sideload your add-in on the web
- 19 - The Angular framework
- 20 - An example in Angular
- 21 - The React framework
- 22 - An example in React
- 23 - Office UI Fabric
- 24 - Design guidelines
- 25 - Design toolkit
- 26 - Consuming external services
4. Add-Ins for Word, PowerPoint, and OneNote
- 27 - The Word API
- 28 - An example glossary add-in for Word
- 29 - Create the glossary add-in
- 30 - Explore glossary add-in code
- 31 - Tour the glossary add-in
- 32 - OneNote
- 33 - PowerPoint
5. Add-Ins for Excel
- 34 - The Excel API
- 35 - A built-in sample in Excel
- 36 - Repurposing
- 37 - Excel custom functions
6. Add-Ins for Outlook
- 38 - Introduction to Outlook add-ins
- 39 - Sample Outlook add-in
- 40 - Outlook contextual add-ins
- 41 - Working with Microsoft Graph
- 42 - Actionable messages
7. Distributing Your Add-In
- 43 - Add-in distribution options
- 44 - Sideloading and trusted locations
- 45 - Publishing to the App Catalog
- 46 - Publishing to the Store
- 47 - Licensing
- 48 - Centralized deployment
- 49 - Updating your add-in
Conclusion
- 50 - Staying up to date