Microsoft Lists Tips and Tricks #2 скачать в хорошем качестве

Microsoft Lists Tips and Tricks #2

🎯 5% SPECIAL DISCOUNT - https://academy.microsoft365atwork.co... Customize the way how you presenting data on Microsoft Lists using available features. Check the second set of tips and tricks: 1. Set the totals and group the data on the list view 2. Create the Calendar View 3. Customize the visibility of the columns on the native form Learn more about Microsoft Lists: https://office365atwork.com/category/... ⏰ Timestamps 00:00 - Title 00:14 - Introduction 00:52 - Totals and grouping on list view 03:00 - Calendar View 04:20 - Customization of the list form 06:06 - Conclusion 06:16 - Outro 🚀 Microsoft 365 for you Get Office 365 development tenant: https://office365atwork.com/O365-test... 💻 Elements used in the video Office 365 Enterprise: https://office365atwork.com/o365e-comp Camtasia: https://office365atwork.com/cam Audio-Technica AT2020 USB Plus: https://office365atwork.com/mic Music: https://www.bensound.com 📌Check us out, Follow us, & Like us over at Blog: https://office365atwork.com/articles/ LinkedIn:   / bochniakszymon   Facebook:   / office365atwork   Twitter:   / o365atwork   Reddit:   / szymonbochniak   Podcast: https://office365atwork.com/podcast-blog 📔 Transcription I prepared for you a package of tips and tricks that will help you to manage their way how data is presented on Microsoft lists today. I would like to present a few ideas on how you can improve the way how you present data for your business users. I will share with you a few tips about changing their views on Microsoft List. So how the grouping how totals can be added very quickly to your view. I will present the new feature calendar view that improves the way how you can spread the data across the calendar. Occurs the dates and how you can quite easily add the forms on Microsoft List but not using powerups. So something totally new and very cool. TOTALS AND GROUPING The first thing I would like to share with you today is how to add totals and grouping the data across the view on Microsoft lists. This is something that will help you to present better way multiple records or maybe complex data to the users and to found the best value from perspective. What people consider. So let's start by adding the totals to the columns. So just select the column then choose the totals and you can see that you can. Add an additional summary of the information. In this case, we will get the sum value for net value on the column and the same thing we will add to the gross value to add the totals you can see you can also get other options here but we will start with summing the data. Moreover, you can also count the records on the title, and you can see that based on that you get some kind of summary of what kind of value of the records you have presented on the information that the second thing which could also help you to better present possible information stored in this record is to group the data by some category so you can see we have two columns here, Department and priority. So we will group that data based on that priority, and again when you select the column, you get the group by priority option. When you select that, you will see that data will be spread across different priorities. Moreover you can also see that counting and summary values form. Columns are also spread across the group, so you can see if you have complex records that kind of very simple operation could help you to present the data better. To spread this report across different categories and also to show how this information differs between the records you have. So a very simple solution. High recommended to try it. CALENDAR VIEW The next cool feature I would like to share with you is the calendar view Microsoft, at last, delivered the solution to gives you the possibility to create the new view, which will be the calendar view. This is the functionality which is missing since the very beginning of the modern experience in SharePoint on Office 365. And finally, you can create the calendar view by choosing the start date, the end date, and the column that will be presented. On the final calendar view, so when you will do that, just select the create and the calendar view will be created for you. After a second, the calendar view is created. You can see that data is presented more like events here, so you can see just the title plus the time based on the date selected in the previous screen. This is a really great solution for any kind of events, registration, time reporting or holiday requests, so please feel free to try it. But remember this is a very early stage of that functionality. There's no much functionality here yet. But it will be improved in next month by Microsoft, so stay tuned. .... Whole transcript: https://office365atwork.com/lists/tip...