Power BI - Conditional formatting Tutorial
In this video, you will learn about conditional formatting and how to take it to the next level.
The video covers how to apply conditional formatting to specific cells, tables, pivot tables, and worksheets.
It demonstrates how to use the quick analysis option in the ribbon for quick formatting, as well as how to have more control over the formatting by creating new rules.
You can format cells based on their values, such as using icon sets, and even format cells that are blank or contain errors.
This will help you make sense of your data and easily identify trends or important information.
- 3:35
- 3363 views
-
Power BI - Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 4103 times
-
Power BI - Use the drill down filter
- 4:41
- Viewed 3311 times
-
Power BI - Create quick measures
- 3:02
- Viewed 3750 times
-
Power BI - Turn on the drill down feature
- 2:23
- Viewed 3019 times
-
Power BI - Create slicers
- 3:55
- Viewed 3752 times
-
Excel - Save your macro
- 2:59
- Viewed 3629 times
-
Power BI - Add an alert to a visual
- 2:24
- Viewed 2963 times
-
Power BI - What are measures?
- 2:58
- Viewed 2710 times
-
Creating a Report
- 2:54
- Viewed 9158 times
-
Introduction to Power Bi
- 1:29
- Viewed 6434 times
-
General Introduction
- 2:54
- Viewed 4839 times
-
Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 4103 times
-
Recovering your Data from different sources
- 3:26
- Viewed 3963 times
-
Introduction to Power BI Building Blocks
- 3:07
- Viewed 3860 times
-
Introduction to Power BI Desktop
- 2:52
- Viewed 3827 times
-
Create slicers
- 3:55
- Viewed 3752 times
-
Create quick measures
- 3:02
- Viewed 3750 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 3621 times
-
Introduction to Power BI Mobile
- 2:15
- Viewed 3542 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 3525 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 3522 times
-
Creating your Datasets
- 2:26
- Viewed 3506 times
-
Introduction to the Query Editor
- 2:33
- Viewed 3451 times
-
Customising your Visuals
- 2:58
- Viewed 3388 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 3337 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 3335 times
-
Use the drill down filter
- 4:41
- Viewed 3311 times
-
Calculate function
- 4:22
- Viewed 3241 times
-
Turn on the drill down feature
- 2:23
- Viewed 3019 times
-
Add an alert to a visual
- 2:24
- Viewed 2963 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 2942 times
-
Customising your Report
- 3:12
- Viewed 2923 times
-
Manage interactions
- 1:56
- Viewed 2917 times
-
Manage relations between data sources
- 2:37
- Viewed 2847 times
-
What are measures?
- 2:58
- Viewed 2710 times
-
Introduction to PowerBI
- 00:60
- Viewed 181 times
-
Remove a watermark
- 2:20
- Viewed 15508 times
-
Align flow chart shapes and add connectors
- 4:48
- Viewed 5247 times
-
Change font size, line spacing, and indentation
- 5:09
- Viewed 5131 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 4984 times
-
Ink Equation
- 0:41
- Viewed 4900 times
-
Insert items in a presentation
- 2:38
- Viewed 4879 times
-
Trigger text to play over a video
- 2:58
- Viewed 4861 times
-
Change list formatting on the slide master
- 5:22
- Viewed 4788 times
-
Convert handwritten texts or drawings with Powerpoint
- 0:33
- Viewed 4730 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 4718 times
-
How to add branching logic in Microsoft Forms
- 1:55
- Viewed 4680 times
-
3D Maps
- 1:41
- Viewed 4619 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 4554 times
-
Print Notes Pages as handouts
- 3:15
- Viewed 4436 times
-
Add headers and footers to slides
- 3:52
- Viewed 4395 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4366 times
-
Create a combo chart
- 1:47
- Viewed 4287 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4281 times
-
Add a "Date" field to your form or quiz in Microsoft Forms
- 1:06
- Viewed 4262 times
-
Add sound effects to an animation
- 4:29
- Viewed 4215 times
-
More complex formulas
- 4:17
- Viewed 4208 times
-
Manage conditional formatting
- 4:30
- Viewed 4181 times
-
Finalize and review a presentation
- 2:02
- Viewed 4179 times
-
Create a new slide master and layouts
- 5:13
- Viewed 4147 times
-
Animate charts and SmartArt
- 3:36
- Viewed 4147 times
-
Work with a motion path
- 2:50
- Viewed 4127 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4121 times
-
Add a sound effect to a transition
- 3:45
- Viewed 4114 times
-
Start using Excel
- 4:22
- Viewed 4104 times
-
Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 4103 times
-
Functions and formulas
- 3:24
- Viewed 4095 times
-
Manage drop-down lists
- 6:12
- Viewed 4076 times
-
New Chart types
- 1:52
- Viewed 4063 times
-
Customize the slide master
- 4:38
- Viewed 4059 times
-
The SUMIF function
- 5:27
- Viewed 4038 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4031 times
-
Prepare a basic handout
- 4:30
- Viewed 4028 times
-
Create a flow chart
- 3:27
- Viewed 4017 times
-
AVERAGEIF function
- 3:04
- Viewed 4003 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 3989 times
-
The SUM function
- 4:37
- Viewed 3972 times
-
Trigger an animation effect
- 2:29
- Viewed 3972 times
-
Using functions
- 5:12
- Viewed 3971 times
-
Advanced formulas and references
- 4:06
- Viewed 3953 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 3953 times
-
Look up values on a different worksheet
- 2:39
- Viewed 3935 times
-
Build an org chart using the text pane
- 4:00
- Viewed 3929 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 3906 times
-
Create slide content and save the template
- 4:50
- Viewed 3902 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 3899 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 3896 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 3863 times
-
Freeze panes in detail
- 3:30
- Viewed 3858 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3854 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 3854 times
-
Animate pictures, shapes, text, and other objects
- 4:02
- Viewed 3843 times
-
Customize charts
- 4:28
- Viewed 3840 times
-
Subtract time
- 3:58
- Viewed 3837 times
-
Add numbers
- 2:54
- Viewed 3835 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3827 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3820 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 3815 times
-
Work with macros
- 4:40
- Viewed 3811 times
-
Insert columns and rows
- 4:16
- Viewed 3795 times
-
Advanced filter details
- 4:13
- Viewed 3794 times
-
More print options
- 5:59
- Viewed 3794 times
-
Use slide masters to customize a presentation
- 3:07
- Viewed 3790 times
-
IF with AND and OR
- 3:35
- Viewed 3780 times
-
AutoFilter details
- 3:27
- Viewed 3772 times
-
Add a picture watermark
- 4:36
- Viewed 3757 times
-
Customize colors and save the theme
- 4:45
- Viewed 3753 times
-
Create an automated workflow for Microsoft Forms with Power Automate
- 5:09
- Viewed 3753 times
-
Create slicers
- 3:55
- Viewed 3752 times
-
Create quick measures
- 3:02
- Viewed 3750 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3749 times
-
Conditionally format dates
- 2:38
- Viewed 3745 times
-
Insert headers and footers
- 2:02
- Viewed 3740 times
-
Work with handout masters
- 4:34
- Viewed 3740 times
-
Create a template from a presentation
- 3:09
- Viewed 3739 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3737 times
-
Sort details
- 4:46
- Viewed 3733 times
-
Drop-down list settings
- 4:14
- Viewed 3730 times
-
Assign a button to a macro
- 2:49
- Viewed 3728 times
-
Backgrounds in PowerPoint: First Steps
- 3:20
- Viewed 3721 times
-
Animate pictures and shapes
- 4:17
- Viewed 3709 times
-
Input and error messages
- 2:52
- Viewed 3707 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3695 times
-
Print slides, notes, or handouts
- 2:48
- Viewed 3690 times
-
Header and footer details
- 3:41
- Viewed 3687 times
-
Change the theme background
- 5:38
- Viewed 3660 times
-
Basic math
- 2:28
- Viewed 3653 times
-
Create custom animations with motion paths
- 3:39
- Viewed 3650 times
-
Multiple choice questions in Microsoft Forms
- 2:14
- Viewed 3648 times
-
Copying formulas
- 3:00
- Viewed 3646 times
-
Operator order
- 2:04
- Viewed 3645 times
-
Customize the design and layouts
- 5:06
- Viewed 3645 times
-
Print handouts
- 4:32
- Viewed 3640 times
-
Screen recording
- 0:49
- Viewed 3635 times
-
Save your macro
- 2:59
- Viewed 3629 times
-
Picture backgrounds: Two methods
- 4:58
- Viewed 3628 times
-
Advanced IF functions
- 3:22
- Viewed 3592 times
-
Improved version history
- 0:51
- Viewed 3578 times
-
Creating and managing a group
- 1:56
- Viewed 3571 times
-
Copy a chart
- 2:59
- Viewed 3560 times
-
Measure how people feel about something with the Likert scale in Microsoft Forms
- 2:02
- Viewed 3550 times
-
How to create a table
- 2:11
- Viewed 3533 times
-
Cell references
- 1:34
- Viewed 3522 times
-
Customize master layouts
- 4:57
- Viewed 3518 times
-
Use conditional formatting
- 2:02
- Viewed 3513 times
-
Weighted average
- 2:06
- Viewed 3511 times
-
Add formulas and references
- 2:52
- Viewed 3505 times
-
One click Forecasting
- 1:01
- Viewed 3476 times
-
Conditionally format text
- 2:12
- Viewed 3474 times
-
Removing backgrounds in PowerPoint
- 2:45
- Viewed 3472 times
-
Use slicers to filter data
- 1:25
- Viewed 3468 times
-
Save time by creating your form with quick import
- 2:20
- Viewed 3466 times
-
Add headers and footers to a presentation
- 2:50
- Viewed 3461 times
-
Combine a path with other effects
- 4:49
- Viewed 3460 times
-
Apply and change a theme
- 5:13
- Viewed 3452 times
-
Manage Your Working Time in MyAnalytics
- 0:34
- Viewed 3440 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3423 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3419 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3410 times
-
Nested IF functions
- 3:30
- Viewed 3393 times
-
90 seconds about PowerPoint Slide Masters
- 1:17
- Viewed 3393 times
-
Freeze or lock panes
- 1:06
- Viewed 3376 times
-
Edit headers and footers for handouts
- 2:43
- Viewed 3372 times
-
Average a group of numbers
- 2:01
- Viewed 3357 times
-
Prepare and run your presentation
- 1:28
- Viewed 3351 times
-
Design motion paths
- 2:30
- Viewed 3336 times
-
Ink Equation
- 0:40
- Viewed 3331 times
-
Drop-down lists
- 0:55
- Viewed 3329 times
-
Add staff members
- 2:57
- Viewed 3318 times
-
Create an org chart
- 3:09
- Viewed 3317 times
-
Use the drill down filter
- 4:41
- Viewed 3311 times
-
New chart types
- 0:39
- Viewed 3309 times
-
Build an org chart using SmartArt Tools
- 5:09
- Viewed 3300 times
-
Apply paths to layered pictures
- 5:28
- Viewed 3294 times
-
Edit a macro
- 3:29
- Viewed 3290 times
-
Animate text
- 4:14
- Viewed 3285 times
-
Sort and filter data
- 1:38
- Viewed 3250 times
-
Create a sequence with line paths
- 6:42
- Viewed 3246 times
-
Calculate function
- 4:22
- Viewed 3241 times
-
Present Live
- 3:13
- Viewed 3164 times
-
Make a reservation [Staff]
- 1:55
- Viewed 3137 times
-
Add bullets to text
- 2:24
- Viewed 3073 times
-
Create a new calendar
- 2:55
- Viewed 3066 times
-
Trigger a video
- 4:06
- Viewed 3060 times
-
Start using PowerPoint
- 2:06
- Viewed 3022 times
-
Turn on the drill down feature
- 2:23
- Viewed 3019 times
-
Turn your Excel tables into real lists!
- 1:12
- Viewed 2982 times
-
Integrate Bookings into TEAMS
- 1:36
- Viewed 2980 times
-
Add an alert to a visual
- 2:24
- Viewed 2963 times
-
Manage interactions
- 1:56
- Viewed 2917 times
-
Manage relations between data sources
- 2:37
- Viewed 2847 times
-
Make a reservation [Customer]
- 2:13
- Viewed 2843 times
-
Complete and Share a Schedule
- 2:02
- Viewed 2815 times
-
Create custom fields
- 1:21
- Viewed 2808 times
-
Create a Schedule and Organise it with the Help of Groups
- 1:42
- Viewed 2764 times
-
Add a service
- 2:03
- Viewed 2763 times
-
Import, create, edit and share documents
- 2:35
- Viewed 2761 times
-
Research in your notes
- 1:13
- Viewed 2760 times
-
What are measures?
- 2:58
- Viewed 2710 times
-
Use template to prepare your Agile SCRUM meeting
- 2:50
- Viewed 2690 times
-
Organise notes
- 2:57
- Viewed 2677 times
-
Create and organise a group
- 1:30
- Viewed 2673 times
-
Get a rating in Microsoft Forms
- 1:32
- Viewed 2653 times
-
Create a Microsoft Forms form directly in OneDrive
- 1:33
- Viewed 2628 times
-
Easily measure user experience with Net Promoter Score in Microsoft Forms
- 1:32
- Viewed 2605 times
-
How Clock In Works
- 0:22
- Viewed 2598 times
-
Manage our recent documents
- 2:24
- Viewed 2550 times
-
Make better tables
- 10 min
- Viewed 2549 times
-
Create your first form or quiz in Microsoft Forms
- 2:12
- Viewed 2545 times
-
Add a Visio diagram
- 1:23
- Viewed 2518 times
-
Access other apps aroud Office 365
- 1:10
- Viewed 2515 times
-
Creating and managing campaigns
- 1:39
- Viewed 2509 times
-
Draw, sketch or handwrite notes
- 1:25
- Viewed 2461 times
-
Send your notes by email
- 0:42
- Viewed 2455 times
-
Password protect your notes
- 1:43
- Viewed 2446 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2442 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2415 times
-
Create a new shared booking page
- 2:32
- Viewed 2361 times
-
Save, share and share everything
- 0:49
- Viewed 2341 times
-
Insert online videos
- 0:41
- Viewed 2312 times
-
Add an Excel spreadsheet
- 1:31
- Viewed 2308 times
-
Imbrication OneNote / Teams
- 1:03
- Viewed 2296 times
-
Creating or editing office documents in Engage
- 0:44
- Viewed 2273 times
-
Add files
- 1:26
- Viewed 2263 times
-
See who's collaborating
- 2:01
- Viewed 2256 times
-
Add items
- 2:04
- Viewed 2229 times
-
Imbrication OneNote / Outlook
- 1:37
- Viewed 2223 times
-
Text before & after Function
- 4:57
- Viewed 2216 times
-
How to Copy a Schedule
- 0:39
- Viewed 2204 times
-
Sync and sharing
- 0:28
- Viewed 2190 times
-
Upload an existing video from your device
- 1:11
- Viewed 2184 times
-
Find out your coworkers’ preferences by creating a “Ranking” question in Microsoft Forms
- 2:14
- Viewed 2181 times
-
Make a reservation Employee]
- 1:50
- Viewed 2179 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 2163 times
-
Use formatting toolbar and styles to format forms and quizzes
- 1:55
- Viewed 2162 times
-
Use page templates
- 2:19
- Viewed 2160 times
-
Add staff
- 2:36
- Viewed 2148 times
-
Install Office on 5 devices
- 1:53
- Viewed 2134 times
-
Create a video from the web app
- 1:20
- Viewed 2119 times
-
Meeting recordings in Microsoft Teams
- 1:13
- Viewed 2089 times
-
Create a video from the mobile app
- 1:13
- Viewed 2067 times
-
Add or edit a thumbnail
- 0:59
- Viewed 2067 times
-
Record a live PowerPoint presentation
- 1:18
- Viewed 2062 times
-
Use "Text" fields to create a contact form
- 2:16
- Viewed 2055 times
-
Let responders submit files in Microsoft Forms
- 1:58
- Viewed 2043 times
-
Create custom fields
- 1:12
- Viewed 1995 times
-
Change chart type
- 1:29
- Viewed 1917 times
-
Engaging and animating a group
- 1:55
- Viewed 1857 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 1840 times
-
Send a single form in multiple languages
- 1:21
- Viewed 1803 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 1697 times
-
Make a reservation [Customer]
- 1:51
- Viewed 1692 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1629 times
-
Save a PowerPoint presentation
- 1:10
- Viewed 1595 times
-
Add a service
- 2:28
- Viewed 1566 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 1548 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 1415 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 1385 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 1334 times
-
Draft an Email with Copilot
- 2:35
- Viewed 1265 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1217 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 1148 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 1076 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 1058 times
-
Format Data with Copilot
- 1:52
- Viewed 1013 times
-
Optimize Email Writing with Copilot Coaching
- 1:41
- Viewed 1011 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 991 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 977 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 925 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 427 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 392 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 361 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 359 times
-
Create different types of events
- 01:46
- Viewed 310 times
-
Create a reminder for yourself
- 01:59
- Viewed 303 times
-
Create and add a signature to messages
- 01:26
- Viewed 297 times
-
Save and Print a Message
- 01:48
- Viewed 292 times
-
Sort and filter emails
- 02:51
- Viewed 287 times
-
Make changes to a text
- 01:05
- Viewed 285 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 278 times
-
Change the default font of your emails
- 01:05
- Viewed 275 times
-
Manage Teams online meeting options
- 01:56
- Viewed 271 times
-
Edit and customize views
- 01:55
- Viewed 270 times
-
Create an Email Template
- 01:40
- Viewed 263 times
-
Improve Email Accessibility
- 02:02
- Viewed 256 times
-
Search options
- 01:23
- Viewed 251 times
-
Generating Loop Content with Copilot
- 01:18
- Viewed 244 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 233 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 229 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 228 times
-
Translate Emails in Outlook
- 01:32
- Viewed 224 times
-
Generate formulas from a concept
- 01:02
- Viewed 221 times
-
Delay Email Delivery
- 01:10
- Viewed 220 times
-
Summarizing a Loop Page with Copilot
- 00:55
- Viewed 212 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 210 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 197 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 195 times
-
Initiate a project budget tracking table with Copilot
- 02:54
- Viewed 60 times
-
Develop and share a clear project follow-up with Copilot
- 02:18
- Viewed 65 times
-
Organize an action plan with Copilot and Microsoft Planner
- 01:31
- Viewed 80 times
-
Structure and optimize team collaboration with Copilot
- 02:28
- Viewed 75 times
-
Copilot at the service of project reports
- 02:36
- Viewed 66 times
-
Initiate a tracking table with ChatGPT
- 01:35
- Viewed 64 times
-
Distribute tasks within a team with ChatGPT
- 01:26
- Viewed 106 times
-
Generate a meeting summary with ChatGPT
- 01:24
- Viewed 68 times
-
Project mode
- 01:31
- Viewed 70 times
-
Create an agent for a team
- 01:53
- Viewed 119 times
-
Install and access Copilot Studio in Teams
- 01:38
- Viewed 121 times
-
Analyze the Copilot Studio agent
- 01:25
- Viewed 67 times
-
Publish the agent and make it accessible
- 01:39
- Viewed 122 times
-
Copilot Studio agent settings
- 01:33
- Viewed 65 times
-
Add new actions
- 01:54
- Viewed 118 times
-
Create a first action
- 01:59
- Viewed 115 times
-
Manage topics
- 01:51
- Viewed 94 times
-
Manage knowledge sources
- 01:11
- Viewed 64 times
-
Create an agent with Copilot Studio
- 01:52
- Viewed 111 times
-
Access Copilot Studio
- 01:09
- Viewed 111 times
-
Get started with Copilot Studio
- 01:25
- Viewed 62 times
-
Introduction to PowerBI
- 00:60
- Viewed 181 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 172 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 173 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 178 times
-
Introduction to Planner
- 00:56
- Viewed 185 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 174 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 182 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 246 times
-
Introduction to Sway
- 01:53
- Viewed 157 times
-
Introducing to Word
- 01:00
- Viewed 177 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 160 times
-
Create a call group
- 01:15
- Viewed 224 times
-
Use call delegation
- 01:07
- Viewed 144 times
-
Assign a delegate for your calls
- 01:08
- Viewed 221 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 145 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 136 times
-
Manage advanced call notifications
- 01:29
- Viewed 152 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 184 times
-
Block unwanted calls
- 01:24
- Viewed 149 times
-
Disable all call forwarding
- 01:09
- Viewed 157 times
-
Manage a call group in Teams
- 02:01
- Viewed 144 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 141 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 136 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 159 times
-
Manage voicemail messages
- 01:55
- Viewed 208 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 225 times
-
Customize your voicemail greeting
- 02:17
- Viewed 134 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 135 times
-
Manage simultaneous calls
- 01:52
- Viewed 145 times
-
Support third-party apps during calls
- 01:53
- Viewed 178 times
-
Add participants quickly and securely
- 01:37
- Viewed 142 times
-
Configure call privacy and security settings
- 02:51
- Viewed 140 times
-
Manage calls on hold
- 01:20
- Viewed 149 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 140 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 148 times
-
Draft a Service Memo
- 02:33
- Viewed 194 times
-
Extract Invoice Data and Generate a Pivot Table
- 03:26
- Viewed 183 times
-
Formulate a Request for Pricing Conditions via Email
- 02:32
- Viewed 267 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:41
- Viewed 236 times
-
SharePoint Page Co-Editing: Collaborate in Real Time
- 02:14
- Viewed 95 times
-
Other Coaches
- 01:45
- Viewed 194 times
-
Agents in SharePoint
- 02:44
- Viewed 157 times
-
Prompt coach
- 02:49
- Viewed 180 times
-
Modify, Share, and Install an Agent
- 01:43
- Viewed 171 times
-
Configure a Copilot Agent
- 02:39
- Viewed 166 times
-
Describe a copilot agent
- 01:32
- Viewed 190 times
-
Rewrite with Copilot
- 01:21
- Viewed 163 times
-
Analyze a video
- 01:21
- Viewed 189 times
-
Use the Copilot pane
- 01:12
- Viewed 181 times
-
Process text
- 01:03
- Viewed 169 times
-
Create an insights grid
- 01:19
- Viewed 284 times
-
Generate and manipulate an image in PowerPoint
- 01:47
- Viewed 178 times
-
Interact with a web page with Copilot
- 00:36
- Viewed 202 times
-
Create an image with Copilot
- 00:42
- Viewed 297 times
-
Summarize a PDF with Copilot
- 00:41
- Viewed 193 times
-
Analyze your documents with Copilot
- 01:15
- Viewed 192 times
-
Chat with Copilot
- 00:50
- Viewed 180 times
-
Particularities of Personal and Professional Copilot Accounts
- 00:40
- Viewed 274 times
-
Data Privacy in Copilot
- 00:43
- Viewed 194 times
-
Access Copilot
- 00:25
- Viewed 298 times
-
Use a Copilot Agent
- 01:24
- Viewed 202 times
-
Modify with Pages
- 01:20
- Viewed 206 times
-
Generate and manipulate an image in Word
- 01:19
- Viewed 199 times
-
Create Outlook rules with Copilot
- 01:12
- Viewed 193 times
-
Generate the email for the recipient
- 00:44
- Viewed 184 times
-
Action Function
- 04:18
- Viewed 149 times
-
Search Function
- 03:42
- Viewed 201 times
-
Date and Time Function
- 02:53
- Viewed 182 times
-
Logical Function
- 03:14
- Viewed 276 times
-
Text Function
- 03:25
- Viewed 210 times
-
Basic Function
- 02:35
- Viewed 175 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 200 times
-
Introduction to Power Fx
- 01:09
- Viewed 176 times
-
The New Calendar
- 03:14
- Viewed 299 times
-
Sections
- 02:34
- Viewed 186 times
-
Customizing Views
- 03:25
- Viewed 180 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 298 times
-
Guide to Using the Microsoft Authenticator App
- 01:47
- Viewed 196 times
-
Turn on Multi-Factor Authentication in the Admin Section
- 02:07
- Viewed 155 times
-
Manual Activation of Multi-Factor Authentication
- 01:40
- Viewed 111 times
-
Concept of Multi-Factor Authentication
- 01:51
- Viewed 188 times
-
Use the narrative Builder
- 01:31
- Viewed 235 times
-
Microsoft Copilot Academy
- 00:42
- Viewed 194 times
-
Connect Copilot to a third party app
- 01:11
- Viewed 205 times
-
Share a document with copilot
- 00:36
- Viewed 195 times
-
Configurate a page with copilot
- 01:47
- Viewed 194 times
-
Use Copilot with Right-Click
- 01:45
- Viewed 968 times
-
Draft a Service Memo with Copilot
- 02:21
- Viewed 208 times
-
Extract Invoice Data and Generate a Pivot Table
- 02:34
- Viewed 236 times
-
Summarize Discussions and Schedule a Meeting Slot
- 02:25
- Viewed 299 times
-
Formulate a Request for Pricing Conditions via Email
- 02:20
- Viewed 368 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:52
- Viewed 349 times
Objectifs :
This tutorial aims to teach users how to apply conditional formatting to visuals in a report, specifically focusing on changing colors based on data values to enhance data interpretation.
Chapitres :
-
Introduction to Conditional Formatting
In this tutorial, we will explore how to apply conditional formatting to visuals in a report. Conditional formatting allows us to visually represent data in a way that highlights important trends and values, making it easier to interpret. -
Applying Conditional Formatting to Sales Revenue Visual
We start by selecting the 'Month to Month Percentage Change in Sales Revenue' visual on the left side. This visual displays a list of months along with colored bars representing sales revenue changes. Our goal is to format these bars to show red for negative values and green for positive values. -
Steps to Format Data Colors
To apply the desired formatting, follow these steps: 1. **Access the Visualizations Pane**: Click on the format button in the visualizations pane. 2. **Navigate to Data Colors**: Go to the 'Data Color' section. 3. **Disable Show All**: Uncheck the 'Show All' option to avoid manually changing colors for each month. 4. **Set Default Color**: Click on the FX button to open a pop-up window for formatting by categories. 5. **Choose Rules**: Select 'Rules' as the formatting option. 6. **Select Measure**: Choose the measure 'Sales Revenue Month to Month Percentage'. 7. **Define Rules**: - For positive values, set the rule: if the value is greater than or equal to 0, choose green. - For negative values, set the rule: if the value is less than 0, choose red. 8. **Apply Colors**: Use the 'More Colors' option to select custom colors if needed. 9. **Finalize**: Click OK to apply the changes. -
Applying Conditional Formatting to Tables
Next, we will apply conditional formatting to a table visual that lists countries and their delivered quantities. Here’s how: 1. **Select the Table Visual**: Click on the visual displaying countries and quantities. 2. **Access the Format Button**: Go back to the format button. 3. **Conditional Formatting Section**: Under the conditional formatting section, apply the rule to the total quantity value instead of individual countries. 4. **Activate Data Bars**: Enable the data bars feature. 5. **Set Colors for Bars**: Adjust the colors for positive and negative bars. You can choose a light green for positive values and leave the negative bar as is or select a different color. 6. **Apply Changes**: Press OK to finalize the formatting. -
Conclusion
In this tutorial, we learned how to apply conditional formatting to different visuals, enhancing the clarity and interpretability of data. By using color coding based on data values, we can quickly identify trends and make informed decisions based on the visualized information.
FAQ :
What is conditional formatting?
Conditional formatting is a feature that allows users to change the appearance of visual elements in a report based on specific conditions or rules, such as changing colors for positive and negative values.
How do I apply conditional formatting to a visual?
To apply conditional formatting, select the visual, go to the format button in the visualizations pane, navigate to the data color section, and set rules based on the values you want to format.
Can I customize colors in conditional formatting?
Yes, you can customize colors in conditional formatting by selecting 'more colors' in the color selection pane to choose your preferred color.
What are data bars in tables?
Data bars are visual indicators within table cells that represent the magnitude of values, allowing for quick visual comparisons of data.
What types of rules can I set for conditional formatting?
You can set various rules, such as specifying that values greater than or equal to a certain number should be displayed in one color, while values less than that number are displayed in another color.
Quelques cas d'usages :
Sales Performance Reporting
In a sales report, conditional formatting can be used to highlight months with negative sales growth in red and positive growth in green, allowing stakeholders to quickly identify trends.
Inventory Management
Using conditional formatting in inventory reports can help visualize stock levels, where low stock items are highlighted in red, prompting timely restocking actions.
Financial Analysis
In financial dashboards, conditional formatting can be applied to highlight profit margins, where margins below a certain threshold are marked in red, indicating areas needing attention.
Performance Dashboards
Conditional formatting can enhance performance dashboards by visually representing key performance indicators (KPIs), making it easier for managers to assess team performance at a glance.
Project Management
In project management tools, conditional formatting can be used to indicate project statuses, where overdue tasks are highlighted in red, helping teams prioritize their work effectively.
Glossaire :
Conditional Formatting
A feature in data visualization tools that allows users to change the appearance of a visual based on certain conditions or rules, such as changing colors based on value thresholds.
Visualizations Pane
A section in data visualization software where users can select and customize different visual elements for their reports, such as charts and graphs.
Data Color Section
A part of the formatting options in visualization tools where users can set colors for data points based on specific criteria.
FX Button
A button in data visualization software that allows users to apply advanced formatting options, such as rules-based color changes.
Rules
Conditions set by the user to determine how data should be formatted, such as specifying that values above a certain threshold should be displayed in a specific color.
Measure
A quantitative value that can be analyzed, such as sales revenue or quantities delivered, often used in data visualizations.
Data Bars
Visual indicators in tables that represent the magnitude of values, often displayed as colored bars within the cells.