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
- 1312 views
-
OneDrive - What is OneDrive ?
- 01:14
- Viewed 2589 times
-
Copilot (licence) - Use Copilot with Right-Click
- 02:50
- Viewed 1555 times
-
Outlook - Create and modify a group
- 2:19
- Viewed 5525 times
-
OneDrive - Edit, Delete a Share
- 02:16
- Viewed 1644 times
-
Power BI - Introduction to Power Bi
- 1:29
- Viewed 7154 times
-
Teams Premium - Activate the features of Teams Premium
- 3:48
- Viewed 14860 times
-
Teams Premium - Optimize Teams Premium settings in Administration
- 1:27
- Viewed 3196 times
-
Viva Engage - The role of an administrator
- 2:22
- Viewed 5493 times
-
Ink Equation
- 0:41
- Viewed 5365 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5164 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 5060 times
-
3D Maps
- 1:41
- Viewed 4856 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4724 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4544 times
-
Create a combo chart
- 1:47
- Viewed 4533 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4520 times
-
More complex formulas
- 4:17
- Viewed 4505 times
-
Create a PivotTable report manually
- 4:59
- Viewed 4416 times
-
Manage conditional formatting
- 4:30
- Viewed 4372 times
-
Functions and formulas
- 3:24
- Viewed 4344 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4339 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4302 times
-
Start using Excel
- 4:22
- Viewed 4283 times
-
Manage drop-down lists
- 6:12
- Viewed 4271 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 4271 times
-
New Chart types
- 1:52
- Viewed 4236 times
-
The SUMIF function
- 5:27
- Viewed 4236 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4200 times
-
A closer look at the ribbon
- 3:55
- Viewed 4197 times
-
The SUM function
- 4:37
- Viewed 4172 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4169 times
-
AVERAGEIF function
- 3:04
- Viewed 4162 times
-
Using functions
- 5:12
- Viewed 4125 times
-
Look up values on a different worksheet
- 2:39
- Viewed 4124 times
-
Insert columns and rows
- 4:16
- Viewed 4099 times
-
Advanced formulas and references
- 4:06
- Viewed 4089 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 4077 times
-
A first look at Excel 2016
- 3:22
- Viewed 4075 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 4068 times
-
Add numbers
- 2:54
- Viewed 4062 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 4055 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 4055 times
-
Customize charts
- 4:28
- Viewed 4054 times
-
Work with macros
- 4:40
- Viewed 4048 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 4039 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 4036 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 4028 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 4015 times
-
Advanced filter details
- 4:13
- Viewed 3998 times
-
Subtract time
- 3:58
- Viewed 3994 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3988 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3984 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3974 times
-
Freeze panes in detail
- 3:30
- Viewed 3972 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3967 times
-
AutoFill
- 2:55
- Viewed 3958 times
-
More print options
- 5:59
- Viewed 3957 times
-
AutoFilter details
- 3:27
- Viewed 3954 times
-
How things are organized
- 1:58
- Viewed 3949 times
-
Copying formulas
- 3:00
- Viewed 3925 times
-
Input and error messages
- 2:52
- Viewed 3922 times
-
IF with AND and OR
- 3:35
- Viewed 3920 times
-
Conditionally format dates
- 2:38
- Viewed 3917 times
-
Introduction to Excel
- 0:59
- Viewed 3911 times
-
Assign a button to a macro
- 2:49
- Viewed 3893 times
-
Sort details
- 4:46
- Viewed 3891 times
-
Insert headers and footers
- 2:02
- Viewed 3884 times
-
Header and footer details
- 3:41
- Viewed 3881 times
-
Drop-down list settings
- 4:14
- Viewed 3879 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3872 times
-
How to create a table
- 2:11
- Viewed 3872 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3871 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3839 times
-
Basic math
- 2:28
- Viewed 3804 times
-
Save your macro
- 2:59
- Viewed 3797 times
-
Operator order
- 2:04
- Viewed 3792 times
-
Weighted average
- 2:06
- Viewed 3773 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3772 times
-
Advanced IF functions
- 3:22
- Viewed 3765 times
-
Cell references
- 1:34
- Viewed 3744 times
-
Copy a chart
- 2:59
- Viewed 3732 times
-
Use conditional formatting
- 2:02
- Viewed 3727 times
-
TEXTJOIN
- 0:47
- Viewed 3722 times
-
Improved version history
- 0:51
- Viewed 3721 times
-
Add formulas and references
- 2:52
- Viewed 3682 times
-
IFS
- 1:05
- Viewed 3645 times
-
Use slicers to filter data
- 1:25
- Viewed 3644 times
-
Save, publish, and share
- 2:22
- Viewed 3633 times
-
Map Chart in Excel
- 0:31
- Viewed 3632 times
-
Conditionally format text
- 2:12
- Viewed 3630 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3622 times
-
One click Forecasting
- 1:01
- Viewed 3618 times
-
Nested IF functions
- 3:30
- Viewed 3611 times
-
Get going fast
- 1:38
- Viewed 3586 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3537 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3522 times
-
Flash Fill
- 2:59
- Viewed 3499 times
-
CONCAT
- 0:51
- Viewed 3498 times
-
Freeze or lock panes
- 1:06
- Viewed 3482 times
-
Edit a macro
- 3:29
- Viewed 3471 times
-
Average a group of numbers
- 2:01
- Viewed 3456 times
-
Drop-down lists
- 0:55
- Viewed 3435 times
-
Create a chart
- 0:52
- Viewed 3420 times
-
Sort and filter data
- 1:38
- Viewed 3416 times
-
SWITCH
- 1:03
- Viewed 3396 times
-
Share documents
- 1:13
- Viewed 3317 times
-
Microsoft Search
- 0:34
- Viewed 3269 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 3231 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 3199 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 3185 times
-
Page numbers in depth
- 3:06
- Viewed 3126 times
-
Check Accessibility in Excel
- 1:51
- Viewed 3072 times
-
Funnel Chart
- 0:33
- Viewed 3051 times
-
Accessibility in Excel
- 1:12
- Viewed 2929 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2766 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2729 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2603 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2577 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2530 times
-
Text before & after Function
- 4:57
- Viewed 2417 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2398 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 2307 times
-
Change chart type
- 1:29
- Viewed 2031 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1767 times
-
Use Copilot with Right-Click
- 02:50
- Viewed 1555 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 1138 times
-
Format Data with Copilot
- 1:52
- Viewed 1111 times
-
Create an insights grid
- 01:19
- Viewed 461 times
-
Generate formulas from a concept
- 01:02
- Viewed 284 times
-
Use the Copilot pane
- 01:12
- Viewed 255 times
-
Process text
- 01:03
- Viewed 250 times
-
Remove a watermark
- 2:20
- Viewed 16803 times
-
How to add branching logic in Microsoft Forms
- 1:55
- Viewed 5873 times
-
Align flow chart shapes and add connectors
- 4:48
- Viewed 5597 times
-
Change font size, line spacing, and indentation
- 5:09
- Viewed 5538 times
-
Ink Equation
- 0:41
- Viewed 5365 times
-
Convert handwritten texts or drawings with Powerpoint
- 0:33
- Viewed 5313 times
-
Change list formatting on the slide master
- 5:22
- Viewed 5208 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5164 times
-
Trigger text to play over a video
- 2:58
- Viewed 5146 times
-
Insert items in a presentation
- 2:38
- Viewed 5093 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 5060 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 4875 times
-
3D Maps
- 1:41
- Viewed 4856 times
-
Add a "Date" field to your form or quiz in Microsoft Forms
- 1:06
- Viewed 4791 times
-
Print Notes Pages as handouts
- 3:15
- Viewed 4750 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4724 times
-
Add headers and footers to slides
- 3:52
- Viewed 4666 times
-
Add a sound effect to a transition
- 3:45
- Viewed 4636 times
-
Finalize and review a presentation
- 2:02
- Viewed 4579 times
-
Add sound effects to an animation
- 4:29
- Viewed 4542 times
-
Save time by creating your form with quick import
- 2:20
- Viewed 4537 times
-
Create a combo chart
- 1:47
- Viewed 4533 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4520 times
-
More complex formulas
- 4:17
- Viewed 4505 times
-
Create a new slide master and layouts
- 5:13
- Viewed 4388 times
-
Animate charts and SmartArt
- 3:36
- Viewed 4383 times
-
Manage conditional formatting
- 4:30
- Viewed 4372 times
-
Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 4361 times
-
Functions and formulas
- 3:24
- Viewed 4344 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4339 times
-
Customize the slide master
- 4:38
- Viewed 4320 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4302 times
-
Trigger an animation effect
- 2:29
- Viewed 4298 times
-
Work with a motion path
- 2:50
- Viewed 4296 times
-
Start using Excel
- 4:22
- Viewed 4283 times
-
Build an org chart using the text pane
- 4:00
- Viewed 4282 times
-
Manage drop-down lists
- 6:12
- Viewed 4271 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 4271 times
-
Prepare a basic handout
- 4:30
- Viewed 4264 times
-
Create a flow chart
- 3:27
- Viewed 4249 times
-
New Chart types
- 1:52
- Viewed 4236 times
-
The SUMIF function
- 5:27
- Viewed 4236 times
-
Measure how people feel about something with the Likert scale in Microsoft Forms
- 2:02
- Viewed 4232 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4200 times
-
Create slide content and save the template
- 4:50
- Viewed 4194 times
-
The SUM function
- 4:37
- Viewed 4172 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4169 times
-
AVERAGEIF function
- 3:04
- Viewed 4162 times
-
Using functions
- 5:12
- Viewed 4125 times
-
Look up values on a different worksheet
- 2:39
- Viewed 4124 times
-
Insert columns and rows
- 4:16
- Viewed 4099 times
-
Advanced formulas and references
- 4:06
- Viewed 4089 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 4077 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 4068 times
-
Add numbers
- 2:54
- Viewed 4062 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 4055 times
-
Animate pictures, shapes, text, and other objects
- 4:02
- Viewed 4055 times
-
Customize charts
- 4:28
- Viewed 4054 times
-
Work with macros
- 4:40
- Viewed 4048 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 4039 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 4036 times
-
Create slicers
- 3:55
- Viewed 4029 times
-
Create an automated workflow for Microsoft Forms with Power Automate
- 5:09
- Viewed 4028 times
-
Create quick measures
- 3:02
- Viewed 4010 times
-
Customize colors and save the theme
- 4:45
- Viewed 4004 times
-
Advanced filter details
- 4:13
- Viewed 3998 times
-
Use slide masters to customize a presentation
- 3:07
- Viewed 3997 times
-
Subtract time
- 3:58
- Viewed 3994 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3988 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3984 times
-
Add a picture watermark
- 4:36
- Viewed 3978 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3974 times
-
Customize the design and layouts
- 5:06
- Viewed 3973 times
-
Freeze panes in detail
- 3:30
- Viewed 3972 times
-
Create a template from a presentation
- 3:09
- Viewed 3968 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3967 times
-
More print options
- 5:59
- Viewed 3957 times
-
AutoFilter details
- 3:27
- Viewed 3954 times
-
Backgrounds in PowerPoint: First Steps
- 3:20
- Viewed 3954 times
-
Multiple choice questions in Microsoft Forms
- 2:14
- Viewed 3946 times
-
Print slides, notes, or handouts
- 2:48
- Viewed 3932 times
-
Copying formulas
- 3:00
- Viewed 3925 times
-
Input and error messages
- 2:52
- Viewed 3922 times
-
IF with AND and OR
- 3:35
- Viewed 3920 times
-
Conditionally format dates
- 2:38
- Viewed 3917 times
-
Create custom animations with motion paths
- 3:39
- Viewed 3906 times
-
Assign a button to a macro
- 2:49
- Viewed 3893 times
-
Sort details
- 4:46
- Viewed 3891 times
-
Insert headers and footers
- 2:02
- Viewed 3884 times
-
Header and footer details
- 3:41
- Viewed 3881 times
-
Drop-down list settings
- 4:14
- Viewed 3879 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3872 times
-
How to create a table
- 2:11
- Viewed 3872 times
-
Work with handout masters
- 4:34
- Viewed 3861 times
-
Change the theme background
- 5:38
- Viewed 3859 times
-
Animate pictures and shapes
- 4:17
- Viewed 3849 times
-
Picture backgrounds: Two methods
- 4:58
- Viewed 3840 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3839 times
-
Creating and managing a group
- 1:56
- Viewed 3824 times
-
Print handouts
- 4:32
- Viewed 3809 times
-
Basic math
- 2:28
- Viewed 3804 times
-
Screen recording
- 0:49
- Viewed 3798 times
-
Save your macro
- 2:59
- Viewed 3797 times
-
Operator order
- 2:04
- Viewed 3792 times
-
Weighted average
- 2:06
- Viewed 3773 times
-
Advanced IF functions
- 3:22
- Viewed 3765 times
-
Cell references
- 1:34
- Viewed 3744 times
-
Copy a chart
- 2:59
- Viewed 3732 times
-
Use conditional formatting
- 2:02
- Viewed 3727 times
-
Improved version history
- 0:51
- Viewed 3721 times
-
Customize master layouts
- 4:57
- Viewed 3721 times
-
Apply and change a theme
- 5:13
- Viewed 3683 times
-
Add formulas and references
- 2:52
- Viewed 3682 times
-
Use slicers to filter data
- 1:25
- Viewed 3644 times
-
Conditionally format text
- 2:12
- Viewed 3630 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3622 times
-
Prepare and run your presentation
- 1:28
- Viewed 3621 times
-
One click Forecasting
- 1:01
- Viewed 3618 times
-
Nested IF functions
- 3:30
- Viewed 3611 times
-
Removing backgrounds in PowerPoint
- 2:45
- Viewed 3600 times
-
Combine a path with other effects
- 4:49
- Viewed 3597 times
-
Manage Your Working Time in MyAnalytics
- 0:34
- Viewed 3590 times
-
Add headers and footers to a presentation
- 2:50
- Viewed 3584 times
-
90 seconds about PowerPoint Slide Masters
- 1:17
- Viewed 3581 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 3543 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3537 times
-
Create an org chart
- 3:09
- Viewed 3527 times
-
Conditional formatting
- 3:35
- Viewed 3526 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3522 times
-
Use the drill down filter
- 4:41
- Viewed 3517 times
-
Edit headers and footers for handouts
- 2:43
- Viewed 3485 times
-
Freeze or lock panes
- 1:06
- Viewed 3482 times
-
Edit a macro
- 3:29
- Viewed 3471 times
-
New chart types
- 0:39
- Viewed 3470 times
-
Build an org chart using SmartArt Tools
- 5:09
- Viewed 3470 times
-
Ink Equation
- 0:40
- Viewed 3458 times
-
Animate text
- 4:14
- Viewed 3457 times
-
Average a group of numbers
- 2:01
- Viewed 3456 times
-
Add staff members
- 2:57
- Viewed 3456 times
-
Design motion paths
- 2:30
- Viewed 3450 times
-
Drop-down lists
- 0:55
- Viewed 3435 times
-
Sort and filter data
- 1:38
- Viewed 3416 times
-
Apply paths to layered pictures
- 5:28
- Viewed 3414 times
-
Calculate function
- 4:22
- Viewed 3394 times
-
Present Live
- 3:13
- Viewed 3375 times
-
Create a sequence with line paths
- 6:42
- Viewed 3344 times
-
Make a reservation [Staff]
- 1:55
- Viewed 3253 times
-
Start using PowerPoint
- 2:06
- Viewed 3249 times
-
Add bullets to text
- 2:24
- Viewed 3217 times
-
Create a new calendar
- 2:55
- Viewed 3209 times
-
Turn on the drill down feature
- 2:23
- Viewed 3195 times
-
Trigger a video
- 4:06
- Viewed 3191 times
-
Add an alert to a visual
- 2:24
- Viewed 3113 times
-
Integrate Bookings into TEAMS
- 1:36
- Viewed 3076 times
-
Turn your Excel tables into real lists!
- 1:12
- Viewed 3073 times
-
Manage interactions
- 1:56
- Viewed 3067 times
-
Make a reservation [Customer]
- 2:13
- Viewed 3043 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 3039 times
-
Create custom fields
- 1:21
- Viewed 3027 times
-
Manage relations between data sources
- 2:37
- Viewed 2988 times
-
Complete and Share a Schedule
- 2:02
- Viewed 2974 times
-
Easily measure user experience with Net Promoter Score in Microsoft Forms
- 1:32
- Viewed 2913 times
-
What are measures?
- 2:58
- Viewed 2906 times
-
Organise notes
- 2:57
- Viewed 2903 times
-
Create a Microsoft Forms form directly in OneDrive
- 1:33
- Viewed 2888 times
-
Add a service
- 2:03
- Viewed 2886 times
-
Import, create, edit and share documents
- 2:35
- Viewed 2867 times
-
Research in your notes
- 1:13
- Viewed 2866 times
-
Create a Schedule and Organise it with the Help of Groups
- 1:42
- Viewed 2857 times
-
Use template to prepare your Agile SCRUM meeting
- 2:50
- Viewed 2849 times
-
Create your first form or quiz in Microsoft Forms
- 2:12
- Viewed 2811 times
-
Create and organise a group
- 1:30
- Viewed 2807 times
-
Get a rating in Microsoft Forms
- 1:32
- Viewed 2801 times
-
Draw, sketch or handwrite notes
- 1:25
- Viewed 2798 times
-
Send your notes by email
- 0:42
- Viewed 2750 times
-
How Clock In Works
- 0:22
- Viewed 2716 times
-
Add a Visio diagram
- 1:23
- Viewed 2689 times
-
Manage our recent documents
- 2:24
- Viewed 2649 times
-
Make better tables
- 10 min
- Viewed 2647 times
-
Creating and managing campaigns
- 1:39
- Viewed 2626 times
-
Access other apps aroud Office 365
- 1:10
- Viewed 2618 times
-
Password protect your notes
- 1:43
- Viewed 2607 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2603 times
-
Create a new shared booking page
- 2:32
- Viewed 2603 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2577 times
-
Save, share and share everything
- 0:49
- Viewed 2537 times
-
Creating or editing office documents in Engage
- 0:44
- Viewed 2428 times
-
Add an Excel spreadsheet
- 1:31
- Viewed 2426 times
-
Insert online videos
- 0:41
- Viewed 2421 times
-
Text before & after Function
- 4:57
- Viewed 2417 times
-
Imbrication OneNote / Teams
- 1:03
- Viewed 2395 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 2394 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 2380 times
-
Add files
- 1:26
- Viewed 2366 times
-
See who's collaborating
- 2:01
- Viewed 2357 times
-
Add items
- 2:04
- Viewed 2354 times
-
Meeting recordings in Microsoft Teams
- 1:13
- Viewed 2347 times
-
Make a reservation Employee]
- 1:50
- Viewed 2327 times
-
Create a video from the web app
- 1:20
- Viewed 2320 times
-
Use page templates
- 2:19
- Viewed 2312 times
-
Upload an existing video from your device
- 1:11
- Viewed 2301 times
-
Imbrication OneNote / Outlook
- 1:37
- Viewed 2299 times
-
How to Copy a Schedule
- 0:39
- Viewed 2299 times
-
Use formatting toolbar and styles to format forms and quizzes
- 1:55
- Viewed 2289 times
-
Find out your coworkers’ preferences by creating a “Ranking” question in Microsoft Forms
- 2:14
- Viewed 2279 times
-
Sync and sharing
- 0:28
- Viewed 2270 times
-
Add staff
- 2:36
- Viewed 2267 times
-
Create custom fields
- 1:12
- Viewed 2241 times
-
Record a live PowerPoint presentation
- 1:18
- Viewed 2220 times
-
Install Office on 5 devices
- 1:53
- Viewed 2218 times
-
Create a video from the mobile app
- 1:13
- Viewed 2200 times
-
Add or edit a thumbnail
- 0:59
- Viewed 2170 times
-
Use "Text" fields to create a contact form
- 2:16
- Viewed 2163 times
-
Let responders submit files in Microsoft Forms
- 1:58
- Viewed 2156 times
-
Engaging and animating a group
- 1:55
- Viewed 2040 times
-
Change chart type
- 1:29
- Viewed 2031 times
-
Make a reservation [Customer]
- 1:51
- Viewed 1915 times
-
Send a single form in multiple languages
- 1:21
- Viewed 1892 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1767 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 1757 times
-
Add a service
- 2:28
- Viewed 1692 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 1684 times
-
Save a PowerPoint presentation
- 1:10
- Viewed 1672 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 1589 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 1566 times
-
Draft an Email with Copilot
- 02:36
- Viewed 1423 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 1161 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 1138 times
-
Format Data with Copilot
- 1:52
- Viewed 1111 times
-
Improve Email Writing with Copilot Coaching
- 01:47
- Viewed 1107 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 1069 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 1058 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 998 times
-
Generating Loop Content with Copilot
- 01:18
- Viewed 577 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 534 times
-
Create a reminder for yourself
- 01:59
- Viewed 507 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 506 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 447 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 437 times
-
Summarizing a Loop Page with Copilot
- 00:55
- Viewed 436 times
-
Create and add a signature to messages
- 01:26
- Viewed 416 times
-
Create different types of events
- 01:46
- Viewed 398 times
-
Make changes to a text
- 01:05
- Viewed 393 times
-
Edit and customize views
- 01:55
- Viewed 379 times
-
Sort and filter emails
- 02:51
- Viewed 374 times
-
Manage Teams online meeting options
- 01:56
- Viewed 359 times
-
Create an Email Template
- 01:40
- Viewed 359 times
-
Save and Print a Message
- 01:48
- Viewed 353 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 353 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 349 times
-
Change the default font of your emails
- 01:05
- Viewed 348 times
-
Delay Email Delivery
- 01:10
- Viewed 329 times
-
Improve Email Accessibility
- 02:02
- Viewed 325 times
-
Search options
- 01:23
- Viewed 319 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 318 times
-
Translate Emails in Outlook
- 01:32
- Viewed 314 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 309 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 305 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 284 times
-
Generate formulas from a concept
- 01:02
- Viewed 284 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 261 times
-
Is a hacker always a cybercriminal?
- 01:31
- Viewed 10 times
-
Will I know what to do if I get hacked?
- 01:16
- Viewed 7 times
-
Do I have to be an IT expert to protect myself?
- 01:14
- Viewed 9 times
-
Do cybercriminals only target large companies?
- 01:21
- Viewed 8 times
-
Are all files safe as long as I open them with trusted software?
- 01:24
- Viewed 9 times
-
Is contactless payment safe ?
- 01:26
- Viewed 9 times
-
Are online payments riskier than in-store ones?
- 01:21
- Viewed 8 times
-
Is cloud storage less secure than my personal computer?
- 01:37
- Viewed 8 times
-
Is scanning a QR code always safe?
- 01:21
- Viewed 7 times
-
Can my mobile apps do anything without my permission?
- 01:19
- Viewed 8 times
-
Is public Wi-Fi safe if no password is required?
- 01:26
- Viewed 7 times
-
Is the sender’s email address enough to verify a message?
- 01:29
- Viewed 7 times
-
Can I safely click a link in a message?
- 01:46
- Viewed 8 times
-
Does connecting to a well-known website guarantee its safety?
- 01:27
- Viewed 8 times
-
Am I safe online if I’m careful?
- 01:22
- Viewed 8 times
-
Does private browsing make me anonymous?
- 01:27
- Viewed 9 times
-
Are updates useless if everything works fine?
- 01:28
- Viewed 6 times
-
Is a firewall the same as an antivirus?
- 01:31
- Viewed 6 times
-
Does my antivirus block all threats?
- 01:46
- Viewed 7 times
-
Is a free antivirus good enough?
- 01:38
- Viewed 9 times
-
Is signing in with Google or Facebook a bad idea ?
- 01:34
- Viewed 6 times
-
Is my password secure if it contains an @ and a number?
- 01:41
- Viewed 9 times
-
Is a strong password all I need to stay safe?
- 01:55
- Viewed 8 times
-
Unlock new possibilities with the Mistral Canvas
- 02:01
- Viewed 12 times
-
Mistral at the service of coding
- 01:37
- Viewed 11 times
-
Analyze and compare your documents with Mistral
- 01:58
- Viewed 10 times
-
Generate your images and visuals with Mistral AI
- 02:06
- Viewed 10 times
-
Use Mistral AI to summarize online information
- 01:00
- Viewed 9 times
-
Exchange and manage your conversations with Mistral AI
- 03:31
- Viewed 10 times
-
Explore Mistral AI's generative options
- 01:51
- Viewed 10 times
-
Set up your Mistral workspace
- 01:42
- Viewed 9 times
-
Discover Mistral, the French-style AI
- 01:51
- Viewed 10 times
-
Instant alerts tailored to your activities
- 01:53
- Viewed 27 times
-
Seamless collaboration inside Microsoft Teams
- 01:22
- Viewed 23 times
-
Easy sharing with your team or organization
- 01:12
- Viewed 24 times
-
Relevant views to highlight your information
- 01:52
- Viewed 32 times
-
Clear insights through filters and sorting
- 02:06
- Viewed 22 times
-
A well-structured form for easy entry
- 01:17
- Viewed 27 times
-
The right column type for each data set
- 02:35
- Viewed 23 times
-
Custom columns to match your needs
- 02:09
- Viewed 23 times
-
Smooth updates and management for any list
- 01:06
- Viewed 24 times
-
Simple ways to add data to your list
- 01:06
- Viewed 25 times
-
Excel data turned into a dynamic list
- 02:08
- Viewed 25 times
-
A fully custom list built from scratch
- 01:34
- Viewed 26 times
-
A quick setup with ready-made templates
- 01:34
- Viewed 28 times
-
Mobile access to your lists made simple
- 01:37
- Viewed 32 times
-
The essentials of the Lists interface
- 02:01
- Viewed 25 times
-
The key reasons to use Microsoft Lists
- 02:01
- Viewed 28 times
-
Personality and tone for a believable rendering
- 01:48
- Viewed 65 times
-
Format and example for optimal results
- 02:03
- Viewed 67 times
-
The Importance of Context in Your Applications
- 02:14
- Viewed 58 times
-
Task Accuracy in Prompting
- 02:31
- Viewed 126 times
-
The Basis of Prompting in Conversational AI
- 02:41
- Viewed 55 times
-
What is a prompt in conversational AI?
- 02:02
- Viewed 62 times
-
Extract Text from an Image
- 01:07
- Viewed 82 times
-
Reply to an Email with Copilot
- 01:10
- Viewed 140 times
-
Create SharePoint Pages with Copilot
- 01:49
- Viewed 153 times
-
Query an Attached Meeting
- 01:51
- Viewed 65 times
-
Plan with Copilot
- 01:15
- Viewed 96 times
-
Share Requests with Your Team
- 03:07
- Viewed 144 times
-
Translate a presentation
- 01:38
- Viewed 73 times
-
Generate a Video
- 01:49
- Viewed 79 times
-
Add Speaker Notes
- 00:56
- Viewed 81 times
-
Initiate a project budget tracking table with Copilot
- 02:54
- Viewed 148 times
-
Develop and share a clear project follow-up with Copilot
- 02:18
- Viewed 136 times
-
Organize an action plan with Copilot and Microsoft Planner
- 01:31
- Viewed 156 times
-
Structure and optimize team collaboration with Copilot
- 02:28
- Viewed 197 times
-
Copilot at the service of project reports
- 02:36
- Viewed 165 times
-
Initiate a tracking table with ChatGPT
- 01:35
- Viewed 169 times
-
Distribute tasks within a team with ChatGPT
- 01:26
- Viewed 304 times
-
Generate a meeting summary with ChatGPT
- 01:24
- Viewed 169 times
-
Project mode
- 01:31
- Viewed 163 times
-
Create an agent for a team
- 01:53
- Viewed 278 times
-
Install and access Copilot Studio in Teams
- 01:38
- Viewed 276 times
-
Analyze the Copilot Studio agent
- 01:25
- Viewed 131 times
-
Publish the agent and make it accessible
- 01:39
- Viewed 280 times
-
Copilot Studio agent settings
- 01:33
- Viewed 120 times
-
Add new actions
- 01:54
- Viewed 278 times
-
Create a first action
- 01:59
- Viewed 266 times
-
Manage topics
- 01:51
- Viewed 152 times
-
Manage knowledge sources
- 01:11
- Viewed 117 times
-
Create an agent with Copilot Studio
- 01:52
- Viewed 268 times
-
Access Copilot Studio
- 01:09
- Viewed 264 times
-
Get started with Copilot Studio
- 01:25
- Viewed 130 times
-
Introduction to PowerBI
- 00:60
- Viewed 293 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 279 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 271 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 304 times
-
Introduction to Planner
- 00:56
- Viewed 282 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 420 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 288 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 427 times
-
Introduction to Sway
- 01:53
- Viewed 365 times
-
Introducing to Word
- 01:00
- Viewed 268 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 257 times
-
Create a call group
- 01:15
- Viewed 456 times
-
Use call delegation
- 01:07
- Viewed 223 times
-
Assign a delegate for your calls
- 01:08
- Viewed 424 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 229 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 228 times
-
Manage advanced call notifications
- 01:29
- Viewed 240 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 377 times
-
Block unwanted calls
- 01:24
- Viewed 273 times
-
Disable all call forwarding
- 01:09
- Viewed 252 times
-
Manage a call group in Teams
- 02:01
- Viewed 271 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 224 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 228 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 245 times
-
Manage voicemail messages
- 01:55
- Viewed 381 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 417 times
-
Customize your voicemail greeting
- 02:17
- Viewed 224 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 288 times
-
Manage simultaneous calls
- 01:52
- Viewed 255 times
-
Support third-party apps during calls
- 01:53
- Viewed 364 times
-
Add participants quickly and securely
- 01:37
- Viewed 241 times
-
Configure call privacy and security settings
- 02:51
- Viewed 239 times
-
Manage calls on hold
- 01:20
- Viewed 235 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 243 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 232 times
-
Draft a Service Memo
- 02:33
- Viewed 278 times
-
Extract Invoice Data and Generate a Pivot Table
- 03:26
- Viewed 266 times
-
Formulate a Request for Pricing Conditions via Email
- 02:32
- Viewed 436 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:41
- Viewed 408 times
-
SharePoint Page Co-Editing: Collaborate in Real Time
- 02:14
- Viewed 140 times
-
Other Coaches
- 01:45
- Viewed 292 times
-
Agents in SharePoint
- 02:44
- Viewed 233 times
-
Prompt coach
- 02:49
- Viewed 260 times
-
Modify, Share, and Install an Agent
- 01:43
- Viewed 246 times
-
Configure a Copilot Agent
- 02:39
- Viewed 256 times
-
Describe a copilot agent
- 01:32
- Viewed 292 times
-
Rewrite with Copilot
- 01:21
- Viewed 245 times
-
Analyze a video
- 01:21
- Viewed 267 times
-
Use the Copilot pane
- 01:12
- Viewed 255 times
-
Process text
- 01:03
- Viewed 250 times
-
Create an insights grid
- 01:19
- Viewed 461 times
-
Generate and manipulate an image in PowerPoint
- 01:47
- Viewed 255 times
-
Interact with a web page with Copilot
- 00:36
- Viewed 275 times
-
Create an image with Copilot
- 00:42
- Viewed 472 times
-
Summarize a PDF with Copilot
- 00:41
- Viewed 267 times
-
Analyze your documents with Copilot
- 01:15
- Viewed 272 times
-
Chat with Copilot
- 00:50
- Viewed 281 times
-
Particularities of Personal and Professional Copilot Accounts
- 00:40
- Viewed 453 times
-
Data Privacy in Copilot
- 00:43
- Viewed 275 times
-
Access Copilot
- 00:25
- Viewed 486 times
-
Use a Copilot Agent
- 01:24
- Viewed 311 times
-
Edit in Pages
- 01:49
- Viewed 319 times
-
Generate and manipulate an image in Word
- 01:19
- Viewed 292 times
-
Create Outlook rules with Copilot
- 01:12
- Viewed 278 times
-
Generate the email for the recipient
- 00:44
- Viewed 268 times
-
Action Function
- 04:18
- Viewed 237 times
-
Search Function
- 03:42
- Viewed 280 times
-
Date and Time Function
- 02:53
- Viewed 300 times
-
Logical Function
- 03:14
- Viewed 461 times
-
Text Function
- 03:25
- Viewed 292 times
-
Basic Function
- 02:35
- Viewed 249 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 291 times
-
Introduction to Power Fx
- 01:09
- Viewed 295 times
-
The New Calendar
- 03:14
- Viewed 499 times
-
Sections
- 02:34
- Viewed 262 times
-
Customizing Views
- 03:25
- Viewed 253 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 560 times
Objectifs :
This video aims to demonstrate how to effectively use Microsoft Copilot for data analysis in tables, including sorting, filtering, and generating pivot tables, enhancing productivity and efficiency in handling data.
Chapitres :
-
Introduction to Microsoft Copilot
Microsoft Copilot enhances the power of table formatting through simple prompts. This video will guide you on how to utilize Copilot for sorting, filtering, and generating pivot tables, making data analysis more efficient. -
Sorting Data
To sort data, open the Copilot conversation pane and use a prompt like 'sort the salaries in ascending order in a table displaying a list of employees.' This process is quick and efficient, allowing for immediate organization of data. -
Filtering Data
You can also filter data manually by specifying criteria. For instance, you can ask Copilot to display only employees from London. Additionally, applying a cumulative filter is straightforward; simply request to filter based on the status column to show only active employees. -
Sorting Within Filters
Once you have an active filter, you can sort the data further. For example, you can sort the filtered data in descending order by the Age column. Copilot executes these requests effortlessly, streamlining your data management. -
Restoring Original Data
To return to the unfiltered table, prompt Copilot by saying 'show all,' and the original data will be restored, allowing for a fresh start in your analysis. -
Generating Pivot Tables
For deeper analysis, you can request Copilot to generate pivot tables. Initially, it may provide a general example, but you can refine your request for more specific insights, such as analyzing payroll by gender, contract type, and city. -
Manual Modifications
Once Copilot generates the pivot table proposal, you can insert it into your sheet. However, keep in mind that any further modifications to the pivot table must be done manually. -
Second Example: Employee Count and Average Salary
To illustrate further, you can request a count of employees by contract type along with the average salary. As long as your request is clear and simple, Copilot will deliver precise results, making data analysis easier than ever. -
Conclusion
In summary, Microsoft Copilot significantly simplifies data analysis tasks such as sorting, filtering, and generating pivot tables. By using clear prompts, users can enhance their productivity and efficiency in managing data.
FAQ :
What is Microsoft Copilot?
Microsoft Copilot is an AI-powered assistant integrated into Microsoft applications that helps users perform tasks more efficiently by understanding natural language prompts.
How do I sort data using Copilot?
To sort data using Copilot, open the conversation pane and enter a prompt such as 'sort the salaries in ascending order.' Copilot will execute the request and sort the data accordingly.
Can I filter data based on specific criteria?
Yes, you can filter data by asking Copilot to display only the data that meets your specified criteria, such as 'show only employees from London.'
What is a pivot table and how can I create one with Copilot?
A pivot table is a tool used to summarize and analyze data. You can create one by prompting Copilot with a request like 'generate a pivot table showing payroll by gender, contract type, and city.'
What should I do if Copilot doesn't understand my request?
If Copilot provides a general example, refine your request by being more specific about the data you want to analyze or the criteria you want to apply.
How can I return to the original data after filtering?
To return to the original unfiltered data, simply prompt Copilot by saying 'show all,' and it will restore the complete dataset.
Quelques cas d'usages :
Employee Data Management
HR professionals can use Copilot to efficiently manage employee data by sorting salaries, filtering employees by location, and generating pivot tables to analyze payroll by various demographics.
Financial Reporting
Finance teams can leverage Copilot to create detailed financial reports by filtering data based on contract types and generating pivot tables to summarize average salaries, improving reporting efficiency.
Sales Analysis
Sales analysts can utilize Copilot to filter sales data by region and generate pivot tables to analyze sales performance by product type, enhancing decision-making processes.
Project Management
Project managers can apply Copilot to sort project timelines and filter tasks based on status, allowing for better tracking of project progress and resource allocation.
Glossaire :
Copilot
A feature in Microsoft applications that assists users by automating tasks and providing suggestions through natural language prompts.
Pivot Table
A data processing tool used in Excel and other spreadsheet applications to summarize, analyze, and present data in a structured format.
Filter
A function that allows users to display only the data that meets certain criteria, hiding the rest of the data in a table.
Cumulative Filter
A type of filter that allows users to apply multiple criteria to narrow down the data displayed in a table.
Ascending Order
A sorting order where values are arranged from the smallest to the largest.
Descending Order
A sorting order where values are arranged from the largest to the smallest.
Criteria
The specific conditions or rules used to filter or sort data in a table.
Data Analysis
The process of inspecting, cleansing, transforming, and modeling data to discover useful information and support decision-making.
Cette formation pourrait intéresser votre entreprise ?
Mandarine Academy vous offre la possibilité d'obtenir des catalogues complets et actualisés, réalisés par nos formateurs experts dans différents domaines pour votre entreprise