Microsoft unveils agentic Copilot Cowork, a Microsoft 365 feature using Claude technology to execute workplace tasks and automate workflows.

AI tools are frequently used in data visualization — this article describes how they can make data preparation more efficient ...

Don't let Excel move on without you.

Excel to SQLite simplifies the process of importing Excel data into SQLite databases. It provides automatic schema detection, data transformations, validation rules, and includes an intelligent ...

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...

Microsoft Excel’s new COPILOT function lets users generate, summarize, and analyze data directly in spreadsheet cells using plain-language prompts. (Microsoft Image) Microsoft is building generative ...

Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might expect that pivot tables—which can be used to summarize rows and columns of ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Cory Benfield discusses the evolution of ...

Create a report using charts: Select Insert > Recommended Charts, then choose the one you want to add to the report sheet. Create a report with pivot tables: Select Insert > PivotTable. Select the ...

Would you like to make your Excel spreadsheet and data management smoother, more efficient, and less error-prone? Excel tables have transformed data management, offering a wide range of features that ...