Copilot - Use Copilot with Right-Click Video

Unlock the power of CoPilot in Excel with right-click functionality! Discover how it suggests formulas, analyzes data, and offers insights like total cost by date. This video showcases smart features that streamline your data analysis and visualization. Don’t miss out on maximizing your efficiency with CoPilot!

01:45
891 views

Copilot - Use Copilot with Right-Click
- 01:45
- Viewed 891 times

00:00:05

offering several functions.

00:00:07

First,

00:00:08

Ask co-pilot opens the side panel where you can interact directly with it.

00:00:13

But the most interesting functions are

00:00:16

suggest a formula column,

00:00:17

co-pilot analyzes the table and suggests relevant indicators to add.

00:00:22

For example,

00:00:23

here it suggests a total revenue column.

00:00:26

This is just a proposal,

00:00:28

and I can ask for other suggestions if needed.

00:00:32

Suggest conditional formatting.

00:00:34

Co-pilot analyzes the data

00:00:36

and offers a list of potentially relevant formatting options.

00:00:40

For example,

00:00:41

highlight cells in date when cogs are greater than 545,000.

00:00:47

I choose to highlight dates prior to October 1st,

00:00:49

2013.

00:00:51

Co-pilot builds the formula and I just need to apply it.

00:00:55

Simple and effective.

00:00:58

Summarize using a pivot table or chart.

00:01:01

Depending on the available data,

00:01:03

copilot generates a pivot table.

00:01:05

For example,

00:01:06

it suggests a summary of sales by segment with

00:01:09

a summary and the option to view the result.

00:01:12

If necessary,

00:01:13

I can add the pivot table to a new sheet.

00:01:17

Teach me something about Excel.

00:01:19

Co-pilot helps you learn Excel by selecting this option.

00:01:23

Co-pilot will display a formula and explain its relevance in

00:01:26

the context of your table and how to implement it.

00:01:29

This time,

00:01:30

however,

00:01:31

it will not suggest inserting it into the table.

00:01:34

In our case,

00:01:35

it shows me how to construct a V lookup.

00:01:38

Thanks to these features,

00:01:39

co-pilot helps you fully exploit your data and save time in analyzing them.

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This video is part of the following courses

1279 Views

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

195 Views

Video Training - The Latest Updates on Microsoft Copilot

Stay ahead of the curve with our continuously updated Microsoft Copilot training. Discover the latest features and learn how to optimize you...

Cours E-learning

ALL COURSES