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

Objectifs :

Understand how to utilize Copilot for data analysis and calculations without needing to know specific formulas, while also learning how to enhance data tables efficiently.

Chapitres :

  1. Introduction to Copilot Assistance
    In today's fast-paced work environment, having tools that can assist with data analysis is crucial. Copilot is designed to help users who may not know specific formulas but have a clear idea of the outcomes they desire. This section will explore how to effectively communicate your needs to Copilot to achieve desired results.
  2. Explaining Your Needs to Copilot
    When you have a general idea of what you want to achieve, you can simply explain the concept to Copilot. For example, if you have a table and want to calculate the margin for each country based on a fixed monthly expenditure of 1000, you can ask Copilot directly. This approach allows you to bypass the need for precise formulas and complex calculations.
  3. Time-Saving Benefits of Using Copilot
    One of the significant advantages of using Copilot is the time it saves. Instead of spending hours figuring out calculations, Copilot can quickly provide a proposal based on your input. However, it is essential to remember that while Copilot can assist in generating results, users should still verify the accuracy of these results.
  4. Enhancing Data Tables with Copilot
    In a practical scenario, you may have a workbook with salespeople identified only by their IDs in one table, and a second table containing their names and cities. You can instruct Copilot to add columns with the names and cities of the salespeople. By using a simple prompt, Copilot can apply an 'ex look up' function to retrieve the necessary information and populate the new columns efficiently.
  5. Conclusion
    Utilizing Copilot for data analysis not only streamlines the process but also enhances productivity. By clearly communicating your needs and understanding how to leverage Copilot's capabilities, you can achieve accurate results without the burden of complex calculations. Always remember to verify the results to ensure data integrity.

FAQ :

What is Copilot and how does it work?

Copilot is a digital assistant that helps users perform tasks by interpreting their requests and providing relevant calculations or data. Users can describe what they need, and Copilot will generate results without requiring precise formulas.

Can Copilot perform calculations without knowing the exact formulas?

Yes, Copilot can assist with calculations even if you don't know the exact formulas. You simply need to explain the concept and desired outcome, and Copilot will provide a proposal based on your input.

How does Copilot retrieve data from different tables?

Copilot uses lookup functions to retrieve data from specified tables. For example, it can match IDs from one table with names and cities in another table, adding the relevant information in just one prompt.

Is it necessary to verify the results provided by Copilot?

Yes, while Copilot can generate results quickly, it is important to verify the accuracy of the results to ensure they meet your expectations and requirements.

What are the benefits of using Copilot for data analysis?

Using Copilot can save time by automating calculations and data retrieval, allowing users to focus on analysis rather than manual calculations. It enhances efficiency and productivity in data management tasks.

Quelques cas d'usages :

Sales Margin Calculation

A sales manager can use Copilot to quickly calculate the margin for each country based on a fixed monthly spending of $1000. By simply describing the task, Copilot generates the necessary calculations without requiring detailed formulas.

Data Integration from Multiple Tables

A data analyst can leverage Copilot to merge information from two separate tables—one containing salesperson IDs and another with their names and cities. By issuing a single prompt, Copilot can automatically add the relevant columns, streamlining the data integration process.

Time-Saving in Reporting

A project manager can utilize Copilot to generate reports that require complex calculations and data from various sources. By explaining the desired outcome, Copilot can provide quick insights, allowing the manager to focus on strategic decisions rather than data crunching.

Efficiency in Financial Forecasting

A financial analyst can use Copilot to assist in forecasting expenses by calculating potential margins based on different spending scenarios. This allows for rapid adjustments and scenario planning without getting bogged down in manual calculations.

Glossaire :

Copilot

A digital assistant or tool that helps users perform tasks by providing suggestions, calculations, or data retrieval based on user input.

Formula

A mathematical expression that calculates a value based on given variables. In this context, it refers to the specific calculations needed to derive results.

Margin

The difference between the cost of a product or service and its selling price, often expressed as a percentage of the selling price.

Lookup

A function or method used to retrieve data from a specific table or range based on a given criterion. In this context, it refers to the process of finding names and cities of salespeople based on their IDs.

Prompt

A command or request made to a digital assistant or software to perform a specific action or provide information.

