Excel - Generate Formulas with Copilot Tutorial

Discover how to generate formulas with Copilot in this intermediate tutorial. Despite being in preview status and currently requiring prompts in English, Copilot offers valuable formula writing assistance. Learn how to add a total column and explore suggested formulas with detailed explanations. Find out how Copilot can meet your formula needs!

  • 2:07
  • 491 views
00:00:02
Despite being in preview status and
00:00:04
currently requiring prompts in English,
00:00:06
the formula writing assistance offered
00:00:08
by Copilot is quite interesting.
00:00:09
Let's explore some examples together,
00:00:11
starting with a simple table in table mode.
00:00:14
With the Copilot pane active,
00:00:15
I can begin to prompt.
00:00:19
Let's start with adding a total column.
00:00:22
A formula is then suggested to
00:00:24
me with detailed explanations.
00:00:26
It meets my need, so I insert it directly.
00:00:30
Another requirement is adding an average.
00:00:35
I see in the proposal that the formula
00:00:37
is viable and that the total is of
00:00:40
course not included in the average.
00:00:42
Perfect Copilot can also suggest
00:00:44
formulas through prompt suggestions.
00:00:46
In this example, a column extracting
00:00:48
the maximum is suggested to me.
00:00:50
Again, I validate.
00:00:51
What if my request becomes
00:00:53
a bit more complex?
00:00:54
Let's check by asking for the
00:00:56
generation of a column showing
00:00:58
the percentage of each total value
00:01:00
in relation to the overall total.
00:01:03
Which isn't present in my table.
00:01:05
Once again, it's a success.
00:01:10
Is Copilot clever? Let's ask for
00:01:12
the addition of a VAT column.
00:01:16
Well spotted.
00:01:17
It proposes a formula multiplying the
00:01:19
total by the standard rate of 20%.
00:01:22
It's quite impressive to
00:01:23
challenge the assistant.
00:01:25
Let's attempt to manage a condition
00:01:27
specifying that all totals
00:01:29
beyond 100,000 will generate a
00:01:30
5% bonus for the salesperson,
00:01:32
otherwise a zero in the cell.
00:01:36
Yes, it can handle simple conditionals.
00:01:44
To conclude, let's stick with
00:01:45
the basic by adding a total line.
00:01:49
In this case, strangely it's more
00:01:51
mixed, but I can finalize by hand.
00:02:00
For my part, I consider Copilot's mission
00:02:01
to help me write formulas fulfilled.

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

 

DiLeaP AI: THIS MIGHT BE HELPFUL

Reminder

Show