Excel Add-Ins and Data Types
Offered By: Microsoft via YouTube
Course Description
Overview
Explore the latest enhancements and extensibility options for customizing the Excel grid and calculations engine in this 31-minute video from Microsoft Build 2022. Discover how to create custom data types containing images, entities, arrays, and formatted number values backed by custom data sources. Learn about the new API that enables developers to build custom functions utilizing these Excel Data Types as inputs and outputs. Gain insights into Office Add-ins, data type anatomy, feature integration, and APIs. Watch a demonstration of the new capabilities and hear from CCP Games about their integration of Excel add-ins in EVE Online. Understand how these advancements can increase developer velocity and enhance user experiences in data-driven applications.
Syllabus
Introduction.
Excel Addins and Data Types.
Agenda Chris Gross, Program Manager, Excel Team.
Office Addins.
Addin basics.
Data types.
Data types anatomy.
Data types feature integration.
Data sources.
Data types APIs.
Composable building blocks.
Increasing developer velocity.
New values API.
New additions added to APIs.
Demo.
Integrations CCP Games is doing with Excel addins.
Snorri Arnason, Director of Product, EVE Online, CCP Games.
Overview of EVE Online.
Data Overview.
Metagame.
Monthly Economic Report.
Public Data Access.
Player Use Cases.
Data Ecosystem.
The User Experience Addin Enabled.
User Experience EVE Metadata as Datatypes.
A look as a Power User.
Closing.
Taught by
Microsoft Developer
Tags
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity 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