Build Excel Add-ins with Office JS APIs

This course will teach you how to leverage the web technologies you already know and the power of Microsoft Office to create powerful solutions for both the enterprise and end users.
Course info
Level
Intermediate
Updated
Apr 5, 2017
Duration
2h 16m
Table of contents
Description
Course info
Level
Intermediate
Updated
Apr 5, 2017
Duration
2h 16m
Description

At the core of Excel Add-ins, for Office 365 and Office Desktop, is a thorough knowledge of the Excel Object Model. In this course, Build Excel Add-ins with Office JS APIs, you'll learn how to build your own Excel Add-in. First, you'll learn about asynchronous programming with the Excel Object Model. Next, you'll discover User Experience Design with the Office Fabric UI. Finally, you'll explore the specifics of building tables and charts. When you’re finished with this course, you'll have a foundational knowledge of Excel Add-ins that will help you as you move forward to building add-ins for your organization and the Microsoft Office Store.

About the author
About the author

John Brown is a Software Craftsman continually looking for intuitive designs, agile architectures, and streamlined processes. With degrees in Computer Science from Johns Hopkins and Aerospace Engineering from Purdue, John is always up for a challenge, especially in his areas of interest in Artificial Intelligence and Machine Learning.

More from the author
Ghost Blogging Engine: First Look
Intermediate
3h 32m
Mar 14, 2016
More courses by John Brown
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi, everyone. My name is John Brown and welcome to my course, Build Excel Add-ins with the Office JavaScript API. I am a software craftsman at Tritium Consulting and I love to build software with the latest technologies. Microsoft Office is one of the most well-known software products with over a billion users. Adding and extending Microsoft Office with add-ins can bring your products and services directly and conveniently to a huge number of users, allowing them to be more productive and happier. In this course, we are going to look at the new Excel object model that allows batch updates to Excel through the JavaScript proxy object. We will look at chaining requests to load properties through JavaScript promises. We will look at the new Office Fabric UI to build a compelling user experience. And, of course, we'll cover the features of Excel that we can leverage with the API. By the end of this course, you will know how to build an Excel add-in and perform all the basic interactions with Excel to build a compelling add-in. Before you start this course, you should watch the previous course on building Office add-ins with the Office JavaScript APIs. This course will build on that course and introduce the Excel object model with async programming. You should be familiar with JavaScript and HTML. You do not need to be an expert, though the more familiar you are with it, the easier it will be to build more complicated add-ins. I hope you will join me on this journey to learn about customizing and leveraging Excel.