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
100 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

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