Using a custom function in Excel
Machine Learning functions
Machine Learning functions can be created by AI developers, including data scientists and other experts. The functions are each based on a service that calculates or predicts values with a machine learning model. Once the model is deployed, the creators can enable it for anyone they choose. Within a company, administrators can configure who has access to which proprietary functions. Then, every time someone wants to run the function, they simply type in a cell, just like for any other Excel function. The function calls a live web service on the company’s Azure subscription and returns the result asynchronously.
There are many useful function types developers can enable with Machine Learning, such as:
Here are some examples of Custom Visuals that exist today:
Examples from rich third-party ecosystem of Power BI Custom Visuals in Excel.
Custom Visuals provide several key benefits that make them an appealing choice for data visualization development in Excel including:
Customs Visuals live with other Excel charts. Visuals acquired from the store, or those deployed by an Office 365 administrator, will automatically appear here. The store for Custom Visuals can also be launched from here Note, these visuals are just examples of the types of visuals in the Office App Store.
Excel provides a tailored view of the Office App Store that lets you focus on just the Custom Visuals. Note, the example visuals shown here are existing Custom Visuals for Power BI and may not all be available in Excel.
The task pane helps users connect their Custom Visuals to spreadsheet data, as well as configure settings on the visual. The same task pane appears for all visuals, making the user experience easy and familiar for users across all visuals.
The combination of a more tightly integrated experience together with a customized store and a consistent UX, will give data visualization developers maximum reach to their audience. For more information, visit API documentation for Custom Visuals to get started today writing visuals for Power BI. Visit the Custom Visuals Store to see what kinds of visuals are currently offered.
With this integration, users can create, manage, and most importantly run automated workflows on Excel tabular data. Via Flow, users will be able to send data from their spreadsheets hosted in SharePoint and OneDrive for Business to a wide range of services such as Teams, Dynamics 365, Visual Studio Online, Twitter, etc. The integration will first be shipped as an add-in in the Office Store and will become an in-the-box component later this year.
These new capabilities are the result of continuous innovation to make Excel a more flexible and intuitive data analysis tool and expand developer opportunities. To stay connected to Excel and its community, read Excel blog posts, and send us ideas and suggestions for the next version of Excel through our UserVoice. You can also follow Excel on Facebook and Twitter.
JS custom functions for Excel is available now in Developer Preview to Office 365 subscribers enrolled in the Office Insiders program. Azure Machine Learning functions and Power BI Custom Visuals will be rolling out in preview soon—stay posted @OfficeDev
Interested developers can sign up here to get updates as custom visuals becomes available.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.