YoVDO

Extend Office clients with Office add-ins – Associate

Offered By: Microsoft via Microsoft Learn

Tags

Microsoft Office 365 Courses Microsoft Excel Courses Microsoft Outlook Courses Microsoft Word Courses Text Formatting Courses

Course Description

Overview

  • Module 1: This module walks through development of Office Add-ins for Microsoft Word.

    • By the end of this module, you'll be able to:

    • Create a Word add-in that uses the Word JavaScript API to manipulate a document
    • Demonstrate how to add and edit content in a Word document
    • Explain how to deploy and host a custom add-in for Microsoft Word
  • Module 2: This module walks through development of Office add-ins for Microsoft Excel.

    • By the end of this module, you will be able to:

    • Create an Excel add-in that uses the Excel JavaScript API to manipulate a workbook
    • Demonstrate how to add and edit content in an Excel document
    • Explain how to deploy and host a custom add-in for Microsoft Excel
  • Module 3: This module walks through development of Office add-ins for Microsoft Outlook.

    • By the end of this module, you'll be able to:

    • Create an Outlook add-in that uses the Outlook JavaScript API to manipulate a document
    • Demonstrate how to access and edit content in an email
    • Explain how to deploy and host a custom add-in for Microsoft Outlook
  • Module 4: This module explains how to use single sign-on in Office Add-ins.

    • By the end of this module, you'll be able to:

    • Understand how Office Add-ins can leverage SSO to call Microsoft Graph
    • Create Word add-in that leverages SSO to call Microsoft Graph
    • Create an Excel add-in that leverages SSO to call Microsoft Graph
    • Create an Outlook add-in that leverages SSO to call Microsoft Graph

Syllabus

  • Module 1: Build Office Add-ins for Word
    • Introduction
    • Work with text, formatting, selections, and ranges in Word documents
    • Exercise - Insert and format a range of text
    • Work with HTML, images, and tables in Word documents
    • Exercise - Insert and replace images, HTML, and tables
    • Work with content controls in Word documents
    • Exercise - Create content controls and replace content
    • Summary
  • Module 2: Build Office add-ins for Excel
    • Introduction
    • Work with tables and charts in Excel workbooks
    • Exercise - Work with tables and charts in Excel add-ins
    • Work with Excel worksheets and Excel add-in commands
    • Exercise - Work with worksheets and add-in commands
    • Work with dialogs
    • Exercise - Work with dialogs in Excel
    • Summary
  • Module 3: Build Office add-ins for Outlook
    • Introduction
    • Mail add-in basics
    • Exercise - Mail add-in basics
    • Add-in commands and dialogs
    • Exercise - Add buttons and commands
    • Task panes and persisting settings
    • Exercise - Add task panes to Outlook add-ins
    • Summary
  • Module 4: Using Single Sign-On (SSO) with Office Add-ins
    • Introduction
    • Implement Single Sign-On (SSO) for Office Add-ins
    • Exercise - Create an Office Add-in for Word that implements Single Sign-On
    • Use Single Sign-On (SSO) in Office Add-ins with Microsoft Graph
    • Exercise - Create an Office Add-in for Excel that implements Single Sign-On
    • Azure AD applications for Office Add-ins and SSO
    • Exercise - Create an Office Add-in for Outlook that implements Single Sign-On
    • Summary

Tags

Related Courses

Aprende las funciones básicas de Microsoft Forms
Coursera Project Network via Coursera البدء في استخدام Microsoft Forms
Coursera Project Network via Coursera بدء استخدام Microsoft Office 365
Coursera Project Network via Coursera Competencias digitales de ofimática: Microsoft Word
Universitat Autònoma de Barcelona (Autonomous University of Barcelona) via Coursera Introducción al Office 365
Universitat Politècnica de València via edX