Copilot - Use Copilot with Right-Click Tutorial

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

Available in AI - Artificial Intelligence

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.

00:00:02

O clique direito no Excel também integra o copiloto,

00:00:05

oferecendo várias funções.

00:00:07

Em primeiro lugar,

00:00:08

Pergunte ao co-piloto abre o painel lateral onde pode interagir diretamente com ele.

00:00:13

Mas as funções mais interessantes são

00:00:16

sugerir uma coluna de fórmulas,

00:00:17

o co-piloto analisa a tabela e sugere indicadores relevantes a acrescentar.

00:00:22

Por exemplo,

00:00:23

aqui sugere uma coluna de receitas totais.

00:00:26

Isto é apenas uma proposta,

00:00:28

e posso pedir outras sugestões, se necessário.

00:00:32

Sugerir formatação condicional.

00:00:34

Co-piloto analisa os dados

00:00:36

e oferece uma lista de opções de formatação potencialmente relevantes.

00:00:40

Por exemplo,

00:00:41

realçar as células na data em que as engrenagens são superiores a 545.000.

00:00:47

Opto por destacar datas anteriores a 1 de outubro,

00:00:49

2013.

00:00:51

O co-piloto constrói a fórmula e só preciso de a aplicar.

00:00:55

Simples e eficaz.

00:00:58

Resumir utilizando uma tabela ou gráfico de dinamização.

00:01:01

Dependendo dos dados disponíveis,

00:01:03

o copiloto gera uma tabela de pivô.

00:01:05

Por exemplo,

00:01:06

sugere um resumo das vendas por segmento com

00:01:09

um resumo e a opção de visualizar o resultado.

00:01:12

Se necessário,

00:01:13

Posso acrescentar a tabela pivô a uma nova folha.

00:01:17

Ensina-me algo sobre o Excel.

00:01:19

O co-piloto ajuda-o a aprender o Excel selecionando esta opção.

00:01:23

O co-piloto apresentará uma fórmula e explicará a sua relevância em

00:01:26

o contexto da sua tabela e como implementá-la.

00:01:29

Desta vez,

00:01:30

no entanto,

00:01:31

não sugerirá inseri-lo no quadro.

00:01:34

No nosso caso,

00:01:35

mostra-me como construir uma pesquisa V.

00:01:38

Graças a estas funcionalidades,

00:01:39

O co-piloto ajuda-o a explorar plenamente os seus dados e a poupar tempo na sua análise.

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This tutorial is part of the following courses

216 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

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

ALL COURSES