Loading...

Microsoft Copilot (Microsoft 365): Copilot in Excel support for complex formula columns from multiple tables

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
M365 Admin
M365 Admin

by João Ferreira

Share post:

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 ...

3 months ago

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...

8 months ago

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...

9 months ago

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...

1 year ago

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...

1 year ago

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...

1 year ago

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...

1 year ago

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...

1 year ago

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 ...

1 year ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy