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
Copilot
Copilot and Dog Tricks
AI technology can be a game-changer in how we interact with our pets. It can analyse patterns in your dog's behavior and suggest new tricks tailored to their learning style.
365 Productivity
Outlook Timezones
Working with people in different time zones can be tricky. Even with a simple two-hour difference, use this tip so you can also be mindful of where your overseas colleagues are at.
Copilot
Modernise Construction Site Incident Reporting with Microsoft Forms and Copilot
Learn how construction companies can replace paper-based incident reporting with Microsoft Forms and Copilot. Improve safety reporting, capture photos instantly, and reduce admin time.Â