
Excel - Sort details Tutorial
In this video, you will learn about sorting details in Microsoft 365. The video covers how to efficiently sort and organize your documents and information using the intelligent search feature in Microsoft 365. This will help you save time and improve your productivity by easily finding the documents and information you need.
- 4:46
- 3747 views

-
Excel - AutoFilter details
- 3:27
- Viewed 3785 times
-
Excel - Sort details
- 4:46
- Viewed 3747 times
-
Excel - Drop-down list settings
- 4:14
- Viewed 3743 times
-
Excel - Sort and filter data
- 1:38
- Viewed 3263 times
-
Excel - Input and error messages
- 2:52
- Viewed 3730 times
-
Excel - Copy and remove conditional formatting
- 1:11
- Viewed 3440 times
-
Excel - Conditionally format text
- 2:12
- Viewed 3485 times
-
Excel - Conditionally format dates
- 2:38
- Viewed 3762 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 4998 times
-
Ink Equation
- 0:41
- Viewed 4961 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 4740 times
-
3D Maps
- 1:41
- Viewed 4651 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4392 times
-
Create a combo chart
- 1:47
- Viewed 4307 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4298 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4287 times
-
More complex formulas
- 4:17
- Viewed 4231 times
-
Manage conditional formatting
- 4:30
- Viewed 4194 times
-
Create a PivotTable report manually
- 4:59
- Viewed 4188 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4140 times
-
Functions and formulas
- 3:24
- Viewed 4123 times
-
Start using Excel
- 4:22
- Viewed 4113 times
-
Manage drop-down lists
- 6:12
- Viewed 4096 times
-
New Chart types
- 1:52
- Viewed 4082 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4053 times
-
The SUMIF function
- 5:27
- Viewed 4048 times
-
A closer look at the ribbon
- 3:55
- Viewed 4045 times
-
AVERAGEIF function
- 3:04
- Viewed 4012 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4002 times
-
Using functions
- 5:12
- Viewed 3989 times
-
The SUM function
- 4:37
- Viewed 3985 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 3978 times
-
Advanced formulas and references
- 4:06
- Viewed 3969 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3952 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 3946 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3927 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 3917 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3882 times
-
Freeze panes in detail
- 3:30
- Viewed 3869 times
-
A first look at Excel 2016
- 3:22
- Viewed 3869 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3868 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3867 times
-
Customize charts
- 4:28
- Viewed 3853 times
-
AutoFill
- 2:55
- Viewed 3853 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 3853 times
-
Add numbers
- 2:54
- Viewed 3850 times
-
Subtract time
- 3:58
- Viewed 3848 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 3844 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 3843 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3840 times
-
How things are organized
- 1:58
- Viewed 3838 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3837 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3836 times
-
Work with macros
- 4:40
- Viewed 3825 times
-
Insert columns and rows
- 4:16
- Viewed 3819 times
-
Advanced filter details
- 4:13
- Viewed 3815 times
-
More print options
- 5:59
- Viewed 3806 times
-
Introduction to Excel
- 0:59
- Viewed 3799 times
-
IF with AND and OR
- 3:35
- Viewed 3790 times
-
AutoFilter details
- 3:27
- Viewed 3785 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3763 times
-
Conditionally format dates
- 2:38
- Viewed 3762 times
-
Insert headers and footers
- 2:02
- Viewed 3755 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3754 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3747 times
-
Drop-down list settings
- 4:14
- Viewed 3743 times
-
Assign a button to a macro
- 2:49
- Viewed 3740 times
-
Input and error messages
- 2:52
- Viewed 3730 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3708 times
-
Header and footer details
- 3:41
- Viewed 3700 times
-
Basic math
- 2:28
- Viewed 3668 times
-
Copying formulas
- 3:00
- Viewed 3666 times
-
Operator order
- 2:04
- Viewed 3655 times
-
Save your macro
- 2:59
- Viewed 3641 times
-
Advanced IF functions
- 3:22
- Viewed 3611 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3603 times
-
Improved version history
- 0:51
- Viewed 3589 times
-
TEXTJOIN
- 0:47
- Viewed 3587 times
-
Copy a chart
- 2:59
- Viewed 3573 times
-
How to create a table
- 2:11
- Viewed 3564 times
-
Cell references
- 1:34
- Viewed 3544 times
-
Use conditional formatting
- 2:02
- Viewed 3533 times
-
Save, publish, and share
- 2:22
- Viewed 3531 times
-
Add formulas and references
- 2:52
- Viewed 3526 times
-
IFS
- 1:05
- Viewed 3525 times
-
Weighted average
- 2:06
- Viewed 3520 times
-
One click Forecasting
- 1:01
- Viewed 3488 times
-
Conditionally format text
- 2:12
- Viewed 3485 times
-
Use slicers to filter data
- 1:25
- Viewed 3482 times
-
Get going fast
- 1:38
- Viewed 3479 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3440 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3435 times
-
Map Chart in Excel
- 0:31
- Viewed 3425 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3422 times
-
Nested IF functions
- 3:30
- Viewed 3408 times
-
Freeze or lock panes
- 1:06
- Viewed 3391 times
-
CONCAT
- 0:51
- Viewed 3372 times
-
Average a group of numbers
- 2:01
- Viewed 3370 times
-
Flash Fill
- 2:59
- Viewed 3365 times
-
Drop-down lists
- 0:55
- Viewed 3341 times
-
Create a chart
- 0:52
- Viewed 3322 times
-
Edit a macro
- 3:29
- Viewed 3302 times
-
SWITCH
- 1:03
- Viewed 3283 times
-
Sort and filter data
- 1:38
- Viewed 3263 times
-
Share documents
- 1:13
- Viewed 3179 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 3150 times
-
Microsoft Search
- 0:34
- Viewed 3120 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 3083 times
-
Page numbers in depth
- 3:06
- Viewed 3008 times
-
Funnel Chart
- 0:33
- Viewed 2963 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 2895 times
-
Check Accessibility in Excel
- 1:51
- Viewed 2876 times
-
Accessibility in Excel
- 1:12
- Viewed 2831 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2636 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2594 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2455 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2431 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2418 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2318 times
-
Text before & after Function
- 4:57
- Viewed 2224 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 2078 times
-
Change chart type
- 1:29
- Viewed 1931 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1655 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1229 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 1081 times
-
Use Copilot with Right-Click
- 01:45
- Viewed 1066 times
-
Format Data with Copilot
- 1:52
- Viewed 1025 times
-
Create an insights grid
- 01:19
- Viewed 309 times
-
Generate formulas from a concept
- 01:02
- Viewed 232 times
-
Use the Copilot pane
- 01:12
- Viewed 195 times
-
Process text
- 01:03
- Viewed 185 times
-
Remove a watermark
- 2:20
- Viewed 15768 times
-
Align flow chart shapes and add connectors
- 4:48
- Viewed 5284 times
-
Change font size, line spacing, and indentation
- 5:09
- Viewed 5180 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 4998 times
-
Ink Equation
- 0:41
- Viewed 4961 times
-
How to add branching logic in Microsoft Forms
- 1:55
- Viewed 4913 times
-
Insert items in a presentation
- 2:38
- Viewed 4899 times
-
Trigger text to play over a video
- 2:58
- Viewed 4885 times
-
Change list formatting on the slide master
- 5:22
- Viewed 4823 times
-
Convert handwritten texts or drawings with Powerpoint
- 0:33
- Viewed 4793 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 4740 times
-
3D Maps
- 1:41
- Viewed 4651 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 4571 times
-
Print Notes Pages as handouts
- 3:15
- Viewed 4470 times
-
Add headers and footers to slides
- 3:52
- Viewed 4413 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4392 times
-
Add a "Date" field to your form or quiz in Microsoft Forms
- 1:06
- Viewed 4347 times
-
Create a combo chart
- 1:47
- Viewed 4307 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4298 times
-
Add sound effects to an animation
- 4:29
- Viewed 4260 times
-
Finalize and review a presentation
- 2:02
- Viewed 4237 times
-
More complex formulas
- 4:17
- Viewed 4231 times
-
Manage conditional formatting
- 4:30
- Viewed 4194 times
-
Animate charts and SmartArt
- 3:36
- Viewed 4174 times
-
Create a new slide master and layouts
- 5:13
- Viewed 4172 times
-
Add a sound effect to a transition
- 3:45
- Viewed 4157 times
-
Work with a motion path
- 2:50
- Viewed 4154 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4140 times
-
Functions and formulas
- 3:24
- Viewed 4123 times
-
Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 4123 times
-
Start using Excel
- 4:22
- Viewed 4113 times
-
Manage drop-down lists
- 6:12
- Viewed 4096 times
-
Customize the slide master
- 4:38
- Viewed 4088 times
-
New Chart types
- 1:52
- Viewed 4082 times
-
Create a flow chart
- 3:27
- Viewed 4056 times
-
Prepare a basic handout
- 4:30
- Viewed 4055 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4053 times
-
The SUMIF function
- 5:27
- Viewed 4048 times
-
Trigger an animation effect
- 2:29
- Viewed 4016 times
-
AVERAGEIF function
- 3:04
- Viewed 4012 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4002 times
-
Using functions
- 5:12
- Viewed 3989 times
-
The SUM function
- 4:37
- Viewed 3985 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 3978 times
-
Advanced formulas and references
- 4:06
- Viewed 3969 times
-
Build an org chart using the text pane
- 4:00
- Viewed 3955 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3952 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 3946 times
-
Create slide content and save the template
- 4:50
- Viewed 3936 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3927 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 3917 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3882 times
-
Freeze panes in detail
- 3:30
- Viewed 3869 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3868 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3867 times
-
Animate pictures, shapes, text, and other objects
- 4:02
- Viewed 3861 times
-
Customize charts
- 4:28
- Viewed 3853 times
-
Add numbers
- 2:54
- Viewed 3850 times
-
Subtract time
- 3:58
- Viewed 3848 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3840 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3837 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3836 times
-
Work with macros
- 4:40
- Viewed 3825 times
-
Insert columns and rows
- 4:16
- Viewed 3819 times
-
Advanced filter details
- 4:13
- Viewed 3815 times
-
Use slide masters to customize a presentation
- 3:07
- Viewed 3811 times
-
More print options
- 5:59
- Viewed 3806 times
-
Create an automated workflow for Microsoft Forms with Power Automate
- 5:09
- Viewed 3796 times
-
IF with AND and OR
- 3:35
- Viewed 3790 times
-
AutoFilter details
- 3:27
- Viewed 3785 times
-
Create quick measures
- 3:02
- Viewed 3777 times
-
Create slicers
- 3:55
- Viewed 3776 times
-
Add a picture watermark
- 4:36
- Viewed 3775 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3763 times
-
Customize colors and save the theme
- 4:45
- Viewed 3763 times
-
Conditionally format dates
- 2:38
- Viewed 3762 times
-
Create a template from a presentation
- 3:09
- Viewed 3758 times
-
Insert headers and footers
- 2:02
- Viewed 3755 times
-
Work with handout masters
- 4:34
- Viewed 3747 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3747 times
-
Backgrounds in PowerPoint: First Steps
- 3:20
- Viewed 3746 times
-
Drop-down list settings
- 4:14
- Viewed 3743 times
-
Assign a button to a macro
- 2:49
- Viewed 3740 times
-
Input and error messages
- 2:52
- Viewed 3730 times
-
Animate pictures and shapes
- 4:17
- Viewed 3719 times
-
Print slides, notes, or handouts
- 2:48
- Viewed 3715 times
-
Multiple choice questions in Microsoft Forms
- 2:14
- Viewed 3714 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3708 times
-
Header and footer details
- 3:41
- Viewed 3700 times
-
Customize the design and layouts
- 5:06
- Viewed 3675 times
-
Change the theme background
- 5:38
- Viewed 3671 times
-
Create custom animations with motion paths
- 3:39
- Viewed 3669 times
-
Basic math
- 2:28
- Viewed 3668 times
-
Copying formulas
- 3:00
- Viewed 3666 times
-
Operator order
- 2:04
- Viewed 3655 times
-
Print handouts
- 4:32
- Viewed 3653 times
-
Screen recording
- 0:49
- Viewed 3648 times
-
Picture backgrounds: Two methods
- 4:58
- Viewed 3642 times
-
Save your macro
- 2:59
- Viewed 3641 times
-
Advanced IF functions
- 3:22
- Viewed 3611 times
-
Measure how people feel about something with the Likert scale in Microsoft Forms
- 2:02
- Viewed 3609 times
-
Creating and managing a group
- 1:56
- Viewed 3607 times
-
Save time by creating your form with quick import
- 2:20
- Viewed 3591 times
-
Improved version history
- 0:51
- Viewed 3589 times
-
Copy a chart
- 2:59
- Viewed 3573 times
-
How to create a table
- 2:11
- Viewed 3564 times
-
Cell references
- 1:34
- Viewed 3544 times
-
Customize master layouts
- 4:57
- Viewed 3534 times
-
Use conditional formatting
- 2:02
- Viewed 3533 times
-
Add formulas and references
- 2:52
- Viewed 3526 times
-
Weighted average
- 2:06
- Viewed 3520 times
-
Removing backgrounds in PowerPoint
- 2:45
- Viewed 3493 times
-
One click Forecasting
- 1:01
- Viewed 3488 times
-
Conditionally format text
- 2:12
- Viewed 3485 times
-
Use slicers to filter data
- 1:25
- Viewed 3482 times
-
Add headers and footers to a presentation
- 2:50
- Viewed 3480 times
-
Apply and change a theme
- 5:13
- Viewed 3474 times
-
Combine a path with other effects
- 4:49
- Viewed 3470 times
-
Manage Your Working Time in MyAnalytics
- 0:34
- Viewed 3449 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3440 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3435 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3422 times
-
Nested IF functions
- 3:30
- Viewed 3408 times
-
90 seconds about PowerPoint Slide Masters
- 1:17
- Viewed 3407 times
-
Freeze or lock panes
- 1:06
- Viewed 3391 times
-
Prepare and run your presentation
- 1:28
- Viewed 3389 times
-
Edit headers and footers for handouts
- 2:43
- Viewed 3388 times
-
Conditional formatting
- 3:35
- Viewed 3379 times
-
Average a group of numbers
- 2:01
- Viewed 3370 times
-
Ink Equation
- 0:40
- Viewed 3346 times
-
Design motion paths
- 2:30
- Viewed 3346 times
-
Drop-down lists
- 0:55
- Viewed 3341 times
-
Create an org chart
- 3:09
- Viewed 3328 times
-
New chart types
- 0:39
- Viewed 3325 times
-
Add staff members
- 2:57
- Viewed 3325 times
-
Use the drill down filter
- 4:41
- Viewed 3324 times
-
Build an org chart using SmartArt Tools
- 5:09
- Viewed 3308 times
-
Apply paths to layered pictures
- 5:28
- Viewed 3304 times
-
Edit a macro
- 3:29
- Viewed 3302 times
-
Animate text
- 4:14
- Viewed 3295 times
-
Sort and filter data
- 1:38
- Viewed 3263 times
-
Calculate function
- 4:22
- Viewed 3256 times
-
Create a sequence with line paths
- 6:42
- Viewed 3255 times
-
Present Live
- 3:13
- Viewed 3180 times
-
Make a reservation [Staff]
- 1:55
- Viewed 3144 times
-
Add bullets to text
- 2:24
- Viewed 3080 times
-
Create a new calendar
- 2:55
- Viewed 3075 times
-
Trigger a video
- 4:06
- Viewed 3073 times
-
Start using PowerPoint
- 2:06
- Viewed 3038 times
-
Turn on the drill down feature
- 2:23
- Viewed 3032 times
-
Turn your Excel tables into real lists!
- 1:12
- Viewed 2991 times
-
Integrate Bookings into TEAMS
- 1:36
- Viewed 2988 times
-
Add an alert to a visual
- 2:24
- Viewed 2979 times
-
Manage interactions
- 1:56
- Viewed 2927 times
-
Manage relations between data sources
- 2:37
- Viewed 2864 times
-
Make a reservation [Customer]
- 2:13
- Viewed 2854 times
-
Complete and Share a Schedule
- 2:02
- Viewed 2830 times
-
Create custom fields
- 1:21
- Viewed 2830 times
-
Add a service
- 2:03
- Viewed 2774 times
-
Create a Schedule and Organise it with the Help of Groups
- 1:42
- Viewed 2772 times
-
Research in your notes
- 1:13
- Viewed 2769 times
-
Import, create, edit and share documents
- 2:35
- Viewed 2769 times
-
What are measures?
- 2:58
- Viewed 2723 times
-
Use template to prepare your Agile SCRUM meeting
- 2:50
- Viewed 2698 times
-
Organise notes
- 2:57
- Viewed 2691 times
-
Create and organise a group
- 1:30
- Viewed 2684 times
-
Get a rating in Microsoft Forms
- 1:32
- Viewed 2667 times
-
Create a Microsoft Forms form directly in OneDrive
- 1:33
- Viewed 2664 times
-
Easily measure user experience with Net Promoter Score in Microsoft Forms
- 1:32
- Viewed 2633 times
-
How Clock In Works
- 0:22
- Viewed 2608 times
-
Create your first form or quiz in Microsoft Forms
- 2:12
- Viewed 2595 times
-
Make better tables
- 10 min
- Viewed 2561 times
-
Manage our recent documents
- 2:24
- Viewed 2559 times
-
Add a Visio diagram
- 1:23
- Viewed 2531 times
-
Creating and managing campaigns
- 1:39
- Viewed 2525 times
-
Access other apps aroud Office 365
- 1:10
- Viewed 2524 times
-
Draw, sketch or handwrite notes
- 1:25
- Viewed 2490 times
-
Send your notes by email
- 0:42
- Viewed 2482 times
-
Password protect your notes
- 1:43
- Viewed 2460 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2455 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2431 times
-
Create a new shared booking page
- 2:32
- Viewed 2405 times
-
Save, share and share everything
- 0:49
- Viewed 2350 times
-
Insert online videos
- 0:41
- Viewed 2323 times
-
Add an Excel spreadsheet
- 1:31
- Viewed 2318 times
-
Imbrication OneNote / Teams
- 1:03
- Viewed 2306 times
-
Creating or editing office documents in Engage
- 0:44
- Viewed 2295 times
-
Add files
- 1:26
- Viewed 2274 times
-
See who's collaborating
- 2:01
- Viewed 2265 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 2254 times
-
Add items
- 2:04
- Viewed 2240 times
-
Imbrication OneNote / Outlook
- 1:37
- Viewed 2233 times
-
Text before & after Function
- 4:57
- Viewed 2224 times
-
How to Copy a Schedule
- 0:39
- Viewed 2216 times
-
Sync and sharing
- 0:28
- Viewed 2199 times
-
Upload an existing video from your device
- 1:11
- Viewed 2195 times
-
Use formatting toolbar and styles to format forms and quizzes
- 1:55
- Viewed 2189 times
-
Find out your coworkers’ preferences by creating a “Ranking” question in Microsoft Forms
- 2:14
- Viewed 2188 times
-
Make a reservation Employee]
- 1:50
- Viewed 2186 times
-
Use page templates
- 2:19
- Viewed 2175 times
-
Add staff
- 2:36
- Viewed 2157 times
-
Install Office on 5 devices
- 1:53
- Viewed 2143 times
-
Create a video from the web app
- 1:20
- Viewed 2135 times
-
Meeting recordings in Microsoft Teams
- 1:13
- Viewed 2122 times
-
Add or edit a thumbnail
- 0:59
- Viewed 2077 times
-
Create a video from the mobile app
- 1:13
- Viewed 2075 times
-
Record a live PowerPoint presentation
- 1:18
- Viewed 2074 times
-
Use "Text" fields to create a contact form
- 2:16
- Viewed 2065 times
-
Let responders submit files in Microsoft Forms
- 1:58
- Viewed 2053 times
-
Create custom fields
- 1:12
- Viewed 2016 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 1933 times
-
Change chart type
- 1:29
- Viewed 1931 times
-
Engaging and animating a group
- 1:55
- Viewed 1869 times
-
Send a single form in multiple languages
- 1:21
- Viewed 1816 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 1714 times
-
Make a reservation [Customer]
- 1:51
- Viewed 1707 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1655 times
-
Save a PowerPoint presentation
- 1:10
- Viewed 1602 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 1578 times
-
Add a service
- 2:28
- Viewed 1574 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 1439 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 1409 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 1350 times
-
Draft an Email with Copilot
- 2:35
- Viewed 1281 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1229 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 1222 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 1081 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 1069 times
-
Optimize Email Writing with Copilot Coaching
- 1:41
- Viewed 1026 times
-
Format Data with Copilot
- 1:52
- Viewed 1025 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 1004 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 988 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 937 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 438 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 412 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 370 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 366 times
-
Create a reminder for yourself
- 01:59
- Viewed 320 times
-
Create different types of events
- 01:46
- Viewed 315 times
-
Create and add a signature to messages
- 01:26
- Viewed 304 times
-
Make changes to a text
- 01:05
- Viewed 302 times
-
Save and Print a Message
- 01:48
- Viewed 299 times
-
Sort and filter emails
- 02:51
- Viewed 297 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 292 times
-
Change the default font of your emails
- 01:05
- Viewed 281 times
-
Create an Email Template
- 01:40
- Viewed 279 times
-
Manage Teams online meeting options
- 01:56
- Viewed 278 times
-
Edit and customize views
- 01:55
- Viewed 275 times
-
Generating Loop Content with Copilot
- 01:18
- Viewed 266 times
-
Improve Email Accessibility
- 02:02
- Viewed 265 times
-
Search options
- 01:23
- Viewed 261 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 249 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 242 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 240 times
-
Translate Emails in Outlook
- 01:32
- Viewed 239 times
-
Generate formulas from a concept
- 01:02
- Viewed 232 times
-
Delay Email Delivery
- 01:10
- Viewed 230 times
-
Summarizing a Loop Page with Copilot
- 00:55
- Viewed 226 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 220 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 212 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 207 times
-
Initiate a project budget tracking table with Copilot
- 02:54
- Viewed 77 times
-
Develop and share a clear project follow-up with Copilot
- 02:18
- Viewed 84 times
-
Organize an action plan with Copilot and Microsoft Planner
- 01:31
- Viewed 96 times
-
Structure and optimize team collaboration with Copilot
- 02:28
- Viewed 107 times
-
Copilot at the service of project reports
- 02:36
- Viewed 97 times
-
Initiate a tracking table with ChatGPT
- 01:35
- Viewed 90 times
-
Distribute tasks within a team with ChatGPT
- 01:26
- Viewed 143 times
-
Generate a meeting summary with ChatGPT
- 01:24
- Viewed 96 times
-
Project mode
- 01:31
- Viewed 95 times
-
Create an agent for a team
- 01:53
- Viewed 144 times
-
Install and access Copilot Studio in Teams
- 01:38
- Viewed 146 times
-
Analyze the Copilot Studio agent
- 01:25
- Viewed 85 times
-
Publish the agent and make it accessible
- 01:39
- Viewed 151 times
-
Copilot Studio agent settings
- 01:33
- Viewed 77 times
-
Add new actions
- 01:54
- Viewed 141 times
-
Create a first action
- 01:59
- Viewed 139 times
-
Manage topics
- 01:51
- Viewed 105 times
-
Manage knowledge sources
- 01:11
- Viewed 77 times
-
Create an agent with Copilot Studio
- 01:52
- Viewed 138 times
-
Access Copilot Studio
- 01:09
- Viewed 136 times
-
Get started with Copilot Studio
- 01:25
- Viewed 74 times
-
Introduction to PowerBI
- 00:60
- Viewed 199 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 191 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 197 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 199 times
-
Introduction to Planner
- 00:56
- Viewed 202 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 198 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 198 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 279 times
-
Introduction to Sway
- 01:53
- Viewed 177 times
-
Introducing to Word
- 01:00
- Viewed 197 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 176 times
-
Create a call group
- 01:15
- Viewed 251 times
-
Use call delegation
- 01:07
- Viewed 159 times
-
Assign a delegate for your calls
- 01:08
- Viewed 256 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 162 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 153 times
-
Manage advanced call notifications
- 01:29
- Viewed 169 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 212 times
-
Block unwanted calls
- 01:24
- Viewed 179 times
-
Disable all call forwarding
- 01:09
- Viewed 169 times
-
Manage a call group in Teams
- 02:01
- Viewed 160 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 158 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 155 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 177 times
-
Manage voicemail messages
- 01:55
- Viewed 232 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 264 times
-
Customize your voicemail greeting
- 02:17
- Viewed 152 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 150 times
-
Manage simultaneous calls
- 01:52
- Viewed 159 times
-
Support third-party apps during calls
- 01:53
- Viewed 199 times
-
Add participants quickly and securely
- 01:37
- Viewed 170 times
-
Configure call privacy and security settings
- 02:51
- Viewed 165 times
-
Manage calls on hold
- 01:20
- Viewed 163 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 154 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 164 times
-
Draft a Service Memo
- 02:33
- Viewed 213 times
-
Extract Invoice Data and Generate a Pivot Table
- 03:26
- Viewed 201 times
-
Formulate a Request for Pricing Conditions via Email
- 02:32
- Viewed 295 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:41
- Viewed 264 times
-
SharePoint Page Co-Editing: Collaborate in Real Time
- 02:14
- Viewed 103 times
-
Other Coaches
- 01:45
- Viewed 210 times
-
Agents in SharePoint
- 02:44
- Viewed 172 times
-
Prompt coach
- 02:49
- Viewed 196 times
-
Modify, Share, and Install an Agent
- 01:43
- Viewed 188 times
-
Configure a Copilot Agent
- 02:39
- Viewed 180 times
-
Describe a copilot agent
- 01:32
- Viewed 205 times
-
Rewrite with Copilot
- 01:21
- Viewed 179 times
-
Analyze a video
- 01:21
- Viewed 204 times
-
Use the Copilot pane
- 01:12
- Viewed 195 times
-
Process text
- 01:03
- Viewed 185 times
-
Create an insights grid
- 01:19
- Viewed 309 times
-
Generate and manipulate an image in PowerPoint
- 01:47
- Viewed 193 times
-
Interact with a web page with Copilot
- 00:36
- Viewed 216 times
-
Create an image with Copilot
- 00:42
- Viewed 320 times
-
Summarize a PDF with Copilot
- 00:41
- Viewed 208 times
-
Analyze your documents with Copilot
- 01:15
- Viewed 215 times
-
Chat with Copilot
- 00:50
- Viewed 205 times
-
Particularities of Personal and Professional Copilot Accounts
- 00:40
- Viewed 299 times
-
Data Privacy in Copilot
- 00:43
- Viewed 208 times
-
Access Copilot
- 00:25
- Viewed 336 times
-
Use a Copilot Agent
- 01:24
- Viewed 219 times
-
Modify with Pages
- 01:20
- Viewed 220 times
-
Generate and manipulate an image in Word
- 01:19
- Viewed 212 times
-
Create Outlook rules with Copilot
- 01:12
- Viewed 208 times
-
Generate the email for the recipient
- 00:44
- Viewed 198 times
-
Action Function
- 04:18
- Viewed 161 times
-
Search Function
- 03:42
- Viewed 218 times
-
Date and Time Function
- 02:53
- Viewed 197 times
-
Logical Function
- 03:14
- Viewed 302 times
-
Text Function
- 03:25
- Viewed 223 times
-
Basic Function
- 02:35
- Viewed 187 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 213 times
-
Introduction to Power Fx
- 01:09
- Viewed 195 times
-
The New Calendar
- 03:14
- Viewed 327 times
-
Sections
- 02:34
- Viewed 200 times
-
Customizing Views
- 03:25
- Viewed 192 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 346 times
-
Guide to Using the Microsoft Authenticator App
- 01:47
- Viewed 213 times
-
Turn on Multi-Factor Authentication in the Admin Section
- 02:07
- Viewed 169 times
-
Manual Activation of Multi-Factor Authentication
- 01:40
- Viewed 121 times
-
Concept of Multi-Factor Authentication
- 01:51
- Viewed 204 times
-
Use the narrative Builder
- 01:31
- Viewed 246 times
-
Microsoft Copilot Academy
- 00:42
- Viewed 208 times
-
Connect Copilot to a third party app
- 01:11
- Viewed 218 times
-
Share a document with copilot
- 00:36
- Viewed 208 times
-
Configurate a page with copilot
- 01:47
- Viewed 205 times
-
Use Copilot with Right-Click
- 01:45
- Viewed 1066 times
-
Draft a Service Memo with Copilot
- 02:21
- Viewed 222 times
-
Extract Invoice Data and Generate a Pivot Table
- 02:34
- Viewed 248 times
-
Summarize Discussions and Schedule a Meeting Slot
- 02:25
- Viewed 309 times
-
Formulate a Request for Pricing Conditions via Email
- 02:20
- Viewed 391 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:52
- Viewed 373 times
Objectifs :
This video aims to teach viewers how to sort data in Excel, including sorting numbers, text, and dates. It covers basic sorting methods, advanced sorting options, and the use of custom lists for sorting.
Chapitres :
-
Introduction to Sorting in Excel
Sorting data is a fundamental skill in Excel that helps organize information for better analysis. In this video, we will explore how to sort numbers, text, and dates, enhancing your ability to manage data effectively. -
Basic Sorting Techniques
To sort a range of text alphabetically, right-click a cell in the desired column, point to 'Sort', and select either 'A to Z' or 'Z to A'. This action will arrange the data in alphabetical order. For sorting dates, the process is similar: right-click a date cell, point to 'Sort', and choose 'Sort oldest to newest' or 'Sort newest to oldest' to organize the data chronologically. -
Advanced Sorting Options
For more complex sorting, such as sorting by multiple columns, click any cell within the range or table, navigate to the 'Data' tab, and select 'Sort'. In the sort dialog, ensure to check the option 'My data has headers' if your data includes column headers. This allows for easier identification of data categories. -
Using Custom Lists for Sorting
You can create custom lists for sorting when you need to organize text by specific categories rather than alphabetically. To do this, click 'Sort', set the sort by option to your desired category, and select 'Custom list' from the order dropdown. You can manually enter the order of categories or paste a list separated by commas. After adding your custom list, click 'OK' to sort the data accordingly. -
Sorting by Cell and Font Colors
Excel allows sorting by cell and font colors, which can be useful for visually categorizing data. In the sort dialog, set 'Sort by' to the desired color attribute. You can choose from options like 'Cell color', 'Font color', and 'Cell icon'. After configuring your preferences, click 'OK' to apply the sort. -
Undoing a Sort
If you need to reverse a sort, you can use the 'Undo' button on the Quick Access Toolbar or the keyboard shortcut Ctrl + Z, provided you haven't saved the workbook since the sort. If the workbook has been saved, the sort cannot be undone. -
Sorting by Rows
While sorting by columns is the most common method, Excel also allows sorting by rows. To do this, click 'Sort', and in the sort dialog, change the configuration from sorting by columns to 'Sort left to right'. After making this adjustment, click 'OK' to sort the data by rows. -
Conclusion
In this video, we covered various methods for sorting data in Excel, including basic and advanced techniques, the use of custom lists, and sorting by colors. Mastering these sorting options will significantly enhance your data management skills in Excel.
FAQ :
How do I sort text in Excel?
To sort text in Excel, right-click a cell in the column containing the text, point to 'Sort', and select either 'A to Z' for ascending order or 'Z to A' for descending order.
Can I sort dates in Excel?
Yes, to sort dates in Excel, right-click a cell in the column with dates, point to 'Sort', and choose 'Sort oldest to newest' or 'Sort newest to oldest'.
What is a custom list in Excel?
A custom list in Excel is a user-defined order for sorting data, allowing you to sort items in a specific sequence, such as days of the week or months of the year.
How can I sort by multiple columns in Excel?
To sort by multiple columns, click any cell in the range or table, go to the 'Data' tab, and click 'Sort'. In the sort dialog, you can add levels to sort by additional columns.
What should I do if I accidentally sorted my data incorrectly?
If you haven't saved your workbook since sorting, you can click the 'Undo' button on the Quick Access Toolbar or use the keyboard shortcut Ctrl + Z to revert the sort.
Quelques cas d'usages :
Organizing Product Inventory
A retail manager can use sorting features in Excel to organize product inventory by category and product name, making it easier to locate items and manage stock levels.
Scheduling Events
An event planner can sort a list of events by date to ensure that all activities are scheduled in chronological order, improving planning efficiency.
Analyzing Sales Data
A sales analyst can sort sales data by region and product type to identify trends and make informed decisions about marketing strategies.
Sorting Customer Feedback
A customer service manager can sort feedback by categories such as 'Positive', 'Negative', and 'Neutral' to quickly assess customer satisfaction and address issues.
Creating Custom Reports
A data analyst can create custom lists to sort data in specific orders for reports, such as sorting by priority levels or project phases, enhancing report clarity.
Glossaire :
Sort
The process of arranging data in a specific order, either alphabetically, numerically, or chronologically.
Range
A selection of two or more cells in a spreadsheet that can be manipulated as a single unit.
Column Header
A row at the top of a range of cells or a table that contains names for the columns, helping to identify the data contained within each column.
Custom List
A user-defined list that allows sorting data in a specific order that is not alphabetical, such as days of the week or months of the year.
Conditional Formatting
A feature in spreadsheet applications that allows users to apply specific formatting to cells based on certain conditions or criteria.
Undo
A command that reverses the last action taken in a software application, allowing users to revert changes.