Copilot in Excel debuts two new complex formulas to manage multiple tables

The new functions will be added by the end of April.

2 min. read

Published onApril 10, 2024

published onApril 10, 2024

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

It’s been a while since Copilot made its introduction in Excel, but Microsoft has made sure to update the AI tool regularly, with useful features.

Some of these features are the addition of formulas to Copilot that make the AI tool comprehend, edit, and come up with complex solutions to manage data from dozens of tables, effectively enhancing productivity, and coming up with solutions to a variety of inputs.

A couple of new formulas are slated to be added to Copilot in Excel this month, according to the latest entry in theMicrosoft 365 Roadmap. Copilot will support the XLOOKUP and SUMIF formulas which allow the AI model to look up for certain data faster, and sum it up according to the input received from users.

TheXLOOKUPfunction is used in Excel to find things in a table or range by row. TheSUMIFfunction is used to sum the values in a range that meets the criteria that users specify. Copilot will now be able to use these functions.

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

The two functions should be available to use by the end of the month, according to the roadmap. However, if you haven’t tried Copilot in Excel yet, maybe this is the sign to do it. We havea comprehensive guideon everything you need to know to start using it.

You can use it to ease your work, but if you don’t know where to start,here are 4 waysyou can use this AI assistant.

You can edit, create tables, ask Copilot to validate and verify data, and even retrieve data from you from other platforms, such as Word, or PowerPoint. The AI assistant can also be used to summarize information, and in Excel that can be quite useful in reports.

Microsoft is also releasing aCopilot Adoption Communityfor organizations to teach their employees how to use Copilot at work. If you haven’t used it before, maybe you should wait until your organization opens up the community.

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low#

Copilot in Outlook will generate personalized themes for you to customize the app#

Microsoft will raise the price of its 365 Suite to include AI capabilities#

Death Stranding Director’s Cut is now Xbox X|S at a huge discount#

Outlook will let users create custom account icons so they can tell their accounts apart easier#

Copilot in Excel debuts two new complex formulas to manage multiple tables#

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Copilot in Excel debuts two new complex formulas to manage multiple tables