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

Product:

Copilot, Microsoft 365 Apps

Platform:

Mac, Web, Windows Desktop, World tenant

Status:

Launched

Change type:

Links:

Details:

Utilize complex formulas such as XLOOKUP and SUMIF to create formula columns bringing together data from multiple tables.

Change Category:
XXXXXXX ... free basic plan only

Scope:
XXXXXXX ... free basic plan only

Release Phase:
General Availability

Created:
2024-04-10

updated:
2024-06-18

Docu to Check

XXXXXXX ... free basic plan only

MS workload name

XXXXXXX ... free basic plan only

Direct effects for Operations**

- Direct Impact on IT Operations
- Increased demand for training and support resources
- IT administrators will need to provide guidance on the new features and functionalities of Copilot in Excel, particularly for complex formulas.
- Potential need for additional documentation and training sessions to ensure users can effectively utilize the new capabilities.
- Roles impacted: IT Support Staff, Training Coordinators, IT Administrators.
- Changes in data management and integration processes
- The introduction of complex formulas may require adjustments in data governance policies and practices to ensure data integrity and accuracy.
- Dependencies on existing data sources and systems may need to be evaluated to ensure compatibility with the new features.
- Roles impacted: Data Analysts, Database Administrators, IT Operations Managers.

- Direct Impact on IT Services
- Potential performance issues with Excel and related services
- The use of complex formulas may lead to increased processing times, affecting user experience and productivity.
- IT services may need to monitor performance metrics closely to identify and address any bottlenecks or issues arising from the new functionalities.
- Roles impacted: IT Operations Analysts, Service Desk Technicians.
- Integration challenges with other Microsoft 365 services
- The new Copilot features may require updates or changes to existing workflows and integrations with other Microsoft 365 applications (e.g., Power BI, SharePoint).
- Dependencies on third-party applications that interact with Excel may also need to be assessed for compatibility with the new features.
- Roles impacted: Application Developers, Integration Specialists, IT Project Managers.

References:
- Microsoft Copilot Overview: https://www.microsoft.com/en-us/microsoft-365/copilot
- Excel Functions and Formulas: https://support.microsoft.com/en-us/excel-functions-and-formulas
- Microsoft 365 Integration: https://www.microsoft.com/en-us/microsoft-365/integrate-apps