Excel - Copy and remove conditional formatting Tutorial

In this video, you will learn how to copy and remove conditional formatting in Microsoft 365. The video covers the process of applying conditional formatting to a cell and demonstrates how to copy the formatting to other cells.
It also shows how to remove conditional formatting from specific cells and the entire worksheet.
This knowledge will help you effectively apply and manage conditional formatting in your Microsoft 365 documents.

1:11
1287 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - Manage conditional formatting

In this video, you will learn how to manage conditional formatting in Microsoft 365. The video covers the rules manager, where you can create, edit, and delete formatting rules for specific areas of a workbook or worksheet.
It also explains how to manage the precedence of rules when conflicting rules apply to cells.
By changing the order of the rules, you can control how cells are formatted based on their values.
The video also demonstrates how to use conditional formatting to sort and filter a worksheet based on the applied formatting.
This will help you effectively utilize conditional formatting in Microsoft 365 and improve your data analysis and visualization.

4:30
1950 views

Excel - Conditionally format text

In this video, you will learn about conditionally formatting text using Microsoft 365. The video covers the process of formatting text based on specific conditions, such as highlighting cells that meet certain criteria or applying different font styles to different values.
This feature is useful for visually organizing and analyzing data in Excel.
By mastering conditional formatting, you can enhance the visual appeal and readability of your spreadsheets, making it easier to identify trends and patterns.
This tutorial will provide you with step-by-step instructions on how to apply conditional formatting in Microsoft 365, helping you optimize your data analysis and presentation skills.

2:12
1250 views

Power BI - Conditional formatting

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.

1015 views

Excel - Take conditional formatting to the next level

In this video, you will learn how to take conditional formatting 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 for formatting and how to have more control over the type of formatting applied by creating new rules.
You will also learn how to format cells that are blank or contain errors.
This knowledge will help you enhance your data analysis and visualization skills using conditional formatting in Microsoft 365.

3:37
1274 views

Excel - Use formulas to apply conditional formatting

In this video, you will learn how to use formulas to apply conditional formatting in Microsoft 365. The video demonstrates selecting cells in the Product column and using a formula to format them based on the values in the In stock column.
By creating rules with different formulas, you can apply different fill colors to cells based on their values.
This tutorial will help you enhance your formatting skills and make your data more visually appealing.

4:20
1415 views

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Intermediate level

Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivot tables, and take advantage of all that Excel has to offer!

Your trainer for this course
Cours E-learning

204 vues

ALL COURSES