How to use Microsoft Lists

Ғылым және технология

In this step-by-step tutorial video, learn how to use Microsoft Lists. Microsoft Lists is a Microsoft 365 app that helps you track information and organize work. List are simple, smart, and flexible, so you can stay on top of what matters most to your team. Track issues, assets, routines, contacts, inventory and more using customizable views and smart rules and alerts to keep everyone in sync. With ready-made templates, you can quickly start lists online, on our new mobile app, or with Microsoft Teams. And because it’s part of Microsoft 365, you can rely on enterprise-ready security and compliance.
0:00 Introduction
0:44 What's unique about Lists?
2:01 Example use cases for Lists
2:17 Difference between Lists, Planner & To Do
2:57 Competition and evolution of SharePoint Lists
3:31 How to get Microsoft Lists via Office.com
4:28 How to get Microsoft Lists in Teams
5:09 Start page
6:30 Create a new list
9:09 Adding columns
12:00 Adding data
12:24 Add data via form
12:58 Add data via grid view
13:40 Share list with others
14:24 Conditional formatting
15:58 Column totals
16:25 Visualizing data in calendar and card views
17:16 Filtering and permissions
17:30 Alerts, notifications & rules
18:34 Connecting to Power Automate & Power Apps
19:54 Lists mobile experience
20:08 Wrap up
Resources called out:
- How to use Power Automate: • Power Automate Tutoria...

