Excel - Drop-down lists Tutorial

In this video, you will learn about drop-down lists in Microsoft 365. The video covers how to create drop-down lists in Excel to limit the entries people can make in a cell.
By selecting the cell, a drop-down list arrow appears, allowing you to make a selection.
To create drop-down lists, you need to select the cells, go to the Data tab on the ribbon, click Data Validation, set Allow to list, enter the text or numbers in the Source field, and click OK.
Using drop-down lists can help improve data entry accuracy and efficiency.
This tutorial will guide you through the process of creating drop-down lists in Excel, enhancing your data management skills.

0:55
1281 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - Drop-down list settings

In this video, you will learn about drop-down list settings in Microsoft 365. The video covers how to use drop-down lists in Excel and SharePoint to create interactive forms and improve data entry efficiency.
This will help you create more organized and user-friendly spreadsheets and websites.

4:14
1572 views

Excel - Manage drop-down lists

In this video, you will learn how to manage drop-down lists in Excel.
The video covers various techniques such as hiding and unhiding columns or rows, password protecting worksheets, locking specific cells, editing and deleting dropdown list options, and managing named ranges.
This knowledge will help you effectively organize and control data in your Excel spreadsheets.

6:12
1525 views

Lists - Turn your Excel tables into real lists!

In this video, you will learn how to turn your Excel tables into real lists using Microsoft 365. The video covers the process of converting tables into lists and demonstrates the steps to follow.
This will help you optimize your Excel data and improve your productivity.

1194 views

Excel - Cell references

In this video, you will learn about cell references in Microsoft 365. The video covers how to use cell references in Excel to link and manipulate data across different cells and worksheets.
This will help you improve your data analysis and organization skills in Microsoft 365.

1:34
1313 views

Excel - Create dynamic drop down lists

In this video, you will learn how to create dynamic drop-down lists using Microsoft 365. The video covers the process of extracting a list of sellers from an order board and creating a dropdown list that includes each seller only once.
It demonstrates the use of Excel functions such as UNIQUE and SORT to organize the list alphabetically.
The video also explains how to set up the dropdown list using the built-in validation feature in Excel.
By using dynamic matrix functions, the dropdown list can accommodate new sellers added to the order sheet.
This tutorial will help you create efficient and flexible drop-down lists for your data management needs.

540 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