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

Available in AI - Artificial Intelligence

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.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

500 Views

Video Training - The Latest Updates on Microsoft Copilot

Stay ahead of the curve with our continuously updated Microsoft Copilot training. Discover the latest features and learn how to optimize you...

1746 Views

Microsoft Video Training Copilot - Discover and Learn to Use Microsoft Copilot

Master Microsoft Copilot in Microsoft 365 with our video training. Discover how AI can transform your work, enhancing productivity and creat...

1527 Views

Microsoft Video Training Copilot - Analyzing Your Data and Presenting with Copilot

Discover how to analyze data and create impactful presentations with Microsoft Copilot. Learn to use AI for informed decisions.

ALL COURSES