Excel - Use slicers to filter data Tutorial
In this video, you will learn how to use slicers to filter data in Power BI.
Slicers are simple forms of filters that play a key role in designing customized charts and reports.
By adding a slicer to your visualization pane and selecting a field, such as country or date, you can filter your data and see how it impacts your other visuals.
You can select one country at a time or use the control key to select multiple countries simultaneously.
The slicer can be further customized by activating single select, disabling multi-select, or showing the select all option.
Additionally, you can create a time slicer to filter data based on a range of dates or relative dates.
The video also covers how to reset filters, switch to relative dates, and sync slicers across different pages in your report.
By mastering slicers, you will be able to effectively filter and analyze your data in Power BI.
- 1:25
- 3644 views
-
Excel - Functions and formulas
- 3:24
- Viewed 4344 times
-
Excel - How to create a table
- 2:11
- Viewed 3872 times
-
Excel - Freeze panes in detail
- 3:30
- Viewed 3972 times
-
Excel - Create a PivotTable and analyze your data
- 1:35
- Viewed 4015 times
-
Excel - Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 4028 times
-
Excel - Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2766 times
-
Excel - Freeze or lock panes
- 1:06
- Viewed 3482 times
-
Excel - Create a PivotTable report manually
- 4:59
- Viewed 4416 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
-
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 3127 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
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1312 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 5598 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 5314 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
-
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 1673 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
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1312 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 document aims to provide a comprehensive guide on how to use slicers in Excel to filter data visually, specifically focusing on filtering gemstone sales by department store. It will cover the steps to insert slicers, filter data, and interpret the results effectively.
Chapitres :
-
Introduction to Slicers in Excel
Slicers are a powerful feature in Excel that allow users to filter data visually and interactively. This guide will walk you through the process of using slicers to filter gemstone sales data by department store, enhancing your data analysis capabilities. -
Inserting Slicers
To begin using slicers, follow these steps: 1. Navigate to the 'Design' tab in Excel. 2. Select 'Insert Slicer'. 3. In the dialog box that appears, check the boxes next to the 'Gemstone' and 'Department Store' fields. 4. Click 'OK'. Upon completion, two new slicer objects will appear on your worksheet: one for gemstones and another for department stores. -
Filtering Data with Slicers
Once the slicers are inserted, you can filter the data as follows: - Click on the 'Department Store' slicer and select the 'Cora' button. This action will filter the data to show only the gemstones sold in the Cora department store. - The data will automatically update, and you will notice that the silver and diamond buttons in the gemstone slicer are greyed out, indicating that these gemstones have not been sold in the selected department store. -
Analyzing Specific Gemstone Sales
To analyze the quantities of specific gemstones sold, such as sapphire and amber, perform the following steps: 1. Click on the 'Sapphire' button in the gemstone slicer. 2. While holding down the 'Control' key on your keyboard, click on the 'Amber' button. This simultaneous selection will filter the data to show the quantities of both sapphire and amber sold to the Cora department store. -
Clearing Filters
To remove the gemstone filter and view all data again: - Click on the 'Clear Filter' button located in the upper right corner of the gemstone slicer. - Repeat the same steps with the department store slicer to reset the filters for department stores. After clearing the filters, you will be able to view all slicers and data without any restrictions. -
Conclusion
Using slicers in Excel provides a dynamic way to filter and analyze data. By following the steps outlined in this guide, you can effectively manage and interpret your gemstone sales data by department store, allowing for better decision-making and insights.
FAQ :
What is a slicer in Excel?
A slicer is a visual filtering tool in Excel that allows users to filter data in a PivotTable or table easily. It provides buttons for quick selection of specific criteria.
How do I insert a slicer in Excel?
To insert a slicer in Excel, go to the Design tab, select 'Insert Slicer', check the boxes next to the fields you want to filter by, and then press OK.
What does it mean when buttons are greyed out in a slicer?
When buttons are greyed out in a slicer, it indicates that there are no corresponding data entries for those selections in the filtered dataset.
How can I filter multiple items in a slicer?
To filter multiple items in a slicer, hold down the Control key on your keyboard while clicking on the desired buttons in the slicer.
How do I clear filters in Excel?
To clear filters in Excel, click on the 'Clear Filter' button located in the upper right corner of the slicer or the filter dropdown.
Quelques cas d'usages :
Sales Analysis in Retail
Using slicers in Excel, retail managers can quickly analyze sales data by filtering for specific gemstones sold in various department stores. This allows for targeted marketing strategies based on product performance.
Inventory Management
Slicers can help inventory managers filter and view stock levels of specific gemstones across different department stores, enabling better inventory control and restocking decisions.
Customer Preference Tracking
By utilizing slicers, businesses can track customer preferences for gemstones in different department stores, helping to tailor product offerings and promotions to meet customer demand.
Performance Reporting
Slicers can be used in performance reports to filter data by department store or gemstone type, providing clear insights into sales trends and helping to identify areas for improvement.
Glossaire :
Slicer
A visual filter in Excel that allows users to segment and filter data in a PivotTable or table easily. Slicers provide buttons that can be clicked to filter data based on specific criteria.
PivotTable
A data processing tool in Excel that allows users to summarize, analyze, explore, and present data. It enables the organization of data into a more manageable format.
Department Store
A retail establishment that offers a wide range of products, including clothing, electronics, and household goods, typically organized into departments.
Gemstone
A precious or semi-precious stone that is cut and polished for use in jewelry. Examples include diamonds, sapphires, and amber.
Filter
A feature in Excel that allows users to display only the data that meets certain criteria, hiding the rest of the data.
Control Key
A key on the keyboard that, when pressed in combination with other keys, allows users to perform multiple actions simultaneously, such as selecting multiple items.
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