Excel - Generate Formulas with Copilot Tutorial

Discover how to generate formulas with Copilot in this intermediate tutorial. Despite being in preview status and currently requiring prompts in English, Copilot offers valuable formula writing assistance. Learn how to add a total column and explore suggested formulas with detailed explanations. Find out how Copilot can meet your formula needs!

2:07
102 views

Available in AI - Artificial Intelligence

00:00:02

Despite being in preview status and

00:00:04

currently requiring prompts in English,

00:00:06

the formula writing assistance offered

00:00:08

by Copilot is quite interesting.

00:00:09

Let's explore some examples together,

00:00:11

starting with a simple table in table mode.

00:00:14

With the Copilot pane active,

00:00:15

I can begin to prompt.

00:00:19

Let's start with adding a total column.

00:00:22

A formula is then suggested to

00:00:24

me with detailed explanations.

00:00:26

It meets my need, so I insert it directly.

00:00:30

Another requirement is adding an average.

00:00:35

I see in the proposal that the formula

00:00:37

is viable and that the total is of

00:00:40

course not included in the average.

00:00:42

Perfect Copilot can also suggest

00:00:44

formulas through prompt suggestions.

00:00:46

In this example, a column extracting

00:00:48

the maximum is suggested to me.

00:00:50

Again, I validate.

00:00:51

What if my request becomes

00:00:53

a bit more complex?

00:00:54

Let's check by asking for the

00:00:56

generation of a column showing

00:00:58

the percentage of each total value

00:01:00

in relation to the overall total.

00:01:03

Which isn't present in my table.

00:01:05

Once again, it's a success.

00:01:10

Is Copilot clever? Let's ask for

00:01:12

the addition of a VAT column.

00:01:16

Well spotted.

00:01:17

It proposes a formula multiplying the

00:01:19

total by the standard rate of 20%.

00:01:22

It's quite impressive to

00:01:23

challenge the assistant.

00:01:25

Let's attempt to manage a condition

00:01:27

specifying that all totals

00:01:29

beyond 100,000 will generate a

00:01:30

5% bonus for the salesperson,

00:01:32

otherwise a zero in the cell.

00:01:36

Yes, it can handle simple conditionals.

00:01:44

To conclude, let's stick with

00:01:45

the basic by adding a total line.

00:01:49

In this case, strangely it's more

00:01:51

mixed, but I can finalize by hand.

00:02:00

For my part, I consider Copilot's mission

00:02:01

to help me write formulas fulfilled.

DiLeaP AI: THIS MIGHT BE HELPFUL

Power BI - Creating a Report

In this video, you will learn how to produce and finalize reports remotely with your team using Microsoft 365. The video covers the Office 365 portal, Word online, and Skype for Business, demonstrating how these tools can help you collaborate and work on reports even when your team members are not in the same location.
This tutorial will provide you with the necessary skills to efficiently produce reports and collaborate with your team, enhancing your productivity and efficiency.

2:54
4681 views

Flow / Power Automate - Create automatic reminders

In this video, you will learn about creating automatic reminders using Microsoft 365. The video covers the process of setting up reminders and demonstrates how to use the Microsoft 365 tools to automate this task.
This will help you stay organized and never miss an important deadline or task.

4:10
3147 views

Excel - Concatenate text

In this video, you will learn about Microsoft365 and how it can enhance your productivity and collaboration.
The video covers the Office apps like Word, Excel, and PowerPoint, which allow you to be creative and work together securely.
You can save your files in the cloud with OneDrive, making them accessible from anywhere.
Microsoft365 also enables real-time sharing and collaboration with your coworkers, whether you're in the office or on the go.
With mobile apps and Office for the web, you can stay organized and connected on any device.
Using Microsoft365 will help you boost your productivity and work efficiently.

3:01
910 views

Teams Premium - Activate the features of Teams Premium

In this video, you will learn how to activate the features of Teams Premium.
The video covers the necessary steps to fully enjoy all that Teams Premium has to offer.
It explains that Teams Premium requires an additional paid license, which must be assigned to a user in Microsoft 365 administration.
The video demonstrates how to join the admin and access the team-specific admin center, where you can manage Teams settings such as meetings, webinars, messaging, and security.
It also highlights the administration app in the Teams navigation menu, which includes a dashboard with additional settings.
To access the new features specific to Teams Premium, you can find them directly in your Teams application.
If some features don't appear, it is recommended to restart Teams and check for software updates.
Activating Teams Premium will enhance your Teams experience and provide access to advanced features.

3:48
5173 views

Planner - Starting with planner

In this video, you will learn about starting with Microsoft Planner.
The video covers the basics of using Microsoft Planner to organize and prioritize your team's tasks.
You will discover how to create compartments to organize tasks and enrich them with documents, labels, or checklists.
This will help you better manage and track your collaborative work with precision.
By using Microsoft Planner, you can visualize deadlines, prioritize tasks, and optimize your personal work.
Additionally, the video explains how to integrate Microsoft Planner with other cross-functional applications, such as Microsoft Teams and Microsoft Outlook, to enhance your productivity.
This tutorial provides a comprehensive overview of getting started with Microsoft Planner and is perfect for beginners using Microsoft 365.

4:28
4096 views