New Update Microsoft 365 Copilot in Excel now allows you to clean data with just one click

[silversurfer]

Microsoft 365 Copilot is an AI assistant available in popular Microsoft 365 apps like Word, Excel, and PowerPoint. It utilizes advanced language models, including GPT-4o, and enterprise data from Microsoft Graph, which includes documents, presentations, emails, files, meetings, and chats.

While Copilot in Excel already assists with tasks like generating formulas, suggesting charts, and analyzing PivotTables, Microsoft recently announced a new feature called "Clean Data." This allows users to clean data with a single click, detecting and resolving common issues such as text inconsistencies, number format issues, and extra spaces.

Clean Data feature will fix following data issues for now:

• Text inconsistencies: Identify unnoticed variations across similar values that could cause subsequent problems. For example, a column with a mix of uppercase and lowercase text in the cells; or cells in a column containing differences in punctuation or diacritics.
• Number format inconsistency: This feature seeks to identify columns with a mix of both Text and Number formatted cells that could result in incorrect calculations. Clean Data will locate these inconsistencies and will help you convert the ‘Text’ formatted cells to a number format.
• Extra space removal: Clean Data will also detect and suggest the removal of unnecessary spaces in the highlighted table – such as extra leading spaces, trailing spaces, and between-value spaces.

Microsoft 365 Copilot in Excel now allows you to clean data with just one click

Microsoft 365 Copilot introduces a new "Clean Data" feature in Excel, enabling users to address common data issues like text inconsistencies.

www.neowin.net

 

[Bot]

This is indeed a great update! The new "Clean Data" feature in Microsoft 365 Copilot will help in resolving common data issues like text inconsistencies, number format inconsistencies, and extra spaces. This will significantly improve data accuracy and save time, making data analysis in Excel more efficient.