title
How to use Microsoft Lists

description
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: https://youtu.be/dDO4Y4aDYXw

detail
{'title': 'How to use Microsoft Lists', 'heatmap': [{'end': 455.401, 'start': 433.904, 'weight': 1}], 'summary': 'Learn how to use microsoft lists through an introduction to its features, control and customization options, functionality, creation and customization process, and advanced features including data visualization, conditional formatting, and integration with power automate for enhanced efficiency and collaboration.', 'chapters': [{'end': 68.445, 'segs': [{'end': 68.445, 'src': 'embed', 'start': 0.049, 'weight': 0, 'content': [{'end': 1.791, 'text': 'Hi everyone, Kevin here.', 'start': 0.049, 'duration': 1.742}, {'end': 9.097, 'text': 'Today I want to show you how you can both get and use the brand new Microsoft Lists.', 'start': 1.931, 'duration': 7.166}, {'end': 13.181, 'text': "It's now generally available and you can start taking advantage of it.", 'start': 9.277, 'duration': 3.904}, {'end': 17.645, 'text': "And although it's generally available, there's still many features rolling out.", 'start': 13.581, 'duration': 4.064}, {'end': 22.57, 'text': "but that's a typical web product where, over time, more and more value will be landing.", 'start': 17.645, 'duration': 4.925}, {'end': 27.476, 'text': 'First off, what is Microsoft Lists and what makes it unique?', 'start': 23.19, 'duration': 4.286}, {'end': 34.224, 'text': 'Well, just like the name implies, Microsoft Lists allows you to create lists, to organize information.', 'start': 27.896, 'duration': 6.328}, {'end': 40.072, 'text': 'With those lists, you can share it with others and you can collaborate with others on those lists.', 'start': 34.785, 'duration': 5.287}, {'end': 44.814, 'text': 'Now, so far that sounds like everything that you could do in a spreadsheet with a list.', 'start': 40.572, 'duration': 4.242}, {'end': 48.776, 'text': "What's unique about Microsoft Lists? Well, a few things.", 'start': 45.034, 'duration': 3.742}, {'end': 52.538, 'text': 'First off, you can visualize your data in many different ways.', 'start': 49.216, 'duration': 3.322}, {'end': 59.361, 'text': 'Once you get your data into a list, you could view it in a standard grid format just like in Microsoft Excel.', 'start': 53.058, 'duration': 6.303}, {'end': 63.403, 'text': 'You could also view it in a card format and a calendar format.', 'start': 59.821, 'duration': 3.582}, {'end': 68.445, 'text': 'You could define what data is visible in a card or what data is not visible in the card,', 'start': 63.763, 'duration': 4.682}], 'summary': 'Microsoft lists allows creating, sharing, and visualizing data in multiple formats, now generally available.', 'duration': 68.396, 'max_score': 0.049, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko49.jpg'}], 'start': 0.049, 'title': 'Introducing microsoft lists', 'summary': 'Introduces brand new microsoft lists, highlighting features like list creation, collaboration, data visualization, and data visibility.', 'chapters': [{'end': 68.445, 'start': 0.049, 'title': 'Introducing microsoft lists: features and benefits', 'summary': 'Introduces the brand new microsoft lists, its features, and benefits, highlighting its ability to create and share lists, collaborate with others, visualize data in various formats, and define data visibility.', 'duration': 68.396, 'highlights': ['Microsoft Lists allows you to create lists to organize information, share them with others, and collaborate on them.', 'You can visualize your data in different ways such as grid, card, and calendar formats, and define the visibility of data in the card format.', 'The brand new Microsoft Lists is now generally available, with many features still rolling out over time.']}], 'duration': 68.396, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko49.jpg', 'highlights': ['Microsoft Lists allows list creation, information organization, and collaboration.', 'Data can be visualized in grid, card, and calendar formats with defined visibility.', 'Brand new Microsoft Lists is now generally available with ongoing feature rollouts.']}, {'end': 316.485, 'segs': [{'end': 154.986, 'src': 'embed', 'start': 68.445, 'weight': 0, 'content': [{'end': 73.389, 'text': 'so you have a lot of control over how you present your information.', 'start': 68.445, 'duration': 4.944}, {'end': 79.193, 'text': 'along with that, you can also apply lots of different smarts to your microsoft list.', 'start': 73.389, 'duration': 5.804}, {'end': 87.159, 'text': "let's say, for instance, that i have a list issue tracker and maybe one of my items goes from on track to delayed.", 'start': 79.193, 'duration': 7.966}, {'end': 95.606, 'text': 'i can set up a rule so it sends me an email and maybe it sends the person who owns the issue an email letting them know about the status change.', 'start': 87.159, 'duration': 8.447}, {'end': 102.87, 'text': 'Lastly, you can also connect Microsoft lists to things like Power Automate and also Power Apps.', 'start': 96.386, 'duration': 6.484}, {'end': 105.472, 'text': 'With Power Automate, for instance.', 'start': 103.611, 'duration': 1.861}, {'end': 110.415, 'text': "let's say that we have a customer ticketing system and a customer comes in and submits a ticket.", 'start': 105.472, 'duration': 4.943}, {'end': 118.981, 'text': "we can have it automatically get added to our Microsoft list and then lists can post over in Teams and let our team know about the new issue that's come in.", 'start': 110.415, 'duration': 8.566}, {'end': 121.223, 'text': 'Try doing that in a spreadsheet.', 'start': 119.501, 'duration': 1.722}, {'end': 124.986, 'text': 'Now you might be wondering when would you use Microsoft Lists?', 'start': 121.903, 'duration': 3.083}, {'end': 127.969, 'text': "Well, let's say that you have an issue tracker.", 'start': 125.206, 'duration': 2.763}, {'end': 129.851, 'text': 'maybe you want to track inventory.', 'start': 127.969, 'duration': 1.882}, {'end': 131.212, 'text': 'maybe you want to track assets.', 'start': 129.851, 'duration': 1.361}, {'end': 133.955, 'text': 'maybe you work at a hospital and you want to use it to track patients.', 'start': 131.212, 'duration': 2.743}, {'end': 144.162, 'text': 'There are many different uses for Microsoft Lists and you might be thinking well, it kind of similar to what Microsoft Planner and Microsoft To Do do.', 'start': 134.416, 'duration': 9.746}, {'end': 146.883, 'text': 'They both track issues and teamwork.', 'start': 144.563, 'duration': 2.32}, {'end': 147.944, 'text': "doesn't lists do that?", 'start': 146.883, 'duration': 1.061}, {'end': 149.244, 'text': 'And it is true.', 'start': 148.024, 'duration': 1.22}, {'end': 154.986, 'text': 'you can use Microsoft Lists as a way to track individual tasks and also team tasks.', 'start': 149.244, 'duration': 5.742}], 'summary': 'Microsoft lists offers control, automation, and connectivity. it can be used for tracking issues, inventory, assets, and patients, with capabilities similar to microsoft planner and microsoft to do.', 'duration': 86.541, 'max_score': 68.445, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko68445.jpg'}, {'end': 203.46, 'src': 'embed', 'start': 177.299, 'weight': 7, 'content': [{'end': 185.686, 'text': 'this might all sound very similar to sharepoint lists, and microsoft lists is really an evolution of sharepoint lists.', 'start': 177.299, 'duration': 8.387}, {'end': 192.351, 'text': 'when you look at the competition, like monday.com, you have asana reich airtable.', 'start': 185.686, 'duration': 6.665}, {'end': 195.674, 'text': 'the list is at the core of those experiences.', 'start': 192.351, 'duration': 3.323}, {'end': 203.46, 'text': "for microsoft to stay competitive, they needed to invest heavily, and that's where you get the standalone microsoft lists app.", 'start': 195.674, 'duration': 7.786}], 'summary': 'Microsoft lists is an evolution of sharepoint lists, competing with monday.com, asana, and airtable, to stay competitive, microsoft invested in a standalone app.', 'duration': 26.161, 'max_score': 177.299, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko177299.jpg'}, {'end': 255.626, 'src': 'embed', 'start': 228.475, 'weight': 6, 'content': [{'end': 234.957, 'text': "Unfortunately, if you have a personal Microsoft 365 account, you won't be able to use Microsoft Lists.", 'start': 228.475, 'duration': 6.482}, {'end': 238.818, 'text': "Once you land on Office.com, let's click on Sign In.", 'start': 235.497, 'duration': 3.321}, {'end': 248.723, 'text': "Once you sign into office.com, you'll land on the office.com authenticated page to get to Microsoft lists up in the top left hand corner.", 'start': 239.458, 'duration': 9.265}, {'end': 255.626, 'text': "Let's click on the app launcher and you should see a new option now for Microsoft lists as part of the core apps.", 'start': 248.803, 'duration': 6.823}], 'summary': "Personal microsoft 365 account users can't access microsoft lists on office.com.", 'duration': 27.151, 'max_score': 228.475, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko228475.jpg'}, {'end': 325.07, 'src': 'embed', 'start': 294.449, 'weight': 5, 'content': [{'end': 295.23, 'text': 'here too,', 'start': 294.449, 'duration': 0.781}, {'end': 305.178, 'text': 'i can add a list directly through microsoft teams and i can access the same set of lists whether i go directly through office.com or whether i go through teams.', 'start': 295.23, 'duration': 9.948}, {'end': 308.921, 'text': "it's simply another way for me to access my microsoft list.", 'start': 305.178, 'duration': 3.743}, {'end': 316.485, 'text': "I'm back in my browser on the Microsoft Lists homepage and I want to briefly walk through some of the functionality here.", 'start': 309.261, 'duration': 7.224}, {'end': 321.968, 'text': "At the very top, and in a moment we're going to click on this, I have the ability to add a new list.", 'start': 316.945, 'duration': 5.023}, {'end': 325.07, 'text': 'Down below, I see all of my favorite lists.', 'start': 322.488, 'duration': 2.582}], 'summary': 'Microsoft teams allows accessing lists from office.com, providing another way to access microsoft lists.', 'duration': 30.621, 'max_score': 294.449, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko294449.jpg'}], 'start': 68.445, 'title': 'Microsoft lists: overview and control', 'summary': 'Covers control and customization options in microsoft lists, integration with power automate and power apps, usage scenarios like issue tracking and patient tracking, and access methods through office.com and microsoft teams, enhancing efficiency and collaboration.', 'chapters': [{'end': 110.415, 'start': 68.445, 'title': 'Microsoft lists: control, automation, and connectivity', 'summary': 'Explores the control and customization options for presenting information in microsoft lists, including the ability to apply rules for notifications and the integration with power automate and power apps, enhancing efficiency and collaboration.', 'duration': 41.97, 'highlights': ['You can apply rules in Microsoft Lists to trigger email notifications for status changes, enhancing communication and accountability.', 'Microsoft Lists can be connected to Power Automate and Power Apps, streamlining processes such as customer ticketing systems and automating workflows.', 'Users have a high level of control over the presentation of information in Microsoft Lists, contributing to enhanced customization and usability.']}, {'end': 316.485, 'start': 110.415, 'title': 'Microsoft lists: overview and usage', 'summary': 'Discusses the functionality and usage of microsoft lists, including its integration with microsoft teams, its different use cases such as issue tracking, inventory tracking, and patient tracking, and the different ways to access microsoft lists through office.com and microsoft teams.', 'duration': 206.07, 'highlights': ['Microsoft Lists can be used for various purposes such as issue tracking, inventory tracking, and patient tracking, serving as a broad-use tool. Microsoft Lists can be used for issue tracking, inventory tracking, and patient tracking, offering a broad-use tool for different purposes.', 'Integration with Microsoft Teams allows for seamless communication and notification within the team regarding new issues. Microsoft Lists integrate with Microsoft Teams, enabling seamless communication and notification within the team regarding new issues.', 'Access to Microsoft Lists can be attained through Office.com and Microsoft Teams, providing flexibility in usage. Microsoft Lists can be accessed through Office.com and Microsoft Teams, offering flexibility in usage for users.', 'Microsoft Lists require a work or school Microsoft 365 account for usage, not compatible with personal Microsoft 365 accounts. To use Microsoft Lists, a work or school Microsoft 365 account is required, as it is not compatible with personal Microsoft 365 accounts.', 'Microsoft Lists is an evolution of SharePoint lists and aims to stay competitive with other platforms such as monday.com, asana, and airtable. Microsoft Lists is an evolution of SharePoint lists and aims to stay competitive with platforms like monday.com, asana, and airtable.']}], 'duration': 248.04, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko68445.jpg', 'highlights': ['Rules in Microsoft Lists trigger email notifications for status changes, enhancing communication and accountability.', 'Microsoft Lists can be connected to Power Automate and Power Apps, streamlining processes such as customer ticketing systems and automating workflows.', 'Users have a high level of control over the presentation of information in Microsoft Lists, contributing to enhanced customization and usability.', 'Microsoft Lists can be used for various purposes such as issue tracking, inventory tracking, and patient tracking, serving as a broad-use tool.', 'Integration with Microsoft Teams allows for seamless communication and notification within the team regarding new issues.', 'Access to Microsoft Lists can be attained through Office.com and Microsoft Teams, providing flexibility in usage.', 'Microsoft Lists require a work or school Microsoft 365 account for usage, not compatible with personal Microsoft 365 accounts.', 'Microsoft Lists is an evolution of SharePoint lists and aims to stay competitive with other platforms such as monday.com, asana, and airtable.']}, {'end': 492.774, 'segs': [{'end': 388.573, 'src': 'embed', 'start': 358.905, 'weight': 2, 'content': [{'end': 362.409, 'text': 'or I can limit it to recent lists that I created.', 'start': 358.905, 'duration': 3.504}, {'end': 368.938, 'text': 'If I hover over an individual list object, I see an ellipses down at the bottom and I could customize it.', 'start': 362.91, 'duration': 6.028}, {'end': 372.501, 'text': 'For instance, I could change the color, the name, or the icon.', 'start': 369.338, 'duration': 3.163}, {'end': 375.183, 'text': 'I could click on it again and I could share it with others.', 'start': 372.841, 'duration': 2.342}, {'end': 379.546, 'text': "That's one of the powers of Microsoft Lists, working together with others on a list.", 'start': 375.223, 'duration': 4.323}, {'end': 382.028, 'text': 'And I also have the option to remove it.', 'start': 380.006, 'duration': 2.022}, {'end': 385.01, 'text': "And if I'm in the My Lists view, I can delete a list.", 'start': 382.168, 'duration': 2.842}, {'end': 388.573, 'text': 'So lots of different controls and functionality here on the homepage.', 'start': 385.371, 'duration': 3.202}], 'summary': 'Microsoft lists allow customization of lists, including color, name, icon, and sharing with others. users can also delete lists from the my lists view.', 'duration': 29.668, 'max_score': 358.905, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko358905.jpg'}, {'end': 426.457, 'src': 'embed', 'start': 400.68, 'weight': 1, 'content': [{'end': 409.124, 'text': 'First off, I can create a new blank list and this is a blank canvas and I could design what the list looks like and I get to define the structure.', 'start': 400.68, 'duration': 8.444}, {'end': 415.989, 'text': 'I can also start from an Excel spreadsheet and when I bring the data in, I could define what the data schema is.', 'start': 409.784, 'duration': 6.205}, {'end': 421.773, 'text': "And lastly, let's say that maybe I had an existing list and I'd like to use that as my baseline.", 'start': 416.489, 'duration': 5.284}, {'end': 426.457, 'text': 'I could reuse all of the structure and I could also bring over all of the business rules.', 'start': 421.773, 'duration': 4.684}], 'summary': 'Ability to create new list, define schema, and reuse existing structure and business rules.', 'duration': 25.777, 'max_score': 400.68, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko400680.jpg'}, {'end': 463.883, 'src': 'heatmap', 'start': 433.904, 'weight': 1, 'content': [{'end': 441.05, 'text': 'And Microsoft lists set this up in a way where some of the most popular things you might use Microsoft lists for appear here.', 'start': 433.904, 'duration': 7.146}, {'end': 447.576, 'text': 'For instance, you could set up an issue tracker, employee onboarding, and it goes on and on in terms of what type of lists you could create.', 'start': 441.13, 'duration': 6.446}, {'end': 450.599, 'text': "Let's click into one of them to see what this looks like.", 'start': 447.956, 'duration': 2.643}, {'end': 455.401, 'text': 'When I click into one of these templates, it gives me an example of what this template looks like.', 'start': 450.859, 'duration': 4.542}, {'end': 463.883, 'text': "So here I could see what the data structure looks like, and I could use this as an example, especially if I want to create, let's say, a blank list.", 'start': 455.521, 'duration': 8.362}], 'summary': 'Microsoft lists offers templates for various purposes, such as issue tracking and employee onboarding, providing example data structures for easy customization.', 'duration': 29.979, 'max_score': 433.904, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko433904.jpg'}, {'end': 469.325, 'src': 'embed', 'start': 441.13, 'weight': 0, 'content': [{'end': 447.576, 'text': 'For instance, you could set up an issue tracker, employee onboarding, and it goes on and on in terms of what type of lists you could create.', 'start': 441.13, 'duration': 6.446}, {'end': 450.599, 'text': "Let's click into one of them to see what this looks like.", 'start': 447.956, 'duration': 2.643}, {'end': 455.401, 'text': 'When I click into one of these templates, it gives me an example of what this template looks like.', 'start': 450.859, 'duration': 4.542}, {'end': 463.883, 'text': "So here I could see what the data structure looks like, and I could use this as an example, especially if I want to create, let's say, a blank list.", 'start': 455.521, 'duration': 8.362}, {'end': 469.325, 'text': 'I could use this to help inspire me in terms of what types of fields I can include in my list.', 'start': 464.043, 'duration': 5.282}], 'summary': 'Easily set up various templates for issue tracking, onboarding, and more, with examples for data structure and field inspiration.', 'duration': 28.195, 'max_score': 441.13, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko441130.jpg'}], 'start': 316.945, 'title': 'Microsoft lists overview', 'summary': 'Explains the functionality of microsoft lists, including the ability to add, customize, and share lists, create new lists from various options, and utilize templates for different list types, offering a broad use case beyond planner or to do.', 'chapters': [{'end': 492.774, 'start': 316.945, 'title': 'Microsoft lists overview', 'summary': 'Explains the functionality of microsoft lists, including the ability to add, customize, and share lists, create new lists from various options, and utilize templates for different list types, offering a broad use case beyond planner or to do.', 'duration': 175.829, 'highlights': ['Microsoft Lists provides the ability to add a new list, favorite lists, and filter recent lists, with the option to customize and share individual lists. The functionality includes adding new lists, favoriting lists, and filtering recent lists, providing customization and sharing options.', 'Options for creating a new list include starting from a blank canvas, importing from an Excel spreadsheet, or reusing an existing list with its structure and business rules. Users can create new lists from a blank canvas, import from Excel, or reuse existing lists with structure and business rules.', 'Microsoft Lists offers various templates for common list types such as issue tracker and employee onboarding, providing examples and inspiration for list creation. The availability of templates for common list types like issue tracker and employee onboarding offers examples and inspiration for list creation.']}], 'duration': 175.829, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko316945.jpg', 'highlights': ['Microsoft Lists offers various templates for common list types such as issue tracker and employee onboarding, providing examples and inspiration for list creation.', 'Options for creating a new list include starting from a blank canvas, importing from an Excel spreadsheet, or reusing an existing list with its structure and business rules.', 'Microsoft Lists provides the ability to add a new list, favorite lists, and filter recent lists, with the option to customize and share individual lists.']}, {'end': 863.441, 'segs': [{'end': 537.312, 'src': 'embed', 'start': 493.254, 'weight': 0, 'content': [{'end': 499.336, 'text': "Next, I'm going to click on back and I want to simply start from a blank list to show what that experience looks like.", 'start': 493.254, 'duration': 6.082}, {'end': 504.999, 'text': 'Once I click on new blank, I can define the name and the description of my new list.', 'start': 499.776, 'duration': 5.223}, {'end': 512.464, 'text': "Now with the Kevin Cookie Company, we're aggressively opening new locations and I sure could use a Microsoft list to track everything.", 'start': 505.379, 'duration': 7.085}, {'end': 515.866, 'text': "For the name, I'm going to type in new location tracker.", 'start': 512.984, 'duration': 2.882}, {'end': 517.186, 'text': 'For the description.', 'start': 516.186, 'duration': 1}, {'end': 520.628, 'text': 'I want to give a little bit more information about what this list is,', 'start': 517.186, 'duration': 3.442}, {'end': 525.309, 'text': "so I'm going to add a very descriptive description saying track new location openings.", 'start': 520.628, 'duration': 4.681}, {'end': 532.631, 'text': "Now I could choose a color and I've always heard that red is a power color so we're going to go with red for the color of this list.", 'start': 525.749, 'duration': 6.882}, {'end': 535.431, 'text': 'I can choose an icon and new locations.', 'start': 533.051, 'duration': 2.38}, {'end': 537.312, 'text': 'I guess a cube is kind of like a building.', 'start': 535.431, 'duration': 1.881}], 'summary': "Creating a new list for tracking new location openings at kevin cookie company using microsoft list, with the name 'new location tracker' and the color red.", 'duration': 44.058, 'max_score': 493.254, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko493254.jpg'}, {'end': 738.856, 'src': 'embed', 'start': 712.919, 'weight': 3, 'content': [{'end': 720.703, 'text': 'I can simply drag and drop items and columns where I want them, so I have a lot of flexibility in terms of how my list looks.', 'start': 712.919, 'duration': 7.784}, {'end': 727.627, 'text': "Now that I've added all of my different column headers to Microsoft Lists, I want to start adding some data in here,", 'start': 721.124, 'duration': 6.503}, {'end': 731.85, 'text': "because we have a lot of locations we're adding, so I need to start populating this.", 'start': 727.627, 'duration': 4.223}, {'end': 734.993, 'text': 'There are two different ways to start adding data.', 'start': 732.35, 'duration': 2.643}, {'end': 738.856, 'text': 'Up here I could click on new or I could edit in grid view.', 'start': 735.473, 'duration': 3.383}], 'summary': 'Flexibility to arrange items, adding data to microsoft lists for multiple locations.', 'duration': 25.937, 'max_score': 712.919, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko712919.jpg'}, {'end': 787.971, 'src': 'embed', 'start': 759.374, 'weight': 4, 'content': [{'end': 762.637, 'text': 'The nice thing here is this connects to Azure Active Directory.', 'start': 759.374, 'duration': 3.263}, {'end': 768.001, 'text': 'And here I could look through the directory and I see that Adele is one of my franchisees.', 'start': 763.017, 'duration': 4.984}, {'end': 770.543, 'text': "So I'm going to select Adele on here.", 'start': 768.321, 'duration': 2.222}, {'end': 777.786, 'text': "I've gone through now and I filled out all of the data within this form and now I'm going to click on save.", 'start': 771.363, 'duration': 6.423}, {'end': 780.708, 'text': 'This now adds the first item to my form.', 'start': 778.187, 'duration': 2.521}, {'end': 786.051, 'text': "Next, I want to click on edit in grid view and I'll add one more store location via the grid.", 'start': 780.908, 'duration': 5.143}, {'end': 787.971, 'text': 'This opens up the grid view.', 'start': 786.411, 'duration': 1.56}], 'summary': 'Uses azure active directory to manage franchisee data and adds store locations via grid view.', 'duration': 28.597, 'max_score': 759.374, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko759374.jpg'}, {'end': 853.875, 'src': 'embed', 'start': 821.544, 'weight': 5, 'content': [{'end': 825.826, 'text': "One of the nice things about Microsoft lists is I don't have to work in isolation.", 'start': 821.544, 'duration': 4.282}, {'end': 829.488, 'text': 'Up here on the top bar, I can share this with other people.', 'start': 826.046, 'duration': 3.442}, {'end': 830.809, 'text': 'Let me click on this.', 'start': 829.868, 'duration': 0.941}, {'end': 836.491, 'text': 'This opens up the share control and I can now type in a name of a person I want to share with.', 'start': 831.209, 'duration': 5.282}, {'end': 839.251, 'text': "I'm going to share this with Kat Larson.", 'start': 836.871, 'duration': 2.38}, {'end': 841.032, 'text': "I've selected Kat Larson.", 'start': 839.571, 'duration': 1.461}, {'end': 845.393, 'text': "I could add other people if I want, but for now Kat's enough to add.", 'start': 841.112, 'duration': 4.281}, {'end': 853.875, 'text': "Down below, I can also set what type of permission she'll have, whether I want to give her full control, just edit permissions or view permissions.", 'start': 845.793, 'duration': 8.082}], 'summary': 'Microsoft lists allows easy sharing with others, such as kat larson, and setting specific permissions.', 'duration': 32.331, 'max_score': 821.544, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko821544.jpg'}], 'start': 493.254, 'title': 'Creating and customizing microsoft lists', 'summary': 'Demonstrates the process of creating and customizing a new list in microsoft lists, configuring columns, populating data, and sharing the list with collaborators, showcasing the functionalities with examples of list setup for kevin cookie company.', 'chapters': [{'end': 537.312, 'start': 493.254, 'title': 'Creating new list in microsoft lists', 'summary': 'Demonstrates the process of creating a new list in microsoft lists by defining the name, description, color, and icon, showcasing the example of setting up a list for tracking new location openings for kevin cookie company.', 'duration': 44.058, 'highlights': ['The Kevin Cookie Company is aggressively opening new locations and could use a Microsoft list to track everything.', 'The process involves defining the name and description of the new list, choosing a color (red is suggested as a power color), and selecting an appropriate icon.', "A descriptive description 'track new location openings' is added to the list to provide more information about its purpose."]}, {'end': 863.441, 'start': 537.312, 'title': 'Creating and customizing microsoft lists', 'summary': 'Demonstrates how to create and customize a new microsoft list, adding and configuring columns, populating data, and sharing the list with collaborators, showcasing the flexibility and functionalities of microsoft lists.', 'duration': 326.129, 'highlights': ['The chapter demonstrates how to add and configure columns in a new Microsoft list, showcasing the flexibility and functionalities of Microsoft Lists. The process of adding and configuring columns in a new Microsoft list is explained, highlighting the flexibility and functionalities of Microsoft Lists.', 'The chapter shows how to populate data in the Microsoft list, highlighting the process of adding new items and entering information, including the integration with Azure Active Directory for franchisee names. The process of populating data in the Microsoft list is demonstrated, showcasing the integration with Azure Active Directory for franchisee names and the process of adding new items and entering information.', 'The chapter illustrates the feature of sharing the list with collaborators, demonstrating the options to grant permissions and work together on the list. The feature of sharing the list with collaborators is illustrated, showcasing the options to grant permissions and work together on the list.']}], 'duration': 370.187, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko493254.jpg', 'highlights': ['The Kevin Cookie Company is aggressively opening new locations and could use a Microsoft list to track everything.', 'The process involves defining the name and description of the new list, choosing a color (red is suggested as a power color), and selecting an appropriate icon.', "A descriptive description 'track new location openings' is added to the list to provide more information about its purpose.", 'The chapter demonstrates how to add and configure columns in a new Microsoft list, showcasing the flexibility and functionalities of Microsoft Lists.', 'The chapter shows how to populate data in the Microsoft list, highlighting the process of adding new items and entering information, including the integration with Azure Active Directory for franchisee names.', 'The chapter illustrates the feature of sharing the list with collaborators, demonstrating the options to grant permissions and work together on the list.']}, {'end': 1245.238, 'segs': [{'end': 924.663, 'src': 'embed', 'start': 888.078, 'weight': 4, 'content': [{'end': 896.247, 'text': 'this opens up a pane on the right hand side and I can use data bars to help very quickly visualize how big or small location is.', 'start': 888.078, 'duration': 8.169}, {'end': 897.448, 'text': 'That looks great.', 'start': 896.667, 'duration': 0.781}, {'end': 898.689, 'text': "I'm going to click on save.", 'start': 897.548, 'duration': 1.141}, {'end': 904.055, 'text': 'Not only can I format the capacity column, I can also apply conditional formatting.', 'start': 899.11, 'duration': 4.945}, {'end': 906.516, 'text': 'For instance, whenever I work with Adele.', 'start': 904.395, 'duration': 2.121}, {'end': 913.558, 'text': 'she wants me to be super responsive, so I want to make sure I see all locations in this list where Adele is involved.', 'start': 906.516, 'duration': 7.042}, {'end': 916.4, 'text': 'Luckily, conditional formatting will help me with this.', 'start': 913.939, 'duration': 2.461}, {'end': 924.663, 'text': 'Just like we did with capacity, I could click on the franchisee name column, go down to column settings and here I could click on format this column.', 'start': 916.88, 'duration': 7.783}], 'summary': 'Using data bars and conditional formatting to visualize and analyze data for better responsiveness and visualization.', 'duration': 36.585, 'max_score': 888.078, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko888078.jpg'}, {'end': 1008.291, 'src': 'embed', 'start': 964.495, 'weight': 0, 'content': [{'end': 969.619, 'text': "Under location number, I could click on this dropdown and there's an option called totals.", 'start': 964.495, 'duration': 5.124}, {'end': 971.68, 'text': 'I could add the count of items.', 'start': 970.099, 'duration': 1.581}, {'end': 975.763, 'text': 'I could pull together the average, the max, the min, and a number of other things.', 'start': 971.96, 'duration': 3.803}, {'end': 979.366, 'text': "I just want to see a count of locations, so I'm going to click on count.", 'start': 976.163, 'duration': 3.203}, {'end': 983.707, 'text': "You now see that it's added account to the bottom of my list.", 'start': 980.126, 'duration': 3.581}, {'end': 988.087, 'text': "So far, much of the functionality that I've shown is fairly standard.", 'start': 984.147, 'duration': 3.94}, {'end': 992.568, 'text': 'I now want to show some of the more advanced and unique functionality.', 'start': 988.207, 'duration': 4.361}, {'end': 998.869, 'text': "Now that I've entered all of my data into Microsoft Lists, I can visualize it in different ways.", 'start': 993.348, 'duration': 5.521}, {'end': 1003.03, 'text': 'If I go up here to the top right-hand corner, I can switch the view.', 'start': 999.329, 'duration': 3.701}, {'end': 1008.291, 'text': "Here, right now, it's in a list format, but I could also switch it to compact list.", 'start': 1003.63, 'duration': 4.661}], 'summary': 'Microsoft lists allows data visualization and provides standard and advanced functionality for analysis.', 'duration': 43.796, 'max_score': 964.495, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko964495.jpg'}, {'end': 1041.674, 'src': 'embed', 'start': 1021.14, 'weight': 7, 'content': [{'end': 1031.887, 'text': "I'm also going to have a gallery view and a gallery view will visualize my data in cards and I could define what data is part of those cards and what data is not part of those cards.", 'start': 1021.14, 'duration': 10.747}, {'end': 1036.652, 'text': "So this way it'll make it easier for others to view the data that's within this list.", 'start': 1032.249, 'duration': 4.403}, {'end': 1041.674, 'text': 'Now back to some of the more standard functionality up here in the top right-hand corner.', 'start': 1036.972, 'duration': 4.702}], 'summary': 'Gallery view will visualize data in cards, making it easier for others to view the data within the list.', 'duration': 20.534, 'max_score': 1021.14, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko1021140.jpg'}, {'end': 1114.589, 'src': 'embed', 'start': 1083.419, 'weight': 1, 'content': [{'end': 1087.222, 'text': 'With alerts, Microsoft lists is improving that experience.', 'start': 1083.419, 'duration': 3.803}, {'end': 1092.006, 'text': "For instance, here within my list, let's say that a column value changes.", 'start': 1087.422, 'duration': 4.584}, {'end': 1098.952, 'text': "So let's say for instance, this London location, maybe previously the status was on track and it recently changed to issues.", 'start': 1092.066, 'duration': 6.886}, {'end': 1100.033, 'text': 'I can set it up.', 'start': 1099.352, 'duration': 0.681}, {'end': 1108.142, 'text': "I get an email about that and I could also set it up so Kat would get an email about it, it's going to be fairly easy to set up these types of rules.", 'start': 1100.473, 'duration': 7.669}, {'end': 1114.589, 'text': 'Along with that, I can get an alert if a new item is created or if one of these existing items is deleted.', 'start': 1108.582, 'duration': 6.007}], 'summary': 'Microsoft lists is improving user experience with alerts for column value changes and item creation/deletion.', 'duration': 31.17, 'max_score': 1083.419, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko1083419.jpg'}, {'end': 1173.042, 'src': 'embed', 'start': 1145.269, 'weight': 2, 'content': [{'end': 1149.691, 'text': 'For instance, I can send a customized email when a new list item is added.', 'start': 1145.269, 'duration': 4.422}, {'end': 1155.154, 'text': "If I click on show more at the bottom, I'll see all sorts of different flows that I can set up.", 'start': 1150.092, 'duration': 5.062}, {'end': 1163.138, 'text': 'For instance, one of my favorite ones is I could post a message to Microsoft Teams for a selected item if I add that flow.', 'start': 1155.574, 'duration': 7.564}, {'end': 1168.921, 'text': 'So there are lots of different ways I can integrate my list with different apps and services.', 'start': 1163.198, 'duration': 5.723}, {'end': 1173.042, 'text': 'Not only can I have services feed into Microsoft Lists.', 'start': 1169.881, 'duration': 3.161}], 'summary': 'Microsoft lists allows customized email and microsoft teams integration for added list items.', 'duration': 27.773, 'max_score': 1145.269, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko1145269.jpg'}, {'end': 1222.356, 'src': 'embed', 'start': 1194.492, 'weight': 3, 'content': [{'end': 1199.018, 'text': "So far, we've just looked at what the browser or desktop experience looks like.", 'start': 1194.492, 'duration': 4.526}, {'end': 1205.005, 'text': 'One of the great things, too, is Microsoft Lists is also available on the iPhone and on Android,', 'start': 1199.398, 'duration': 5.607}, {'end': 1208.99, 'text': 'so you can take advantage of the list experience wherever you happen to be.', 'start': 1205.005, 'duration': 3.985}, {'end': 1214.993, 'text': 'Alright, well that was a quick look at how you can start leveraging Microsoft Lists.', 'start': 1209.611, 'duration': 5.382}, {'end': 1218.734, 'text': 'If you found this video helpful, please give it a thumbs up.', 'start': 1215.573, 'duration': 3.161}, {'end': 1222.356, 'text': 'If you want to see future videos like this, hit that subscribe button.', 'start': 1219.154, 'duration': 3.202}], 'summary': 'Microsoft lists is available on iphone and android, enabling list experience on the go.', 'duration': 27.864, 'max_score': 1194.492, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko1194492.jpg'}], 'start': 863.941, 'title': 'Advanced functionality of microsoft lists', 'summary': 'Demonstrates advanced features of microsoft lists, such as data visualization, conditional formatting, and data summarization with options like count of items. it also covers setting alerts, integrating with power automate, and accessing the list experience on mobile devices.', 'chapters': [{'end': 1041.674, 'start': 863.941, 'title': 'Microsoft lists advanced functionality', 'summary': 'Demonstrates the advanced functionality of microsoft lists, including data visualization using data bars, conditional formatting, and data summarization with options like count of items and different view formats.', 'duration': 177.733, 'highlights': ['Data visualization using data bars The speaker demonstrates using data bars to quickly visualize the size of a location, enhancing data interpretation.', 'Conditional formatting for specific data The speaker shows how to apply conditional formatting to highlight locations involving a specific person, exemplified with Adele Vance, to ensure quick visualization of relevant data.', 'Summarizing data with count of items The chapter explains how to summarize data by adding the count of items, providing a clear overview of the number of locations in the list.', 'Switching view formats for data visualization The speaker discusses the option to switch the view format from list to compact list, and upcoming features like calendar and gallery view for enhanced data visualization.']}, {'end': 1245.238, 'start': 1041.674, 'title': 'Leveraging microsoft lists for advanced functionality', 'summary': 'Explains the advanced functionality of microsoft lists, including setting alerts for changes, integrating with power automate to create custom flows, and accessing the list experience on mobile devices.', 'duration': 203.564, 'highlights': ['Microsoft Lists allows setting alerts for changes, such as receiving an email when a column value changes or when a new item is created or deleted. The user can receive alerts for changes in Microsoft Lists, such as email notifications for column value changes or new item creation or deletion.', 'Integration with Power Automate enables the creation of custom flows, such as sending customized emails or posting messages to Microsoft Teams for selected items. Power Automate integration allows creating custom flows, like sending customized emails or posting messages to Microsoft Teams for selected items in Microsoft Lists.', 'Microsoft Lists is accessible on iPhone and Android, allowing users to utilize the list experience on mobile devices. Users can access Microsoft Lists on iPhone and Android, providing the list experience on mobile devices for added convenience.']}], 'duration': 381.297, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xKQKw_hCqko/pics/xKQKw_hCqko863941.jpg', 'highlights': ['Demonstrates advanced features of Microsoft Lists, including data visualization, conditional formatting, and data summarization with options like count of items.', 'Setting alerts for changes in Microsoft Lists, such as receiving an email when a column value changes or when a new item is created or deleted.', 'Integration with Power Automate enables the creation of custom flows, such as sending customized emails or posting messages to Microsoft Teams for selected items.', 'Microsoft Lists is accessible on iPhone and Android, allowing users to utilize the list experience on mobile devices.', 'Data visualization using data bars to quickly visualize the size of a location, enhancing data interpretation.', 'Conditional formatting for specific data to highlight locations involving a specific person, exemplified with Adele Vance, to ensure quick visualization of relevant data.', 'Summarizing data with count of items, providing a clear overview of the number of locations in the list.', 'Switching view formats for data visualization, including upcoming features like calendar and gallery view for enhanced data visualization.']}], 'highlights': ['Microsoft Lists allows list creation, information organization, and collaboration.', 'Data can be visualized in grid, card, and calendar formats with defined visibility.', 'Brand new Microsoft Lists is now generally available with ongoing feature rollouts.', 'Rules in Microsoft Lists trigger email notifications for status changes, enhancing communication and accountability.', 'Microsoft Lists can be connected to Power Automate and Power Apps, streamlining processes such as customer ticketing systems and automating workflows.', 'Users have a high level of control over the presentation of information in Microsoft Lists, contributing to enhanced customization and usability.', 'Microsoft Lists can be used for various purposes such as issue tracking, inventory tracking, and patient tracking, serving as a broad-use tool.', 'Integration with Microsoft Teams allows for seamless communication and notification within the team regarding new issues.', 'Access to Microsoft Lists can be attained through Office.com and Microsoft Teams, providing flexibility in usage.', 'Microsoft Lists require a work or school Microsoft 365 account for usage, not compatible with personal Microsoft 365 accounts.', 'Microsoft Lists is an evolution of SharePoint lists and aims to stay competitive with other platforms such as monday.com, asana, and airtable.', 'Microsoft Lists offers various templates for common list types such as issue tracker and employee onboarding, providing examples and inspiration for list creation.', 'Options for creating a new list include starting from a blank canvas, importing from an Excel spreadsheet, or reusing an existing list with its structure and business rules.', 'Microsoft Lists provides the ability to add a new list, favorite lists, and filter recent lists, with the option to customize and share individual lists.', 'The Kevin Cookie Company is aggressively opening new locations and could use a Microsoft list to track everything.', 'The process involves defining the name and description of the new list, choosing a color (red is suggested as a power color), and selecting an appropriate icon.', "A descriptive description 'track new location openings' is added to the list to provide more information about its purpose.", 'The chapter demonstrates how to add and configure columns in a new Microsoft list, showcasing the flexibility and functionalities of Microsoft Lists.', 'The chapter shows how to populate data in the Microsoft list, highlighting the process of adding new items and entering information, including the integration with Azure Active Directory for franchisee names.', 'The chapter illustrates the feature of sharing the list with collaborators, demonstrating the options to grant permissions and work together on the list.', 'Demonstrates advanced features of Microsoft Lists, including data visualization, conditional formatting, and data summarization with options like count of items.', 'Setting alerts for changes in Microsoft Lists, such as receiving an email when a column value changes or when a new item is created or deleted.', 'Integration with Power Automate enables the creation of custom flows, such as sending customized emails or posting messages to Microsoft Teams for selected items.', 'Microsoft Lists is accessible on iPhone and Android, allowing users to utilize the list experience on mobile devices.', 'Data visualization using data bars to quickly visualize the size of a location, enhancing data interpretation.', 'Conditional formatting for specific data to highlight locations involving a specific person, exemplified with Adele Vance, to ensure quick visualization of relevant data.', 'Summarizing data with count of items, providing a clear overview of the number of locations in the list.', 'Switching view formats for data visualization, including upcoming features like calendar and gallery view for enhanced data visualization.']}