Excel - Format Data with Copilot Tutorial

Explore the possibilities of formatting Excel tables with Copilot. In this tutorial, learn how to invoke the Copilot pane, which offers immediate assistance in formatting data as a table. Perfect for intermediate users, Copilot for Microsoft Excel provides valuable features to enhance your data formatting experience.

1:52
102 views

Available in AI - Artificial Intelligence

00:00:02

In this tutorial, let's explore

00:00:04

what's possible with Copilot in

00:00:06

terms of formatting Excel tables.

00:00:08

Please note Copilot for Microsoft

00:00:09

Excel is still in preview,

00:00:11

Therefore, the features may be

00:00:13

more limited and less reliable.

00:00:15

Upon opening a workbook containing data,

00:00:17

I invoke the Copilot pane by

00:00:19

clicking on the ribbon icon.

00:00:21

The assistant then immediately

00:00:23

offers to format as a table.

00:00:28

Here I want to widen the column rows after a

00:00:31

brief weight the action has been completed.

00:00:33

And a summary of what was done is provided.

00:00:36

We can notice that the width of the

00:00:39

columns might be a bit exaggerated.

00:00:41

We are in a preview and it's not

00:00:43

yet possible to be too precise

00:00:45

without risking an unexpected result.

00:00:47

That's why here I manually adjust

00:00:48

the width to height ratio.

00:00:50

Nevertheless, I can further request

00:00:52

an adjustment to the font size,

00:00:54

which works correctly.

00:00:54

Still with the aim of formatting my data.

00:00:57

I want to highlight the null

00:00:59

values in my table.

00:01:00

I express my prompt in English

00:01:02

and Copilot executes by

00:01:03

applying conditional formatting,

00:01:04

not just a simple background color.

00:01:07

The suggested prompts allow me to request,

00:01:09

as here, a bold highlight of the

00:01:11

first column of the table.

00:01:13

If the result is not satisfactory,

00:01:15

I can of course cancel.

00:01:18

I would now like to bold highlight

00:01:20

the top ten values in my table.

00:01:22

Copilot understands,

00:01:23

but applies it to each column individually.

00:01:25

I'll leave it up to you to decide

00:01:27

whether to attribute this to the prompt

00:01:29

given or to the fact that we're in a

00:01:33

preview version of Copilot for Excel.

00:01:35

Other effects can be applied,

00:01:37

like data bars, which I use quite regularly.

00:01:39

In short, Copilot can handle

00:01:41

certain formatting effects,

00:01:42

but for the moment it doesn't offer

00:01:44

a convincing improvement on this

00:01:46

point compared to manual formatting.

00:01:48

Let's give it some time.

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
3148 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
4097 views