Microsoft Copilot (Microsoft 365): Copilot in Excel support for complex formula columns from multiple tables
Microsoft Copilot, part of Microsoft 365, now offers support for complex formula columns in Excel that bring together data from multiple tables. This feature allows users to utilize advanced formulas such as XLOOKUP and SUMIF, making it easier to create formula columns that merge data from multiple sources. The release is set for April CY2024, and the tool will be available on desktop and cloud platforms. This update is part of a series of improvements to Excel that aim to make data management more accessible and efficient for users. For more information, check out the official Microsoft roadmap.
The post Microsoft Copilot (Microsoft 365): Copilot in Excel support for complex formula columns from multiple tables appeared first on M365 Admin.
Published on:
Learn more
Related posts
Microsoft Copilot (Microsoft 365): Copilot in Excel – Graph Grounded Chat
Microsoft Copilot, part of Microsoft 365, can now be used in Excel through graph grounded chat. With Copilot, users can request answers based ...
How Does Xlookup Work in Excel? Step-by-Step Guide
Excel just got better with the introduction of the XLOOKUP function. This versatile tool allows you to easily locate and retrieve values withi...
What is a Spreadsheet in Excel? User Guide With Examples
For anyone looking to make the most of their data, Microsoft Excel's spreadsheet feature is a must-have tool. This versatile application provi...
Excel SUMIF: The Ultimate Guide
If you're an Excel user, the SUMIF function is one you'll definitely want in your toolbox. This powerful function allows you to sum cells base...
Power BI Copilot: Enhancing Data Analysis with AI Integration
If you're looking for an intelligent assistant to help you navigate your data analysis, then Power BI Copilot is the tool you need. This innov...
Excel Formulas Cheat Sheet: Intermediate Guide
Congratulations on mastering the basics of Excel! If you're ready to step up your game and delve into more advanced Excel features, this inter...
Excel Formulas Cheat Sheet: Advanced Guide
If you're ready to take on the world of advanced Excel formulas, you'll want to check out this cheat sheet. After tackling the basics and inte...
How to Show Formulas in Excel: A Complete Guide
Microsoft Excel is widely used for creating spreadsheets and performing calculations involving various formulas. Understanding how to access a...
Data Integration Tools in SSIS Integration Toolkit for Dynamics 365 2022 Release Wave 1
The SSIS Integration Toolkit for Microsoft Dynamics 365 has received a significant upgrade with over 428 improvements in data integration and ...