Platform Banner

Copilot (licence) - 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!

00:58
1896 views

Available in AI - Artificial Intelligence

00:00:05

now accessible directly through the right click menu in Excel.

00:00:09

This feature allows you to take advantage

00:00:11

of powerful tools to optimize your workflow.

00:00:15

To begin,

00:00:16

the ask co-pilot option opens an intuitive sidebar,

00:00:20

letting you interact directly with this intelligent assistant.

00:00:23

You can ask questions and explore its capabilities to improve your task.

00:00:27

One standout feature of copilot is its ability to suggest formula columns.

00:00:32

By automatically analyzing your table,

00:00:35

copilot offers relevant indicators to add.

00:00:38

For instance,

00:00:38

it might suggest adding a column for total revenue by salesperson.

00:00:42

While giving you the flexibility to request alternative suggestions if needed.

00:00:47

This adaptability allows you to tailor

00:00:49

its recommendations to your specific requirements.

00:00:52

Additionally,

00:00:53

co-pilot excels at conditional formatting.

00:00:57

After analyzing your data,

00:00:59

it generates suitable suggestions

00:01:01

such as highlighting cells in the product.

00:01:03

When region cells start with N

00:01:06

or marking cells above average in column units sold.

00:01:09

Once you select an option,

00:01:11

copilot automatically constructs the necessary formula and applies it,

00:01:16

making the process seamless and efficient.

00:01:20

For deeper insights,

00:01:21

co-pilot can create summaries in the form of pivot

00:01:23

tables or charts based on the available data.

00:01:27

For example,

00:01:27

it might generate a summary of sales by segment

00:01:30

and provide a clear overview for you to review.

00:01:33

You can also add the pivot table to a new sheet if needed,

00:01:36

simplifying data visualization and communication.

00:01:42

Moreover,

00:01:43

co-pilot serves as a valuable learning tool.

00:01:46

By selecting the teach me something option,

00:01:48

you can explore useful formulas,

00:01:51

such as a V lookup and understand their importance within the context of your table.

00:01:57

Co-pilot focuses on explaining the formula,

00:02:00

leaving the implementation in your hands for maximum control.

00:02:04

If you're working with formulas created by others and need clarification,

00:02:08

co-pilot offers detailed explanations.

00:02:11

It contextualizes each formula and clarifies its role in your table,

00:02:15

allowing you to navigate pre-existing data with greater confidence.

00:02:20

Finally,

00:02:21

for advanced analysis,

00:02:22

copilot enables you to leverage the Python programming language.

00:02:26

This feature lets you start sophisticated analyses in a new sheet

00:02:30

while benefiting from practical suggestions provided in the right hand sidebar.

00:02:34

With these functionalities,

00:02:36

co-pilot helps you optimize data usage,

00:02:38

saving you significant time and simplifying even the most complex tasks.

00:02:44

Experience its capabilities and make the

00:02:46

most of this powerful integrated assistant.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

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

1567 Views

Microsoft Video Training Copilot - Analyzing Your Data and Presenting with Copilot

Discover how to analyze data and create impactful presentations with Microsoft Copilot. Learn to use AI for informed decisions.

ALL COURSES