Excel - Generate a Chart with Copilot Tutorial

Learn how to generate a chart with Copilot in this intermediate tutorial. Using data extraction from customer orders around the world, discover how to create a pivot chart to represent overall sales volume by country. Join us to explore the power of Copilot in visualizing data!

1:34
913 views

Available in AI - Artificial Intelligence

00:00:02

I have access to a data extraction

00:00:04

relating to customer orders from

00:00:06

around the world in 2023 containing

00:00:09

various information including country,

00:00:11

carrier, client amounts and quantities.

00:00:13

As we've seen in another tutorial,

00:00:15

Copilot can generate pivot tables.

00:00:17

Now let's see how to generate pivot charts.

00:00:20

To start, I wish to create

00:00:22

a histogram representing the

00:00:24

overall sales volume by country.

00:00:26

Care must be taken with

00:00:28

the wording to be precise.

00:00:30

In the conversation pane,

00:00:32

Copilot executes and suggests inserting

00:00:34

a result sheet that will contain,

00:00:36

as you can see, a pivot table

00:00:38

as well as the associated chart.

00:00:40

Customization of the pivot

00:00:42

table or chart will, however,

00:00:43

need to be done manually by the user.

00:00:46

Let's generate a second request from

00:00:48

the data sheet wanting a pie chart

00:00:51

related to the number of orders

00:00:53

distributed by our tracking numbers.

00:00:55

Essentially our delivery companies.

00:00:56

As before,

00:00:57

a chart associated with a table

00:00:59

is generated in a new potential

00:01:01

tab with the possibility for me

00:01:03

to manually adjust properties.

00:01:05

Let's add a data legend label.

00:01:10

Curve type charts are also possible,

00:01:12

as I want to illustrate here by

00:01:14

prompting a request for a chronological

00:01:16

revenue evolution over the year.

00:01:18

Once again, a chart is generated.

00:01:22

Copilot for Excel facilitates the

00:01:24

implementation and visual analysis of data,

00:01:26

especially if you're not an expert

00:01:29

in using Excel spreadsheets.

DiLeaP AI: THIS MIGHT BE HELPFUL

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
10050 views

Outlook - How do I share a document securely with Outlook?

In this video, you will learn how to securely share a document with Outlook.
Instead of attaching the document to your email, it is safer to add it to your OneDrive or SharePoint library.
This allows you to set permissions for who can view and edit the document.
When you share the link to your document from Outlook, the permissions you set in OneDrive or SharePoint are retained.
You can easily change the sharing permissions in the attachment drop-down menu.
Regularly checking and updating the permissions ensures the safety of your document.
This tutorial will help you securely share documents using Outlook in Microsoft 365.

1:49
2496 views

Project Online - Discovering the interface

In this video, you will learn about the intelligent search feature in Microsoft 365. The video covers the search tools in Microsoft 365, including searching on your computer, using Microsoft Search, finding content and people in SharePoint, searching your emails, and more.
This will help you save time and easily find documents, information, and people within the Microsoft 365 suite.

4:51
3788 views

FindTime - Create a scheduling poll

Discover how to create a meeting poll in this video titled "Creating a scheduling poll" This resource is designed for intermediate-level learners looking for effective ways to communicate and manage their time.

You will learn how to create an interactive poll to gather opinions and preferences from meeting participants. This skill will enable you to facilitate decision-making and organize more productive meetings.

Don't miss this opportunity to enhance your communication and time management skills.

4:12
3650 views

Outlook - How do I recognize a fraudulent email?

In this video, you will learn how to recognize a fraudulent email and protect yourself from phishing attacks.
Phishing emails often mimic legitimate ones, using logos and information from reputable companies.
However, there are usually spelling errors, a haphazard layout, or inconsistencies with the company's graphic design.
Pay attention to the sender's email address, as it may not match the company's domain.
Be cautious if the sender's name consists of random letters and numbers.
Avoid clicking on links that ask you to renew your account or provide personal or banking information.
Even clicking on a link can install malware on your computer.
If you have any doubts, contact the company using secure contact information from their official website.
This knowledge will help you stay safe online and protect your personal information.

2:01
2129 views