Excel - Sort, Filter, and Analyze Data with Copilot Tutorial

Learn how to sort, filter, and analyze data with Copilot. Discover how this assistant can help you with simple prompts, such as sorting employee IDs by average salary. Increase efficiency with quick and accurate results. Get started with Copilot today!

1:48
927 views

Available in AI - Artificial Intelligence

00:00:06

through simple prompts to sort philtre or even generate pivot tables.

00:00:11

Let me show you how it works.

00:00:14

By opening the copilot conversation pane,

00:00:16

I can start with a prompt like sort the salaries in

00:00:19

ascending order in a table displaying a list of employees.

00:00:23

It's simple, quick and efficient.

00:00:26

I can also make a manual request,

00:00:28

such as filtering data in a column based on a specific criterion.

00:00:33

For example, I can ask copilot to display only employees from London.

00:00:38

Next, I want to apply a cumulative philtre.

00:00:41

So I ask copilot to philtre based on

00:00:43

the status column showing only active employees.

00:00:47

This works perfectly as long as my criteria remain straightforward.

00:00:51

Now, within my active philtre,

00:00:54

I want to sort the data in descending order by the Age column.

00:00:58

Again,

00:00:59

Copilot executes the request effortlessly

00:01:03

to return to my unfiltered table.

00:01:05

I just need to prompt it by saying show all and the original data is restored.

00:01:11

For deeper analysis, I can request copilot to generate pivot tables.

00:01:16

It initially provides a general example but advises being more specific.

00:01:21

So let's refine the request.

00:01:23

I'll ask for an analysis showing payroll by gender, contract type and city.

00:01:29

Once copilot generates the proposal, I simply insert it into my sheet.

00:01:34

Keep in mind that any further modifications to

00:01:37

the pivot table must be done manually.

00:01:40

To make this even clearer, let's try a second example.

00:01:43

I'll request a count of employees by contract type, along with the average salary

00:01:49

as long as the request is clear and simple. Copilot delivers precise results,

00:01:54

making data analysis easier than ever with Microsoft copilot.

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
10763 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
2900 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
4293 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
4111 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
2567 views

RELATED COURSES This tutorial is part of the following courses

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

Your trainer for this course
Cours E-learning

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

Your trainer for this course
Cours E-learning

829 Views

ALL COURSES