Excel - Clean Up a Table with Copilot Tutorial

Transform your data management with our guide on 'Clean Up a Table with Copilot'. Discover how Copilot swiftly identifies and corrects inconsistencies in your Excel tables, from text variations to formatting issues. This simple yet powerful tool saves you time and enhances data reliability. Get ready to streamline your workflow!

  • 01:33
  • 27 views

 

00:00:08
but it's an essential step in getting the most out of a table.
00:00:12
Fortunately,
00:00:12
co-pilot can help us clean up the data in a quick and guided way.
00:00:16
Let's take this example
00:00:18
an array containing several inconsistencies.
00:00:22
As soon as I open it,
00:00:23
copilot offers me an automatic analysis
00:00:26
and tells me the number of suggested corrections.
00:00:29
What kinds of adjustments can he make?
00:00:33
First,
00:00:33
he identifies textual inconsistencies.
00:00:36
Here the names of countries are not uniform.
00:00:39
Co-pilot identifies the differences and allows me to
00:00:42
choose the right spelling with one click.
00:00:45
It also recognizes variants such as USA and United States of America.
00:00:50
However,
00:00:50
it does not handle machine translations,
00:00:53
for example,
00:00:54
between Germania and Germany.
00:00:56
Then it detects format inconsistencies,
00:01:00
especially when some cells are in text instead of numbers.
00:01:03
Co-pilot identifies these anomalies and offers to correct them.
00:01:07
It can also remove unnecessary spaces.
00:01:10
Which are often invisible
00:01:12
but which disturb filters and calculations,
00:01:16
each suggestion can be validated individually,
00:01:19
which allows me to keep full control over the cleaning of my board.
00:01:24
A simple,
00:01:25
effective solution
00:01:26
and above all very useful to make your data reliable
00:01:30
without spending hours on it.

No elements match your search in this video....
Do another search or back to content !

 

Mandarine AI: WHAT YOU SHOULD KNOW

Reminder

Show