Excel - Format Data with Copilot Video

Explore the possibilities of formatting Excel tables with Copilot. In this tutorial, learn how to invoke the Copilot pane, which offers immediate assistance in formatting data as a table. Perfect for intermediate users, Copilot for Microsoft Excel provides valuable features to enhance your data formatting experience.

1:52
777 views

00:00:04

we'll explore how co pilot can assist with Excel table formatting.

00:00:09

As soon as I open a workbook containing data,

00:00:12

I can access the copilot pane by clicking the icon in the ribbon.

00:00:18

The first step is to format the data as a table,

00:00:21

which is essential for more efficient analysis.

00:00:24

Now I want to adjust the rows and columns to fit the data properly.

00:00:29

After a brief moment, Copilot suggests the action, and all I need to do is apply it.

00:00:35

I can also request changes to the font size, giving my table a more polished look.

00:00:40

Next, I want to focus on highlighting specific values in my data.

00:00:44

For example,

00:00:45

I can ask copilot to highlight any null values in the table.

00:00:50

It even suggests formatting the top 10 values in the September column.

00:00:55

If the result isn't what I expected, I can easily undo the action and try again.

00:01:00

However, if I ask copilot to apply the same action across the entire table,

00:01:05

it processes each column individually.

00:01:08

This shows that while copilot can handle formatting tasks,

00:01:11

there are some limitations when it comes to consistency across tables.

00:01:15

Other formatting options,

00:01:16

such as applying data bars are also available

00:01:20

and can be useful for quick visual insights,

00:01:22

something I rely on regularly

00:01:25

in summary copilot is capable of managing certain formatting tasks,

00:01:29

but as of now it doesn't provide a dramatic improvement over manual formatting.

RELATED COURSES This video is part of the following courses

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.

Your trainer for this course
Cours E-learning

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

Your trainer for this course
Cours E-learning

831 Views

ALL COURSES