Lists - Turn your Excel tables into real lists! Tutorial

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.

1:12
1574 views

Available in Microsoft365

DiLeaP AI: THIS MIGHT BE HELPFUL

Lists - Create a list from an Excel file

In this video, you will learn how to create a list from an Excel file using Microsoft Lists.
The video covers the steps to import raw data from an Excel workbook and turn it into a list.
You will start by opening the Excel file and using the "format as table" feature.
Then, you will upload the pre-formatted file in Microsoft Lists and select the tables you are interested in.
After making any necessary corrections to the data type, you will name your list and personalize it with a color and icon.
This tutorial will help you efficiently create lists from Excel files, enhancing your organization and data management.

1:42
1278 views

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
2047 views

Excel - Merge two columns

In this video, you will learn about merging two columns using Microsoft 365. The video covers the process of merging columns in Microsoft Excel and demonstrates how to do it step by step.
This will help you organize and manipulate data more efficiently in Excel using Microsoft 365.

3:27
782 views

OneNote - Make better tables

In this video, you will learn how to make better tables using Microsoft Excel.
The video covers the basics of table management, including formatting data, enhancing the appearance of worksheets, and automating data processing through functions and formulas.
By mastering these skills, you will be able to create organized and visually appealing tables, saving time and improving efficiency in your data processing.
This tutorial is perfect for beginners who want to familiarize themselves with the fundamentals of Microsoft Excel.

10 min
1150 views

Excel - Use table references

In this video, you will learn how to create a table in Microsoft Excel using the "Format as Table" function.
The video covers the steps to convert a range of cells into a table with its own style.
By selecting a style from the dropdown list and checking the "My table has headers" box, you can easily format your table.
The video also demonstrates how to name your table and change its design using the Table Tools contextual tab.
Additionally, it explains how to change the visual style of your table by selecting different color styles from the Table Styles group.
This tutorial will help you understand how to create and format tables in Excel, making your data more organized and visually appealing.

1:39
538 views