Sourcetable’s AI agents can fetch data from cloud services and databases, then write code to analyze it—all from a familiar ...

Web queries offer a handy way to import data from selected tables into a worksheet--but Excel isn't as accommodating as it should be, especially when it comes to parameters. These tricks will let you ...

JavaScript isn't replacing Office macros anytime soon, but the Office Web apps (and the SharePoint-based enterprise equivalents) are improving regularly. For users that means simple but useful ...

Excel is probably Microsoft’s most popular developer tool. With a built-in functional programming language that now supports lambdas and variables, Excel has become a tool that people build businesses ...

After a relatively short beta, Microsoft today announced that the Excel API — a way for developers to programmatically use Excel for Office 365 for doing calculations, building dashboards and more — ...