Have you noticed the 'Clean Data' button in Excel yet?
New way to 'Clean Data' button in Excel!
It’s sitting on the Data tab and it’s far more powerful than it looks.
When you click 'Clean Data', Excel Copilot scans your table and flags common issues such as:
-Inconsistent order numbers or IDs
-Values formatted slightly differently (for example, $12.5 vs $12.50)
-Patterns that don’t quite line up and could cause issues with sorting, filtering, or reporting
Copilot explains what it’s found in plain language and then gives you a simple choice: 'Apply or Ignore'.
If Excel is part of your everyday work, the Clean Data button is well worth a look.
excel copilot digitalwaysofworking Microsoft365
Keen to stay up to date on anything 365?
Sign up for tips and updates
You may also like
365 Productivity
How to use Sparklines in Excel
Go to the Insert Ribbon and select the Sparkline you wish to use - Microcharts contained in one cell can help give you a quick visual to analyse data.
365 Productivity
How to use Shortcut Keys for Privacy and Security?
Here are two simple but powerful keyboard shortcuts to help keep your information safe, especially in busy office environments.
365 Productivity
How to set your 'Out of Office' in Outlook
Before you head away for a long weekend - be sure to set your 'Out of Office' up in Outlook. Anytime someone emails you, they will get an automatic reply. You can even set one for Internal emails and another for External replies.