Excel - Conditionally format dates Tutorial

In this video, you will learn how to conditionally format dates in Microsoft 365. The video covers the process of highlighting overdue tasks in red, tasks due in a week or more in green, and tasks due within seven days in yellow.
This will help you easily identify and track the status of tasks based on their due dates.

2:38
1258 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

To Do - Add dates and deadlines to your tasks

In this video, you will learn how to add dates and deadlines to your tasks in Microsoft 365. The video covers the process of scheduling tasks, setting due dates, and adding reminders.
Tasks are ranked according to their deadlines, with the most urgent tasks appearing first.
You can also customize the due dates and add tasks to different lists.
Adding reminders and additional details to tasks is also demonstrated.
This tutorial will help you effectively manage your tasks and stay organized in Microsoft 365.

906 views

To Do - Create a new task in To Do

In this video, you will learn how to create a new task in Microsoft To Do.
The video covers the steps to create a task in To Do, including adding a title, due date, and notes.
This will help you stay organized and manage your tasks effectively using Microsoft To Do.

999 views

Outlook - Presentation of the task module

In this video, you will learn about the task module in Microsoft Outlook.
The module allows you to combine and improve your to-do lists with reminders and follow-ups.
You can access your tasks by clicking on the icon in the Navigation at the bottom left.
The video covers how to navigate the module, change the display, customize views, mark tasks as completed, and utilize different available views.
This will help you better organize and manage your tasks in Outlook.

3:31
1085 views

Excel - Use conditional formatting

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
1380 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.

1025 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

220 vues

ALL COURSES