Lists - Create a list from an Excel file Tutorial

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.

887 views

An error occurred while attempting to play the video

We recommend
Lists

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

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.

1196 views

Excel - Start using Excel

In this video, you will learn how to start using Excel.
The video covers the basics of opening Excel, creating a blank workbook, navigating the worksheet, entering data, formatting cells, adding a header row, converting data to a table, and exploring the ribbon and contextual tabs.
This tutorial will help you get started with Excel and create a simple worksheet to track expenses or other data.

4:22
1503 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.

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

788 views

Excel - How to create a table

In this video, you will learn how to create a table in Microsoft Excel.
The video demonstrates using the "Format as Table" function to quickly 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 shows how to name your table and change its design using the Table Tools contextual tab.
Additionally, you can change the visual style of your table by selecting different color styles from the Table Styles group.
This feature is especially useful when dealing with tables that have many columns.
Overall, this tutorial will help you create and format tables efficiently in Excel.

2:11
1256 views

RELATED COURSES This tutorial is part of the following courses

Microsoft Lists Video Training - Create Smart Lists

Learn about Microsoft Lists, the latest app in the Microsoft 365 solution, which allows you to create smart lists to track and collect information or tasks through a logical progression of video tutorials.

1141 vues

ALL COURSES