résultat(s)
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.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:01
Quando não conhece a fórmula mas tem uma ideia do que espera.
00:00:05
O Copilot pode ajudá-lo
00:00:07
basta explicar o conceito ao co-piloto e qual o resultado que deseja.
00:00:12
Por exemplo, a partir de uma tabela simples,
00:00:15
Posso pedir ao Copilot que calcule a margem para cada
00:00:18
país considerando que cada país deve gastar 1000€ por mês.
00:00:22
Rapidamente.
00:00:23
O Copilot fornece uma proposta sem a necessidade de fórmulas precisas
00:00:27
nem me obriga a pensar em vários cálculos.
00:00:30
Isto poupa-nos um tempo precioso.
00:00:32
Apesar de não nos libertar da verificação dos resultados
00:00:37
num outro estilo
00:00:38
na mesma pasta de trabalho,
00:00:40
Tenho os resultados dos vendedores identificados apenas pelos seus ids
00:00:44
e numa segunda tabela,
00:00:46
Tenho os números, juntamente com os nomes e cidades dos vendedores.
00:00:50
Peço ao Copilot que acrescente colunas com os nomes e cidades dos vendedores
00:00:54
por si só.
00:00:55
O Copilot aplica uma pesquisa ex para recuperar o nome
00:00:57
e cidade em colunas separadas em apenas um prompt.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:01
Quando non conosci la formula ma hai un'idea di cosa ti aspetti.
00:00:05
Copilot può aiutarti
00:00:07
spiega semplicemente il concetto al copilota e quale risultato desideri.
00:00:12
Ad esempio, partendo da una semplice tabella,
00:00:15
Posso chiedere a Copilot di calcolare il margine per ciascuno
00:00:18
paese considerando che ogni paese deve spendere 1000€ al mese.
00:00:22
Rapidamente.
00:00:23
Copilot fornisce una proposta senza bisogno di formule precise da
00:00:27
né mi viene richiesto di elaborare vari calcoli.
00:00:30
Questo ci fa risparmiare tempo prezioso.
00:00:32
Anche se non ci esonera dalla verifica dei risultati
00:00:37
in un altro stile
00:00:38
nella stessa cartella di lavoro,
00:00:40
Ho i risultati dei venditori identificati solo dai loro ID
00:00:44
e in una seconda tabella,
00:00:46
Ho i numeri insieme ai nomi e alle città dei venditori.
00:00:50
Chiedo a Copilot di aggiungere colonne con i nomi e le città dei venditori
00:00:54
da solo.
00:00:55
Copilot applica una ricerca ex per recuperare il nome
00:00:57
e città in colonne separate in un solo prompt.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:01
Когда вы не знаете формулу, но имеете представление о том, чего ожидаете.
00:00:05
Второй пилот может помочь вам
00:00:07
просто объясните второму пилоту концепцию и желаемый результат.
00:00:12
Например, из простой таблицы
00:00:15
Я могу попросить Copilot рассчитать маржу для каждого
00:00:18
страна, считающая, что каждая страна должна тратить 1000 евро в месяц.
00:00:22
Быстро.
00:00:23
Copilot предоставляет предложение без использования точных формул от
00:00:27
я не требую от меня продумывания различных расчетов.
00:00:30
Это экономит нам драгоценное время.
00:00:32
Хотя это не освобождает нас от необходимости проверять результаты
00:00:37
в другом стиле
00:00:38
в той же рабочей тетради,
00:00:40
У меня есть результаты работы продавцов, идентифицированные только по их удостоверениям личности
00:00:44
и во второй таблице
00:00:46
У меня есть цифры, имена и города продавцов.
00:00:50
Я прошу Copilot добавить столбцы с именами и городами продавцов
00:00:54
само по себе.
00:00:55
Чтобы узнать имя, второй пилот применяет функцию ex-look
00:00:57
и город в отдельных столбцах всего за одну подсказку.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:01
Cuando no conoces la fórmula pero tienes una idea de lo que esperas.
00:00:05
Copilot puede ayudarle
00:00:07
simplemente explica el concepto al copiloto y el resultado que deseas.
00:00:12
Por ejemplo, a partir de una simple tabla,
00:00:15
Puedo pedirle a Copilot que calcule el margen de cada uno
00:00:18
país, teniendo en cuenta que cada país debe gastar 1000€ al mes.
00:00:22
Rápidamente.
00:00:23
Copilot ofrece una propuesta sin necesidad de fórmulas precisas de
00:00:27
ni me obliga a pensar en varios cálculos.
00:00:30
Esto nos ahorra un tiempo precioso.
00:00:32
Sin embargo, no nos exime de verificar los resultados
00:00:37
en otro estilo
00:00:38
en el mismo libro de trabajo,
00:00:40
Tengo los resultados de los vendedores identificados solo por sus identificaciones
00:00:44
y en una segunda tabla,
00:00:46
Tengo los números junto con los nombres y las ciudades de los vendedores.
00:00:50
Le pido a Copilot que añada columnas con los nombres y las ciudades de los vendedores
00:00:54
por sí mismo.
00:00:55
Copilot realiza una búsqueda ex para recuperar el nombre
00:00:57
y la ciudad en columnas separadas en un solo mensaje.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:01
Als je de formule niet kent maar wel een idee hebt van wat je verwacht.
00:00:05
Copilot kan u helpen
00:00:07
leg gewoon het concept uit aan de copiloot en welk resultaat je wenst.
00:00:12
Bijvoorbeeld vanuit een eenvoudige tabel
00:00:15
Ik kan Copilot vragen om de marge voor elk
00:00:18
land aangezien elk land €1000 per maand moet uitgeven.
00:00:22
Snel.
00:00:23
Copilot levert een voorstel zonder dat er precieze formules nodig zijn van
00:00:27
ik hoef me niet te verplichten verschillende berekeningen te overdenken.
00:00:30
Dit bespaart ons kostbare tijd.
00:00:32
Hoewel het ons niet ontslaat om de resultaten te verifiëren
00:00:37
in een andere stijl
00:00:38
in hetzelfde werkboek,
00:00:40
Ik heb de resultaten van de verkopers die alleen worden geïdentificeerd aan de hand van hun identificatiegegevens
00:00:44
en in een tweede tafel
00:00:46
Ik heb de nummers samen met de namen en steden van de verkopers.
00:00:50
Ik vraag Copilot om kolommen toe te voegen met de namen en steden van de verkopers
00:00:54
op zichzelf.
00:00:55
Copilot past een ex lookup toe om de naam op te halen
00:00:57
en stad in aparte kolommen in slechts één prompt.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:01
Kiedy nie znasz formuły, ale masz pojęcie, czego się spodziewasz.
00:00:05
Copilot może ci pomóc
00:00:07
po prostu wyjaśnij koncepcję kopilotowi i jakiego wyniku pragniesz.
00:00:12
Na przykład z prostego stołu,
00:00:15
Mogę poprosić Copilota o obliczenie marży dla każdego
00:00:18
kraj, biorąc pod uwagę, że każdy kraj musi wydawać 1000 euro miesięcznie.
00:00:22
Szybko.
00:00:23
Copilot przedstawia propozycję bez konieczności precyzyjnych formuł
00:00:27
Nie wymagam od mnie przemyślenia różnych obliczeń.
00:00:30
To oszczędza nam cenny czas.
00:00:32
Chociaż nie zwalnia nas to od weryfikacji wyników
00:00:37
w innym stylu
00:00:38
w tym samym skoroszycie,
00:00:40
Mam wyniki sprzedawców zidentyfikowanych tylko na podstawie ich identyfikatorów
00:00:44
a w drugim stole,
00:00:46
Mam numery wraz z nazwami i miastami sprzedawców.
00:00:50
Proszę Copilot o dodanie kolumn z nazwami i miastami sprzedawców
00:00:54
sama w sobie.
00:00:55
Copilot stosuje ex search up, aby odzyskać nazwę
00:00:57
i miasto w oddzielnych kolumnach w jednym monecie.

