The Automate tab is a gateway to another way of building smarter Excel sheets. It can handle the boring stuff so you can ...

Learn how GROUPBY passes both subset and full arrays into LAMBDA in Excel, letting you compute percent shares fast and explain results clearly.

Ever since Microsoft introduced Python in Excel, I have treated it as a ‘someday’ project. I knew Python integration was the ...

Custom pharmacy functions enabling a user to calculate patient metrics, lab values, and drug dosing. With the Pharmacy Function Library, you can perform commonly used clinical pharmacy calculations.

This application makes customer web service APIs from the Microsoft Machine Learning Server available for use as an Excel Add-in. When the add-in is loaded, users can authenticate with their deployed ...