Excel - Format Data with Copilot Tutorial

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
  • 455 views
00:00:02
In this tutorial, let's explore
00:00:04
what's possible with Copilot in
00:00:06
terms of formatting Excel tables.
00:00:08
Please note Copilot for Microsoft
00:00:09
Excel is still in preview,
00:00:11
Therefore, the features may be
00:00:13
more limited and less reliable.
00:00:15
Upon opening a workbook containing data,
00:00:17
I invoke the Copilot pane by
00:00:19
clicking on the ribbon icon.
00:00:21
The assistant then immediately
00:00:23
offers to format as a table.
00:00:28
Here I want to widen the column rows after a
00:00:31
brief weight the action has been completed.
00:00:33
And a summary of what was done is provided.
00:00:36
We can notice that the width of the
00:00:39
columns might be a bit exaggerated.
00:00:41
We are in a preview and it's not
00:00:43
yet possible to be too precise
00:00:45
without risking an unexpected result.
00:00:47
That's why here I manually adjust
00:00:48
the width to height ratio.
00:00:50
Nevertheless, I can further request
00:00:52
an adjustment to the font size,
00:00:54
which works correctly.
00:00:54
Still with the aim of formatting my data.
00:00:57
I want to highlight the null
00:00:59
values in my table.
00:01:00
I express my prompt in English
00:01:02
and Copilot executes by
00:01:03
applying conditional formatting,
00:01:04
not just a simple background color.
00:01:07
The suggested prompts allow me to request,
00:01:09
as here, a bold highlight of the
00:01:11
first column of the table.
00:01:13
If the result is not satisfactory,
00:01:15
I can of course cancel.
00:01:18
I would now like to bold highlight
00:01:20
the top ten values in my table.
00:01:22
Copilot understands,
00:01:23
but applies it to each column individually.
00:01:25
I'll leave it up to you to decide
00:01:27
whether to attribute this to the prompt
00:01:29
given or to the fact that we're in a
00:01:33
preview version of Copilot for Excel.
00:01:35
Other effects can be applied,
00:01:37
like data bars, which I use quite regularly.
00:01:39
In short, Copilot can handle
00:01:41
certain formatting effects,
00:01:42
but for the moment it doesn't offer
00:01:44
a convincing improvement on this
00:01:46
point compared to manual formatting.
00:01:48
Let's give it some time.

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

 

DiLeaP AI: THIS MIGHT BE HELPFUL

Reminder

Show