Extend Office clients with Office add-ins – Associate

Intermediate
Developer
Microsoft 365
Office Add-ins

The Office add-ins platform enables you to extend the functionality of Office applications including Excel, Outlook, and Word. In this learning path, you'll explore various ways you can use add-ins to extend and interact with Office applications. This learning path can help you prepare for the Microsoft 365 Certified: Developer Associate certification.

Prerequisites

None

Modules in this learning path

Microsoft Office clients enable developers to create add-ins that extend Microsoft Word with custom functionality. Through a JavaScript API, developers can manipulate the content in a Word document from an app running in the task pane. In this module, you'll learn how to build a Word add-in that inserts (and replaces) text ranges, paragraphs, images, HTML, tables, and content controls. You'll also learn how to format text and how to insert (and replace) content in content controls.

Microsoft Office clients enable developers to create add-ins that extend Microsoft Excel with custom functionality. Through a JavaScript API, developers can manipulate the content in an Excel workbook from an app running in the task pane. In this module, you'll learn how to build an Excel add-in that inserts (and replaces) text ranges, tables, charts, and dialogs.

Microsoft Office clients enable developers to create add-ins that extend Microsoft Outlook with custom functionality. Through a JavaScript API, developers can access and edit the contents in an email or calendar event in Outlook from an app running in the client. In this module, you'll learn how to build an Outlook add-in that will render buttons in the compose message window, implement a button that invokes a function, and implement a task pane that inserts content into the body of a message.

Office Add-ins can access information from anywhere on the internet, whether from the server that hosts the add-in, from your internal network, or from somewhere else in the cloud. If that information is protected, your add-in needs a way to authenticate your user. Office Add-ins provide a number of different methods to authenticate using single sign-on (SSO), depending on your specific scenario. In this module, you'll learn how to implement single sign-on (SSO) and call the Microsoft Graph in Word, Excel, and Outlook Add-ins.