Excel - Use conditional formatting Tutorial

In this video, you will learn about using conditional formatting in Microsoft 365. Conditional formatting provides visual cues to help you make sense of your data by highlighting highs, lows, and other data trends based on specified criteria.
You can apply conditional formatting to specific cells, tables, pivot tables, and worksheets.
The video demonstrates how to quickly apply conditional formatting using the formatting button in the ribbon, 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 tutorial will help you enhance your data analysis skills and make your data more visually appealing.

2:02
1381 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

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.

1025 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
1290 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
1270 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
1432 views

Excel - Create a chart

In this video, you will learn how to create a chart using Microsoft 365. The video covers the process of selecting the cells you want to use for the chart, clicking the quick analysis button, and accessing the Charts tab.
Excel then displays recommended charts based on the selected data.
You can hover over each chart option to see which one looks best for your data.
The video demonstrates creating a clustered column chart, which is great for comparing data.
By following the steps in the video, you will be able to create eye-catching charts that make it easier to analyze your data.
This tutorial is essential for anyone using Microsoft 365 and looking to improve their data visualization skills.

0:52
1198 views

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Discovery level

Discover and familiarize yourself with Excel: from creating and using your tables to enhancing your visuals and collaboration. Our introductory Excel tutorials combine simplicity and efficiency!

Your trainer for this course
Cours E-learning

243 vues

ALL COURSES