Platform Banner

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
172 views
Parteger

Description

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

E-learning Intermédiaire

Vu 2145 fois

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 creativity.

E-learning Débutant

Vu 71 fois

Copilot for Microsoft 365 : Excel

Leverage Copilot in Excel to analyze your data, generate formulas, and create impactful charts in one click.

ALL COURSES