Excel - Generate Formulas with Copilot Video

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
838 views

00:00:05

customer orders from around the world for 2023.

00:00:09

This data includes details like country carrier, customer information,

00:00:14

order amounts and quantities.

00:00:16

In a previous tutorial, we saw how copilot can generate pivot tables.

00:00:21

Now let's explore how to create pivot charts.

00:00:24

First, I'll generate a column chart to represent the total sales volume by country.

00:00:29

Watch as copilot works in the conversation pane

00:00:32

and then offers to insert a results sheet.

00:00:35

This sheet contains both the pivot table and the corresponding chart.

00:00:39

Keep in mind any further customization of the pivot, table or chart,

00:00:43

like adjusting styles or formatting

00:00:46

must be done manually by the user.

00:00:49

Next,

00:00:49

let's request a pie chart to show the number

00:00:52

of orders grouped by courier or delivery company.

00:00:55

Just like before,

00:00:56

Copilot generates a chart alongside a table ready for me to adjust manually,

00:01:01

such as adding a legend for the data labels.

00:01:05

We can also create line charts, which is perfect for illustrating trends over time.

00:01:11

For example,

00:01:12

I'll request a line chart to visualise revenue growth throughout the year.

00:01:17

Once again, the chart is generated with a table for easy modification

00:01:22

copilot for Excel simplifies the process of data visualisation,

00:01:26

making it easy to analyse data even if you're not an Excel expert.

Excel - Generate Formulas 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