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

Excel - Format Data with Copilot Video

RELATED COURSES This video is part of the following courses

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

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