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

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard