Copilot - Generate formulas from a concept Video

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:02
7 views

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.

Copilot - Generate formulas from a concept Video

RELATED COURSES This video is part of the following courses

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

Microsoft Video Training Copilot - Discover and Learn to Use Microsoft Copilot