Microsoft 365 Copilot is an AI assistant to be had in in style Microsoft 365 apps like Word, Excel, and PowerPoint. It makes use of complicated language fashions, together with GPT-4o, and undertaking information from Microsoft Graph, which incorporates paperwork, shows, emails, recordsdata, conferences, and chats.

While Copilot in Excel already assists with duties like producing formulation, suggesting charts, and examining PivotTables, Microsoft just lately introduced a brand new function referred to as “Clean Data.” This permits customers to wash information with a unmarried click on, detecting and resolving commonplace problems reminiscent of textual content inconsistencies, quantity layout problems, and additional areas.

To use this selection, choose the “Clean Data” choice within the Data tab or make the most of the pop-up banner (see screenshot underneath).

Clean Data function will repair following information problems for now:

• Text inconsistencies: Identify neglected permutations throughout identical values that might motive next issues. For instance, a column with a mixture of uppercase and lowercase textual content within the cells; or cells in a column containing variations in punctuation or diacritics.

• Number layout inconsistency: This function seeks to spot columns with a mixture of each Text and Number formatted cells that might lead to wrong calculations. Clean Data will find those inconsistencies and can assist you to convert the ‘Text’ formatted cells to a bunch layout.

• Extra area elimination: Clean Data may even discover and recommend the elimination of useless areas within the highlighted desk – reminiscent of additional main areas, trailing areas, and between-value areas.

Clean Data works perfect with information formatted as an Excel desk, as much as 100 columns and 50,000 rows. To create an Excel desk, customers can click on anyplace within the information after which choose Home > Tables > Format as Table. Microsoft is now rolling out the brand new Copilot Clean Data function to Excel for the internet customers. Microsoft will roll out to Windows desktop customers within the coming months.