Copilot - Process text Tutorial

Unlock the power of Excel with Co-Pilot! Discover how to easily analyze customer reviews, summarize comments, and identify key sentiments in seconds. This video showcases innovative features that save you time, allowing you to focus on insights, not just data. Don’t miss out on transforming your workflow!

01:03
169 views

Available in AI - Artificial Intelligence

00:00:07

qualitatively analyze text within your workbooks.

00:00:12

Let's take an example.

00:00:13

I have a workbook containing fictional customer

00:00:16

reviews from an online learning platform.

00:00:20

The data was extracted into Excel and includes usernames,

00:00:24

dates,

00:00:24

and customer comments.

00:00:27

I opened the co-pilot pane

00:00:29

and ask it to summarize the comments.

00:00:32

Within seconds,

00:00:33

it provides a structured summary of the reviews.

00:00:36

Grouped by topic.

00:00:39

That's already very useful,

00:00:40

but I want to go further and identify both positive and negative points.

00:00:45

I asked co-pilot

00:00:47

And it instantly generates this analysis for me.

00:00:51

This feature saves valuable time by eliminating the

00:00:54

need for a separate text analysis tool,

00:00:56

providing a simple and efficient solution directly within Excel.

00:00:05

O Co-piloto no Excel fornece ferramentas avançadas para

00:00:07

analisar qualitativamente o texto dentro das suas cadernetas de trabalho.

00:00:12

Vamos dar um exemplo.

00:00:13

Tenho uma pasta de trabalho contendo cliente fictício

00:00:16

avaliações de uma plataforma de aprendizagem online.

00:00:20

Os dados foram extraídos para Excel e incluem nomes de utilizador,

00:00:24

datas,

00:00:24

e comentários dos clientes.

00:00:27

Abri o painel do co-piloto

00:00:29

e peço-lhe que resuma os comentários.

00:00:32

Em segundos,

00:00:33

fornece um resumo estruturado das revisões.

00:00:36

Agrupados por tópico.

00:00:39

Isso já é muito útil,

00:00:40

mas quero ir mais longe e identificar pontos positivos e negativos.

00:00:45

Perguntei ao co-piloto

00:00:47

E gera-me instantaneamente esta análise.

00:00:51

Esta funcionalidade poupa um tempo valioso, eliminando o

00:00:54

necessidade de um instrumento separado de análise de texto,

00:00:56

fornecendo uma solução simples e eficiente diretamente no Excel.

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

ALL COURSES