No elements match your search in this video....
Do another search or back to content !

 

résultat(s)
00:00:01
Ha nem ismeri a képletet, de van elképzelése arról, mire számít.
00:00:05
A Copilot segíthet
00:00:07
egyszerűen magyarázza el a koncepciót a copilot számára, és milyen eredményre vágyik.
00:00:12
Például egy egyszerű táblázatból,
00:00:15
Megkérhetem a Copilot-ot, hogy számolja ki az árrést mindegyikhez
00:00:18
ország, figyelembe véve, hogy minden országnak havonta 1000 eurót kell költenie.
00:00:22
Gyorsan.
00:00:23
A Copilot javaslatot nyújt anélkül, hogy pontos képletekre lenne szükség
00:00:27
nem is követeltem tőlem, hogy átgondoljam a különböző számításokat.
00:00:30
Ez drága időt takarít meg nekünk.
00:00:32
Bár ez nem mentesít minket az eredmények ellenőrzésétől
00:00:37
egy másik stílusban
00:00:38
ugyanabban a munkafüzetben,
00:00:40
Az értékesítők eredményeit csak az azonosítójuk alapján azonosították
00:00:44
és egy második táblázatban,
00:00:46
Megvannak a számok az eladók nevével és városaival együtt.
00:00:50
Arra kérem a Copilot, hogy adjon hozzá oszlopokat az értékesítők nevével és városaival
00:00:54
önmagában.
00:00:55
A Copilot előző keresést alkalmaz a név lekéréséhez
00:00:57
és a város külön oszlopokban egyetlen promptben.

No elements match your search in this video....
Do another search or back to content !

 

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

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

1484 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

An Error Has Occurred

Unable to save your progress. Please reload the page, log in, and try again. If the problem persists, please contact an administrator.

Close

Reminder

Show

/

Join Live Training Session