Пікірлер: 515

  • @KevinStratvert
    @KevinStratvert3 жыл бұрын

    ⏭ Here's a playlist with all my content on Microsoft SharePoint: kzread.info/head/PLlKpQrBME6xLB0wtdoFraKMzavqFSPp7I

  • @HongKong1842

    @HongKong1842

    3 жыл бұрын

    Oh. No wonder. I use 2 android phones. Thanks.

  • @RiskWell
    @RiskWell3 жыл бұрын

    This is fantastic. I haven’t been using Lists at all because we already use Planner on my team and I didn’t know how Lists was different. I’m changing the workflow for our team based on your video. Thank you!

  • @DangerAware
    @DangerAware3 жыл бұрын

    I am instrumental in a new startup that has applied for non-profit status. Kevin has impressed me so much I am recommending his videos for training our small crew. I am in Colorado and the Organization is in Fresno California. I just set up MS 365 on four laptops to get us started and Lists is going to be instrumental with our communications and collaborations. Thanks Kevin.

  • @Soulenergy31
    @Soulenergy31 Жыл бұрын

    Thank you, Kevin, you Rock!!!!!!!!!!!! 16:43 switching the view of the SP list 17:27 setting permission to the SP list 17:35 right click to send an alert on the item ( when it is changed) 18:57 create a power automate to create a flow

  • @francoislepron2301

    @francoislepron2301

    Жыл бұрын

    @Saul Espinoza Do you have an updated link onto Microsoft Lists since I have problem with a calculated column formula. I have tried a lot of combinations for the syntax but when I hit the save button for the new column created with the Use Calculated Value checkbox checked and with default value filled with the formula " = ["01/2023"] + ["02/2023"]" for instance, I have at the bottom of the creation pane : "A formula has s spelling mistake or refers to a column that does not exist." and the columns 01/2023 and 02/2023 exist in my list. I you have help on this topic, I would really appreciate. Thx.

  • @bobbyman410
    @bobbyman4103 жыл бұрын

    Lists, To Do and Planner. Microsoft has made a mess. You finally made it clear for me. Keep up the good work. You are a life-saver. You deserve a million subscribers, with the content you have.

  • @chair56789

    @chair56789

    3 жыл бұрын

    Agreed. Planner is quite good but why so many apps?

  • @floryhawk7027

    @floryhawk7027

    3 жыл бұрын

    @@chair56789 Yep. Am new to teams, and I've spent several days setting up multiple teams, but STILL can't figure out how to integrate Lists, Planner, calendar and To Do. Can't tell how to (easily) share between them. Don't want to onboard my teams and train them without determining best work flow. So frustrating! Help Kevin!!! :)

  • @wheres_bears1378

    @wheres_bears1378

    Жыл бұрын

    Glad I’m not the only one confused, seems like they have a bunch of apps that compete with each other instead of working together

  • @bbronson1978
    @bbronson19783 жыл бұрын

    Thanks for this! I look forward to more videos about list setting up a ticketing system and possibly using power automate

  • @louisvillegeek8257
    @louisvillegeek82573 жыл бұрын

    Thank you, Kevin! As always, your video was easy to follow and super informative.

  • @FeistyMimi024
    @FeistyMimi0242 күн бұрын

    You’re a GREAT teacher! Is there ANYTHING tech-related you DONT know? 😁

  • @whyme1025
    @whyme10253 жыл бұрын

    Awesome!! There's finally a big jump of lists. Thanks for sharing.

  • @shawnfanchette
    @shawnfanchette3 жыл бұрын

    Wow that was the best tutorial on Lists I’ve seen so far! Thank you for demystifying this tool for me!

  • @jackieizurieta-ferreira2036
    @jackieizurieta-ferreira20363 жыл бұрын

    This channel is top notch ! Great Information that makes things simple. Thank you Kevin

  • @KhalidMahida
    @KhalidMahida3 жыл бұрын

    Very useful and the strength is flexibility to various tasks. I have been using Excel for enlisting and describing my literature, but this is more productive. Thank you again Kevin.

  • @jonathanwoodruff1675
    @jonathanwoodruff16753 жыл бұрын

    Your energy and the easy way you explain everything is so great. I am really trying to help move our small HR department from just Excel to this Office 365 and to improve our processes by getting the most out of what we already have. I see the potential, but I have a lot to learn about Power Automate and Power Apps among everything else. I always come back to your videos. Is there any way you can do some of these things from an HR angle? Thanks for what you do.

  • @TheHunter-sq1ug
    @TheHunter-sq1ug3 жыл бұрын

    I'm lovin' the frequency of vids!

  • @kylieb4836
    @kylieb4836Ай бұрын

    I’m an operations manager - had no idea Lists was an option ( face-palm moment)This has just Changed my workflow dramatically - I’ve used Notion and so many other forms to keep me organised - embarrassed but so excited.

  • @hct-tech
    @hct-tech3 жыл бұрын

    nice, I try to watch one of your videos every day. It benefits me. Thanks for providing information about Softwares

  • @ecilota
    @ecilota3 жыл бұрын

    Hey Kevin , great content you create! I'm struggling to create formulas in Lists, all information is outdated and I can't seem to find a guide that explains how to create formulas like adding the values of two columns in aa third one or diving the values of two columns and placing it in a third one ;) I would appreciate guidance or if you have a video made about this? Thank you

  • @jennamilleryall
    @jennamilleryall3 жыл бұрын

    THANK YOU !!!! Thank you so much for this channel!

  • @TheKarenjh
    @TheKarenjh3 жыл бұрын

    Kevin! You’re my fave.

  • @paddlestandingup
    @paddlestandingup3 жыл бұрын

    Wasn't that interested in Lists until I watched this. Very nice presentation Kevin.

  • @stevehroncich9993
    @stevehroncich99933 жыл бұрын

    Hey Kevin, Your tutorial on Lists was great, keep up the good work...

  • @nestorgonzalez9811
    @nestorgonzalez98113 жыл бұрын

    Great work on the voice over while showing content, flow felt good and it was very informative and looking forward to a future video's on short cuts and cool tips for this app. Thank you for this.

  • @sweetpickel
    @sweetpickel3 жыл бұрын

    I've never heard of MS Lists, but am thinking it could solve an issue I'm pondering. Great tutorial (as always)!! I'm off to learn about Power Automate 😃 Thanks so much, Kevin!

  • @zzzzzzzzzzzzzzzz9
    @zzzzzzzzzzzzzzzz93 жыл бұрын

    Just started using it. Keen to see some good practices

  • @minhsieh
    @minhsieh2 жыл бұрын

    Kevin, this really helped with with getting started. I wanted to know what it does before I invest time in this. In principle I see a online platform to host a traditional Excel list. The beauty is that there is not messing with the "framework" of the list as it often happens in Excel. In my 20 years of working in Excel I have seen my fair share of crazy lists. I call this Excel abuse. I will give this a try ... let's see if this sticks.

  • @vivekkawale777
    @vivekkawale7773 жыл бұрын

    Appreciate your efforts Kevin. Very informative video and nicely explained.

  • @stephanweaver1960
    @stephanweaver19603 жыл бұрын

    Good summary of lists, with quick examples and distinction s that help round out the definition

  • @javidiaz7071
    @javidiaz70713 жыл бұрын

    Thanks for this video Kevin. Super helpful to take advantage of MS tools :)

  • @secfeed6987
    @secfeed69873 жыл бұрын

    Great video, very easy to use. Going to use it for asset management. Actually I could use this for stock market portfolio management also 👍

  • @nhexplorers
    @nhexplorers3 жыл бұрын

    Thanks for your great tutorials. REQUEST: Please do a tutorial on sharing one list to multiple SharePoint sites.

  • @adrianus13
    @adrianus133 жыл бұрын

    Hi Kevin, first, thanks for so many of your videos! Second, do you happen to know when or if we can use custom list templates (beyond using an existing list, I want the rows to already be there when I make a new list)? I have been able to find how to save my list as a template, but cannot figure out how to use my saved custom templates.

  • @opalayala6910
    @opalayala69103 жыл бұрын

    Couldn't do it without you Kevin!!!! Thanks Microsoft for Kevin Stratvert!! I am a Site Lead for Afterschool Program I keep looking for more tips from you to apply in the program?? Keep up the good work..

  • @SHANKSY1
    @SHANKSY13 жыл бұрын

    Can't wait for the full roll out and standalone apps. Have loads of projects waiting to be converted from Excel Tables into manageable list with documentation attachments / links and photos to manage project assets that can be shared.

  • @Rocky_Johnson
    @Rocky_Johnson3 жыл бұрын

    Hey Kevin, I've just tried Microsoft Lists with Microsoft Teams. It is quite fun at the beginning. I'm going to share with my buddy in office next Monday.

  • @kenhcuapikiu

    @kenhcuapikiu

    3 жыл бұрын

    Nice. let me try it also :)

  • @grampyrick4356

    @grampyrick4356

    3 жыл бұрын

    I see what you did there

  • @talishkavonzua
    @talishkavonzua3 жыл бұрын

    Great, like usual! I don't know why i don't see Lists on my E3 account, but i can use it on Teams, also i can use it on my personal account.

  • @jirinovotny9704
    @jirinovotny97043 жыл бұрын

    This looks pretty good. Thanks for giving us this tutorial. One question that crosses my mind is whether the list can be shared with someone outside of my organization. The Lists app might be useful for sharing an issue/punch list on a project with a customer we deliver to (not part of our organization). Thanks.

  • @elenapark6213
    @elenapark62133 жыл бұрын

    Thank you Kevin, I wish my professors were like you^^

  • @sharifskijr.1257
    @sharifskijr.12572 ай бұрын

    Much appreicated Kev!

  • @rajeshpg99
    @rajeshpg992 жыл бұрын

    Hi Kevin, Most of your videos are very useful and resourceful. Thank you for creating such helpful and informative contents.

  • @edcoffeebean
    @edcoffeebean3 жыл бұрын

    Kevin, you always have great content, many thanks. Is there a way of using lookup columns in Lists? For example, if there's a parent/child relationship between two lists (or more), is it possible to model this relationship?

  • @rwswe_uif8077
    @rwswe_uif80773 жыл бұрын

    Hi Kevin thanks for the comprehensive videos! How can I scheduled due dates from a list to my students calendar?

  • @jayounglocher-woo4325
    @jayounglocher-woo43253 жыл бұрын

    Hi, Kevin, I'm watching a lot of videos from you, thank you so much for all your insightful demonstrations - they are really helpful in doing my job. May I request something? I've checked on Microsoft Project, and it would be great if you could make a video on Microsoft and also compare with Lists;) Thank you - Merry Christmas and happy new year ;)

  • @niladrisadhukhan
    @niladrisadhukhan3 жыл бұрын

    Thanks for the nice video! On a different context, Is there a way to set default values in MS Forms fields?

  • @sabineboonen64
    @sabineboonen643 жыл бұрын

    This is really great, thanks. I am looking how to create subgroups in lists. Example would be a FAQ list where you would group questions of a same topic under the same heading. When you click on the heading, all your questions related to that particular topic would open.

  • @michaelmosley3979
    @michaelmosley3979 Жыл бұрын

    Awesome explanation! Really like your videos! Simple question on the assets management. How do create a simple check in and check out inventory scheme? After I add a list with equipment, how do other employees see list and check out equipment themselves? Thanks!

  • @JeanChen5942238
    @JeanChen59422383 жыл бұрын

    Thank you for the video!

  • @submeg5183
    @submeg51833 жыл бұрын

    Hi Kevin, great intro video. I'd like to know more about the tracking capabilities of lists and if they are similar or different to planner and sharepoint. Thanks.

  • @juanbethencourt7210
    @juanbethencourt72102 жыл бұрын

    Thanks for the tutorial, very useful as always. When will we be able to migrate a list from one sharepoint to a new sharepoint maintaining the metadata and configurations?

  • @AbizerPardawala
    @AbizerPardawala3 жыл бұрын

    Dear kevin Everytime I open my youtube, your videos are either first or second on list and Everytime I get to know that Microsoft has launched a new app. Thanks for the updates

  • @obiedalba3030
    @obiedalba30303 жыл бұрын

    Thanks Kev. I've learned something new today ☺

  • @TotallyZen
    @TotallyZen3 жыл бұрын

    Thanks Kevin, another useful video! QQ: Can you create lists within lists?

  • @mypetsafterlifetransitionw8315
    @mypetsafterlifetransitionw83153 жыл бұрын

    Hey Kevin, can you do a tutorial about exporting from Microsoft List? Specifically, exactly what data will get exported vs what doesn't. For example, do comments left in a list get exported or when there have been changes or revisions made within a list?

  • @gracemark5995
    @gracemark59953 жыл бұрын

    hi kevin i'm mark i wanted to say you that your explaination is incredible that makes me feel very interesting amazing keep on doing more videos thank you so much

  • @guyinazo
    @guyinazo3 жыл бұрын

    Thanks for posting this. I definitely am going to share out this video with my management team so they know this exists. Except, I do not see Lists yet in our tenant

  • @zbrand450

    @zbrand450

    3 жыл бұрын

    Same 🥺

  • @ericahugo7643
    @ericahugo76433 жыл бұрын

    Your videos are awesome. Thank you for taking the time to make these videos

  • @georgendang3833
    @georgendang38336 ай бұрын

    Thanks very much sir You are such a great 👍 teacher

  • @ArchanaGargyaAnArtist
    @ArchanaGargyaAnArtist2 жыл бұрын

    Hi everyone, Kevin here, today I wanna show you.... ....... love this line and your way to say💓

  • @KimHongTan
    @KimHongTan3 жыл бұрын

    Thanks Kevin for putting this video together 😊 May I know if MS List only limited to Office Insiders? I can’t seem to find it in my Office 365.

  • @Abu-jawad70
    @Abu-jawad703 жыл бұрын

    Thank you for that, i wanna ask you, is there any easy way to save the important links that i need, and use them whenever i want.

  • @ScottMoran001
    @ScottMoran0013 жыл бұрын

    Great video, thank you!

  • @lucamangione5136
    @lucamangione51363 жыл бұрын

    Hallo Matt - thanks for sharing this quick tutorial - I am currently using airtable but would love to implement Microsoft lists. Do you know if it is possible to create a layout of the records in a list in an a4 format for printing ? Kind of like a gallery but with a record for each page so I can print out a booklet with a detailed sheet page for each record . Hope it makes sense . Thanks !

  • @grampyrick4356
    @grampyrick43563 жыл бұрын

    Excellent overview Kevin. I need to find out if there is a way to set the values that are available for a column, conditioned on the values for an adjacent column (if that makes any sense). For example, if column A is set to "Optional (Y/N) = N", the Implementation Date in the next column should default to "NOW".

  • @randocuz5933
    @randocuz5933 Жыл бұрын

    GREAT tutorial, gonna give a killer demo to my team tomorrow. thx

  • @gilblamp
    @gilblamp3 жыл бұрын

    Hello Kevin, big thumb up for all the (always) useful information ! Thanks to you, I started to use it. The ideal product to follow our projects ! Any idea when MS Lists will be available for Android ?

  • @lonniehardy3985
    @lonniehardy39855 күн бұрын

    Great presentation 🎉

  • @atulverma8823
    @atulverma88232 жыл бұрын

    Hi Kevin, these all videos are really helpful, keep up the good work 👍👍

  • @zaheerullah2933
    @zaheerullah29337 күн бұрын

    Excellent content and very usful

  • @GPMG25
    @GPMG253 жыл бұрын

    Thank you Kevin, can you tell me, can an item in a list automatically move to another list using Power Automate?

  • @davelittle2741
    @davelittle27413 жыл бұрын

    Hi Kevin. Great videos. Can I ask whether you can move Lists between Channels in Teams. If so, how?

  • @MJK0627
    @MJK06273 жыл бұрын

    Hi Kevin, is there a way to share content on dual monitors in Microsoft Teams?

  • @anill1448
    @anill14483 жыл бұрын

    Excellent tutorial. Thanks. Subscribed

  • @sucmitra
    @sucmitra10 ай бұрын

    Awesome, So nicely taught, thanks Kevin!

  • @Democratiser
    @Democratiser3 жыл бұрын

    Well done Kevin, once again a great video. The Lists app doesn’t seem to be available yet through Office 365 for Business in Australia. I’d welcome your views on whether Lists could be used as a CRM tool for businesses that don’t have MS Dynamics?

  • @amritraj5395
    @amritraj5395 Жыл бұрын

    Very helpful, great and full of knowledge. It's totally worth it.

  • @brianbaheramouzegarletsbui6533
    @brianbaheramouzegarletsbui6533 Жыл бұрын

    Thanks, Kevin. This was another great production of yours. Keep it up!

  • @carrievalenta803
    @carrievalenta8033 жыл бұрын

    How to use flows would be great!

  • @werisetogether24
    @werisetogether243 жыл бұрын

    bro you are a geek!!! weldone for this tutorials of urs..

  • @bobbirowlett6728
    @bobbirowlett6728 Жыл бұрын

    Very helpful. Thank you!

  • @lenam068
    @lenam0682 жыл бұрын

    Thank you very much Kevin !

  • @sheribarrera9091
    @sheribarrera90913 жыл бұрын

    This sounds great! Are you able to limit users to only view and edit records created by them?

  • @andeessential2939
    @andeessential29399 ай бұрын

    So helpful, thank you!

  • @rigosantillano9018
    @rigosantillano90183 жыл бұрын

    Great channel and thank you for great summary of MS LISTS. QQ, Is it possible to have list create a TASK in MS Planner?

  • @steve_bailey
    @steve_bailey3 жыл бұрын

    Nice video Kevin! I run engineering for this stuff.

  • @robbe4711
    @robbe47113 жыл бұрын

    The more interesting question is: how can you explain the difference between Excel und Lists to end users? Despite the fact that you can use workflows there is a problem in explaining why lists are better in some cases.

  • @NeethiKumar-ix3fk
    @NeethiKumar-ix3fk Жыл бұрын

    Hi Kevin, your videos are great! Can I create a list and assign tasks to a group of people, allowing each person to interact with their respective task independently, without it being visible to others? It would be great if you could let me know. Thanks!

  • @quraninformer9781
    @quraninformer97813 жыл бұрын

    Hi, thank you for your explanation but my office has only to do list. I don't see list

  • @philjames1019
    @philjames10193 жыл бұрын

    Thanks!!

  • @squareggs
    @squareggs3 жыл бұрын

    Thank you, helps a lot. A video on Power Automate would be fab if you get time 😊

  • @KevinStratvert

    @KevinStratvert

    3 жыл бұрын

    Here you go: kzread.info/dash/bejne/lniDlrttkae_iNo.html

  • @driesvdc2
    @driesvdc23 жыл бұрын

    Awesome video, thanks Kevin

  • @mohanlpuri1
    @mohanlpuri111 ай бұрын

    Excellent video.

  • @yuliyacher67
    @yuliyacher673 жыл бұрын

    Thank you!

  • @ddp2049
    @ddp2049 Жыл бұрын

    As well is list good for personal use like clean track of bills , chores, and general things to do in a personal life. I like the video

  • @jeryckma
    @jeryckma2 жыл бұрын

    Thank you for this! How do I create a time column?

  • @poojaachauhan371
    @poojaachauhan3712 жыл бұрын

    Hi Kevin...this video is really helpful. Can we create a dependent drop-down list? If yes how can we do that

  • @carlosfarace6889
    @carlosfarace68893 жыл бұрын

    Great video, thanks for posting. Is it possible to mail merge in list?

  • @brisklearningsolutions450
    @brisklearningsolutions4502 жыл бұрын

    Superb Kevin, really liked all your videos This helped us a lot to improve and implement new tech in our organization

  • @tridibbiswas3361
    @tridibbiswas33613 жыл бұрын

    Hi Kevin, thank you for the video. Could you a more detailed one. Like explaing the different fomratting options : like the country option, when I select, I cannot find how use it next or when I was trying to make my first list I realised that the 1st default cannot be deleted nor the formatting for the same can be changed. Your inputs on these matter would be great help for people like to use Lists. I have learnt so much from your videos

  • @heatherfeather2621
    @heatherfeather26213 жыл бұрын

    Can you talk about managed metadata in modern SPO and folksonomy implementation in particular? I'd love to see how folksonomies might improve searching in their new world of less hierarchy. I want to put power back into users control as much as possible.

  • @davidmelgar1935
    @davidmelgar19353 жыл бұрын

    Awesome feature! I hope the android app improves soon!

  • @MehdiRazaToronto
    @MehdiRazaTorontoАй бұрын

    Great video with very practical approach.

Келесі