Platform Banner

Copilot (licence) - Generate formulas from a concept Tutorial

Struggling to find formulas? With 1Copilot, simply explain your concept and desired outcome. For example, calculate margins for each country spending 1000 per month. Copilot saves time by providing proposals without precise formulas, adding columns with names and cities effortlessly. Watch to uncover more time-saving features!

01:03
482 views

Available in AI - Artificial Intelligence

00:00:05

Copilot can assist you

00:00:07

simply explain the concept to copilot and what outcome you desire.

00:00:12

For instance, from a simple table,

00:00:15

I can ask Copilot to calculate the margin for each

00:00:18

country considering that each country must spend €1000 per month.

00:00:22

Quickly.

00:00:23

Copilot provides a proposal without needing precise formulas from

00:00:27

me nor requiring me to think through various calculations.

00:00:30

This saves us precious time.

00:00:32

Although it doesn't relieve us from verifying the results

00:00:37

in another style

00:00:38

in the same workbook,

00:00:40

I have the results of the salespeople identified only by their ids

00:00:44

and in a second table,

00:00:46

I have the numbers along with the names and cities of the salespeople.

00:00:50

I ask Copilot to add columns with the names and cities of the salespeople

00:00:54

by itself.

00:00:55

Copilot applies an ex look up to retrieve the name

00:00:57

and city in separate columns in just one prompt.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

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

1811 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