 Just do a recording. All right, and here we go. Well, good morning, Thomas. How are you doing? I'm doing well. I'm ready to get going. So how are you doing? I'm doing fine. This is kind of a melancholy-ish edition of our tips. Oh, yeah. Yes, I agree. Changes are coming. Yeah, change is happening. So for those that are new to this, thank you for joining us. Tom and I've been doing this. I need to go look at this. It's almost four years, I think. Somewhere around there, yeah. Yeah, and it's not been every month, but we're trying to stay pretty regular. So this is the last episode where we'll be doing this format with the voting. So we're gonna continue doing stuff, but it's going to change in the new year. So we don't yet have a date set for January. So January, February, Tom and I will figure out schedules and we'll get something out there. We'll still share 10 tips, but there won't be the battle royale. So I think we're in agreement here. Currently on the leaderboard, you have two of the stats and then we're tied on a third. And so today is it, like at the end of this. This is, yeah, there will no longer, Larry, there will no longer be the battle royale. It will be just us working peacefully together, ribbing each other still, that won't go away. But to make a public service now, yes, would you like to support the underdog here? Tom would be happy to get all your votes. Underdog, you're at the top of the stats. Come on, you're not underdog. I'm sorry, it's just, you know, I hit below the belt the whole bed. I'm gonna take whatever I can. Ooh, I like the new intro piece here, my friend. Yes, so that's a change for those that have been participating. So I have a new job. I'm now the Microsoft go-to-market director for Avpoint. So essentially what that means is I am responsible for the Avpoint and Microsoft relationship and especially from the product side of the house. And so it's a new role, very excited. It happened very quickly all this month. But I've known and worked with Avpoint for many years and they've been a client of CollabTalk, still doing CollabTalk community stuff and still MVP, RD programs, all that kind of stuff. But now I've got this other role with Avpoint. So, but they understand the community side. They are happy to continue supporting things like this. But we're like, we'll talk about it next month when the new format comes out. But anyway, that's me. That's my blog at Buckley Planet. All of the recordings of this today's webinar, the links to the slides, all of that, it will be made available out on Buckley Planet or out on my YouTube site, which is under CollabTalk. And so with that, Tomas. So basically they still get the product just slightly different packaging. Correct. Great, fancier packaging. Yes, there you go. As for me, all that stuff is exactly the same because I haven't gone anywhere. I'm not going anywhere. I'm still doing the same thing. Awesome. You're almost snowed in. So yeah, you're not going. I am almost snowed in. So I really can't go anywhere as the case may be. Basically work for an insurance firm out in the Pacific Northwest, but I'm based in Minnesota, Minneapolis specifically. Where we're expecting to get another five to eight inches of snow today. Yay. Minnesota. Yeah. Minnesota. Minnesota. Yeah, don't you know? Yeah, it's a little hot dish after I get done here for my lunch. You will find these tips and many other ones that I do on my blog, OneMinuteOffFestMagic.com. So feel free to visit there and subscribe or follow or whatever word press allows you to do with that. And with that, Christian. Yes, lay out the ground rules for the final leaderboard. Final count. That's where we are. So there's the beginning. So it's been so it's been three years. Since we officially started doing this. So right there, 9, 12, 2017. No, I guess that is four years. This is bizarre how close this is. Yeah, three and a half years. All right, yeah, because we were talking before that. But anyway, yes, there. Look how close that is over three and a half years. That's incredible. That is really unreal. And it's been a lot of fun. I remember when you first brought this up, it's like, I'm going to get creamed out on a regular basis. And the fact that it has stayed neck and neck and nobody has built a huge lead over the years. Yeah, it has been back and forth to look at the lead changes. But here's the rules of engagement. So we're going to take turns when we go through where we always cover 10 tips. Tom and I don't know what the other person is going to present. So there is a chance. It's happened twice where there we've duplicated. And so we have, in theory, we have backups. Tom, do you have any backups today? Maybe. I do not. It'll be interesting. Oh, so I'm in the water here. So I have another deck, so it's unformatted. I have some other items. It's my V-next deck. So if needed, I'll pull from that. But yeah, so there are no duplicates. If there's a duplicate in the past, if there's been a duplicate, if we've or if we've covered something and we absentmindedly went back in and talked about an item that had already been covered, that's happened a couple of times. Both of us have done that as well, where we will then in the post event, we will go and replace that with a new item. We'll take zero votes for that one. We'll lose that round. But you will get your 10 new tips. Yeah, well, always 10 tips. Audience votes at the end of each round. So we'll do the polls. We say no hitting below the belt. You know, Christian, since this is the last one, I promise that I will punch up this time. I don't believe that. You're right. Tried. And so it's the grand pooba of the event after this. And then we go from there. So all right, let's get started. I said I agree with you. This is a bit melancholy. These are I don't have any like huge zinger ones. These are some just some cool things, things that I've been using. Like I think go right about that one. But we'll see how it goes round one. Capture and share web content Microsoft Edge. Tom, are you an edge user? I was. But then I had a problem where I was getting weird, funky errors trying to connect to our SharePoint online client. Yes, gave it up. Yeah, I finally got it back. But it's I've never gone back and tried to put things back in place to use this again as my primary. Well, you know, except for the issue when you change browsers and you do things like you go to your bank and other things like the password reminders and those kinds of things that you just kind of get lazy around. And I use a third party tool last pass, so it's less of an issue for that. But there are some things like WordPress for my blog. It doesn't quite work the same. It's not really designed to work with. And it's just not fully functional inside of Edge and the new Edge Chromium browser does a lot of cool things. But so I have a couple sites that I have to use Chrome for. I could use Firefox, but for the majority of if I click on a new link to something by default, Edge, which is just faster, cleaner and has a lot of cool features that I'm using more and more. And one of the features is the ability to go in and easily capture and mark up web content. So just to show you how that works really quickly. So I've got this browser. Here's my blog. So if you go up to the top right, the ellipses and pull the drop down, you can select Web Capture. And when you do that, you get this free selector. You can just grab the full page and I use a third party tool for that. What I find with it, that other third party tool, it it's a bit slower than this. This is just a much faster method. And what's nice about this is, especially with the free select tool, so drag that down around the item is that you can go and add. You can just copy that, paste that into an email and do a word doc into, you know, whatever, save it as a file as that image. Or you can go in there and annotate. So add notes, go in, change the color of the pen, mark it up, change the line thickness. So whatever you want to do and highlight there. And then from there, you can again, copy, paste that into a source, save it as an image file or share it. And when you select share, just like every other, you know, office application, you select who internal, external, whether you want to, you know, via your Wi-Fi, find other devices and and you know, simulcast it to another location or send it via one of the many tools that you have within your system. So it's just a quick and easy, don't need a third party tool. It's really fast, has some great features. One of the things I've been doing more and more has been using that in clipping these things and parts of articles with links and putting that over into OneNote. And so that's my, you know, alt tab to move back and forth between browser and OneNote as I'm capturing image and notes and then marking that up and doing more of my annotations in OneNote around this. But this is, you know, what I'm using more and more. Well, what's nice, too, about taking the image like you had there and moving into OneNote. OneNote then turns into your OCR. So if you want to get that text and be able to use it in one of your reports or something, you've got that ability. So that's a really cool thing. I didn't know this existed in Edge. I think it's a newer capability. Yeah, you snag it as well. But I can see where this would be like a real it would it would beat the whole. What's the clipping tool? Snip it or clip it, snip it. There's a few of them. It keeps changing back and forth. The one that Microsoft snagged and snag. Yeah, it just like, you know, they keep changing it. And that's like my real low end. Hey, I just want to do a search for, you know, snip, and it brings up the snipping tool and I do it real quick. But I prefer snag it because I've got the whole editor tool that I can see everything and do all the stuff I need to do. This would enable me to do again, the quick and dirty stuff where I just need to grab something, get the image and then paste it into an email or something. Yep. All right, Tom, over to you. I like it. So let me share screen. Host disabled participant screen. I'm only a participant. You did this to me last month. Everybody's on the call. Remember, I'm making it right. You are now a co-host. Well, yes. Yes, I am. So this is a recent change that came out in teams, which is really nice because we used to get a lot of complaints about people going, you know, I'm really tired that if I'm not in teams directly, five minutes away from teams and it puts me in an away status, it's like, I'm still here, but people think I'm away and I'm not. And I have to keep going back. So the question was, is there any way to lengthen the time before you get these status changes? And before this came out, and this was only like a couple of months ago, the answer was, no, there's really not. Well, now there is, which is awesome. So if you're in teams and you go up to your profile image and you, you know, click the image and it gives you all the information that you have, you'll now see a new option called duration on the pop out menu when you're looking for your settings. And when you hit that one, there we go. It now gives you for whatever status you're in, you can now place custom times. You can either say, hey, I don't want it to reset for 30 minutes now or two hours all of today, all of this week, custom. I think this is great because while I do a lot of things in teams, I don't necessarily live in teams. And I don't like people to think that I'm away five hours of the day when in reality, I really am working boss. This is something that you can use to make sure that people are seeing you, they know that you're around. You actually have a legitimate status of I'm here, I'm busy, I'm available, whatever, and it's not gonna keep reverting back to a way. So definitely check this out in your teams client. If you haven't seen it already, I love it. I use it quite frequently. I'll just say that if there are any Microsoft people that are watching this, the recording or the live, I think it to say that you don't live in teams is blasphemy. I visit it nearly all day long. I just don't know that that's my house right now. Well, the poll is live. We'll give you a few seconds to do that. Yeah, it's funny. I mean, I used to just depends on the activity on the day. And there's some days where I'm just in teams the entire time and other days where barely touch it, I respond to a couple chats. Yeah, from a development side, since I'm in the midst of the whole SharePoint designer migration type stuff, I'm usually spending a lot of time in the browser in flow and in SharePoint designer doing things back and forth. So then I'll go back over to teams when I see something pop up, usually Sandra going, hey, I got some time. So I go back over there and make sure that, yes, I do, Sandra. Okay, five more seconds. If you've not yet voted, please get your vote in and the poll. And Tom, 60%, congrats. Thank you, everybody. Thank you, thank you. All right, round two. You love me, you really love me. Let me close off the poll thing here. So this is also a relatively new feature. And if you're in a teams meeting and you've had a number of attendees and for some reason you need to be able to see who was on the call and get a list of attendees in the whole bit, it really hasn't been easily possible before now. And even with the before now, there's still a little caveat on that one too. But they have made a feature available to you now in Microsoft Teams meetings called Download Attendance List. So once your meeting is over and before you leave the meeting, it's not an option once you leave the meeting. So that's one of the caveats. Well, that's a big caveat. It really is, because once you're out of there, it's like too bad. They are, I believe, doing additional changes, in which case this will be available for longer. And the information I'm about to show you on the second slide will be slightly different. But first pass, this is the rule. Click on the ellipsis, don't leave the meeting until you do this. And this is only for the person who's actually running the meeting. Once you do that, you can then export it, which is exports to Excel, and you get something like this, the full name of the person, when they joined, when they left, and the timestamp. Now, my fiance, my partner, who's upstairs in the other office, she, I heard her describe this to somebody and she said, yes, this report is semi-useful after some manipulation, but really, and once I looked at it, it's like, yeah, I get it. Because every time somebody joins and leaves the meeting and comes back in, you get another entry for them. So as you can see here, I joined the meeting, I have one entry, I left the meeting, I have another entry, I rejoined the meeting, I have a third entry to make it a little bit more problematic if you're allowing anonymous users to join the call, they all join with a full name of blank. So if you're trying to do deduplication of things, yeah, you gotta kind of play around with it because in this, I would look at it and go, I have four entries, I had four attendants, no, you really had two. And if I had a bunch of blank entries, I couldn't really tell if that was one person who kept leaving and joining or whether that was a number of people who were joining and that was all valid. I guess you could figure out if you had like, four joins all in a row that had blank names that those are four valid people. But again, you gotta do a lot of manipulation to give it a level of usefulness that you can make some assessments on how many people did join. I can't tell you for sure. This is better than what you had before, which was nothing. It's not perfect right now, but you could be getting closer to it, keep an eye open in this space. But again, if you have to go out and try to get names of people, especially if you're not using anonymous users, being able to download this and then do a deduplication in Excel is gonna give you a list of names, which is far better than you've been able to do before. So. Daniel has a question of whether people in the meeting can add their name somehow to the team. I mean, is there... I was thinking like anonymous users, he's saying not like people using a landline, people dialing in. Yeah, I'm really not sure, Daniel. I haven't gone through, usually I'm just an attendee in a team's meeting. I'm not actually running the thing. I could see where occasionally you will have something where they say, hey, join the meeting. Yeah, I want to join. They'll say, enter your name so I could type in Tom instead of it coming out as Thomas Duff. That would help. I don't know if you have that option though. I don't think you do. It's a good question though. Another one of those examples of Microsoft, a lot of people clamoring for this, wanting this feature, and then they give you something that's not quite what we want. Yeah, it's so close. They're so very, very close. Try Microsoft. Good times. Good times. It's it's it's funny because the pain is real. Yes, it is. All right, back order. So my round two item. Sticky notes and outlook on the web. I'm glad I did not use this one. I was considering it. So so there's there's there's been talk for for years and Tom and I have had conversations about this and and Tom and I are both huge, you know, one note users, but I'm a, you know, like the physical note taking guy. So I have a yellow notepad next to me. I have colored sticky notes that are on the desk on the on the monitor. I use to do. I use planner. I use one note. I keep track of create tasks like outlook based tasks. Former project manager, but I like capturing at that point and then aggregating those things together. So I don't lose that thought, lose that task, that action item. And this is just yet another tool I'm now using. So I have my new company email. I've got my company laptop, but I have open in the browser. I'm using more and more of outlook in the browser. And then I have my other my, you know, collab talk, my community email, my home email open in the desktop application. And it's been some of these new features are just really cool. And I so I'm kind of using all of the above, but what this looks like and you can follow the link and read more about it. So when you go into outlook on the web and you see, you know, very clean. This is so pristine. It'll never look like this. And so down in the bottom left, you can see, I've got it highlighted, the notes section. And it's clear and you can see right up at the top where you can, you know, add a new note. So there's the note section. There's where you add the new note up at the top left. And as you add those items and you can change the color of those items, you can add in, of course, text. You can do annotations. You can add images. I go and grab screen captures from around. I pull images and text and actions out of emails. I can post a note, one of these sticky notes. I can drop it into an email. So it's, it's a great utility. And one of the cool features beyond this is that, you know, not only does it keep them all in one place, but I don't have this where I've just started playing with this. I don't have it integrated into my new work one note yet. So there's nothing in my work one note to show this, but that you actually can get right into your one note feed and then you can share notes and images from the one note feed and most recently visited or created notes over in one note into your outlook or vice versa. And so it's just another panel view allows you to move notes and action items across each of those things. So really cool features, especially, I mean, what I'm most excited about is with the deeper integration that we're getting into tasks with planner and to do and to be able to do that across notes. I don't believe that integration is there yet. I need to go play with that, but I don't believe that's there yet today in these notes, but it has been something that's been mentioned so that wherever you create a task, even within these sticky notes, that it will then consolidate if it's a personal one into your to do view or that it could be shared over to planner for more of a team view of those tasks. Well, and this is something that I want to start doing a little bit more with in 2021 because Getting organized. That too, yeah, that would help a lot. You don't know how truthful and painful that was. But I tend to use like one wiki page in teams. And I thought, yeah, no big deal. It's just pretty much some cut and paste stuff that I need to use on a regular basis. And I remember looking through like, I think it was Facebook and people were like, they need to kill the wiki and teams and you should be using one note. And I'm like, hadn't really thought about that and being able to use one note in this type of a format because I too have switched over to using Outlook on the web. That would make it really easy to grab the little snippets of things that I need to do on a regular basis. So what's cool about this is the cross workload integration that's happening with tasks, with the sticky notes, with one note itself. So that you can use it on the desktop or the web. You can use it on your mobile device. You can use it integrated through teams and have it show up in a number of different ways for your meeting notes shared or personal and all have it roll back to that one place all stored within the cloud. Pull it in, be able to add and annotate via the sticky notes into one note. It's just really cool what they're doing. You and I both been longtime fans of one note and I think sticky notes concept was originally in one note. It's been extended now over into Outlook on the web. That's just cool to see. Yes, it is. All right, five more seconds in the poll if you've not yet voted, close that up. You did a dust up on me that time. In the poll, yeah, 70%, thank you everybody. All right, let's jump into round three. So this one is just, I'm living this because I've got a survey that's been out and live. If you've not seen it, I've been trying to get people who are admins to respond to a security compliance and governance poll survey that ends in another two and a half days. But you now have the ability to allow people to upload files. And so it's just another complex question type in the further expansion of Microsoft Forms, which I'm a fan of. There's a lot of positive, especially if you're doing something within the enterprise or for a set of known users, but like this poll survey, which is an anonymous survey, I just pushed it out, I've made it available, I've asked people to self-select. I probably wouldn't risk allowing anonymous people to upload files that I would then go and look at. That's me, I wouldn't do that, but you could. But to get started, so you just go into your forms.microsoft.com, but you can, the dropdown on the far right, you can see there, you've got the file upload option. So when you select that, it creates that question type. And so you can give that instruction, say, if you want to say, like, if you selected other in the last question and would like to submit a sample or submit your resume or whatever it is, you can have them do that. You don't be fun, it's like a team scavenger hunt, where they have to take pictures of the item next to it. That would be fun. They did it. Yeah. I just thought of it. I'm just thinking of what we could do for our family outing on Friday for New Year's. There you go. But anyway, so you have that. And of course, from this view, this is the view once you've completed that, this generic example from the user perspective, where they just go and select the upload when they click the upload. They get the standard upload, the explorer window that opens up, they select from all of their local and cloud resources. Once they've attached something, that's what it is, they hit submit. It submits, they complete, of course, the rest of the survey. I just had that one question. Thanks them. And then immediately the admin. So in real time, you're getting these responses back. And so I'm able to go in, in fact, I've got a screen open right now where I'm monitoring that public survey and watching the stats as they come in. And somebody spammed it. And I was able to go in and clean out the spam, throw off the other researchers. But right there, then you can go in and look at the details. So it's just a nice, another option. I know this is not a big sparkling, exciting feature. This is just one of those things where like, I've needed this for quite some time. And it's finally there. Yeah, actually what we find really great about that particular feature is when forms came out first, I was like, oh great, a survey tool. Don't know how frequently I'll use it, but it's a survey tool. Well, very quickly, we made the mind shift that it's really not necessarily just a survey tool. It can be a very simplistic, quick to put together front-end data entry tool. Oh yeah. And we use a form for saying, hey, if you'd like customized support from the SharePoint team, please fill out this form. And we give them the option to create an attachment. And the attachment could be a screen print of what they wanna have fixed or a Word document of what they think's going on. And it works out really, really well. And that was a huge thing for us to be able to put attachments in there because it gave so much more flexibility to use it as a data entry tool instead of just a survey. You know, we've talked about this before and I'll just highlight it again. One of the things that I love about this is also for as a training tool, you can embed forms, questions into a PowerPoint that you can then go publish on a slide share or OneDrive or create a sway where you might have like an example where you might have a bunch in a sway, a bunch of text, a video that people need to watch and then ask them three questions about what they just watched. And then you can check the answer so you can be onboarding people into your company and have them go through a bunch of material. And when it gets to that part of the presentation, they have to answer a couple of questions to see if they were paying attention. And in real time, you can capture the stats. So you can actually be at the front of a room of people, 100 people that you're onboarding into your company that you're training and look at the real-time stats of whether people are paying attention or not. Yeah, one thing to keep in mind with forms and PowerPoint like you were talking about is there's an add-in that's needed in PowerPoint to be able to use your form. Yes. And up until just recently, I'm gonna say like within the last two to four weeks, that was something that you had to ask your tech support to install for you in the whole bit. Well, now there's a feature that's being rolled out here really soon where you can have your admin basically say, yeah, that add-ins enabled for all your PowerPoint. So this is something that you are looking forward to or that you'd like to use. You may wanna check and see if one, do you have it on an individual basis? And if not, is there a way to get it rolled out to use forms within PowerPoint for your entire tenant? Yeah, if you've not started playing with the forms and embedding that into other artifacts, you definitely need to go take, spend some time and take a look. Definitely. So let me go ahead and share my screen now. It was funny, I was really kind of hoping here at first that I had my things set up properly because I do have a form thing coming up. It's just not this one. So this is a feature that we ran into, I think it had actually been out there for a while, but I just got around to looking at it. We've had on a number of occasion people go, hey, I need to see who viewed a particular document in a document library or a page. And SharePoint historically has not been really good in terms of stats, in terms of who viewed what. You can see like counts, but in terms of seeing individuals, it's been a lot more difficult. Well now there is a site feature called SharePoint Viewers. And in SharePoint Online, it will give you that kind of information of who's actually seen this. And so if you go out to site settings for your site, go out to site actions, manage site features. And you will see an entry, they're all alphabetical, so it'll be towards the bottom called SharePoint Viewers, click activate, in my case it was already active. And it takes like maybe five seconds and poof, you're ready to go. So here's what it looks like before. I'm in a library here, and when I click on the ellipsis and it tells me I've had 13 views, like okay, but who has viewed this? I have no way to tell. And I have a place to show viewers, I'm just not seeing any of them. Where now once you activate the feature, you'll see that 13 views again when you click on the ellipsis, but now you're starting to see the people circles as to who's actually been viewing this. And if I come down here and expand out, if I click on the 13 views link, it shows me that, hey, I've had two viewers, there's been 13 views total, and it shows me that Sandra and I have been the two people who have looked at this. And even better, if you click on the viewers link, you also get this viewers by week information. So now it not only shows me who viewed it and when they last viewed it, but it also gives me the ability to see when the viewing has taken place in aggregate. So I could go to previous weeks and maybe I saw a huge spike as part of some campaign that our company was running and then things leveled off to nothing. Or I can see that three months ago, this was really popular. Nobody's looked at it since then. Do I need to get rid of it? Do I need to somehow boost the signal to get that back out there again? This is a tool that you didn't really have before you had to have admin capabilities to go in and see site statistics. And even then it was a little questionable. Here, it's like right up front. So I do have a comment, Tom, that you seem to be focusing today on the big brother features. What's going on? I really can't tell you if I did, you would be in worse shape. Yeah. Sherry asks whether the viewer stats are exportable. Not from here. I suppose if you did start to try to check out like site statistics, maybe there'd be something you could do, but for right now, no, it's not viewable with this panel. Like all of this kind of stuff, if it's available within the system, it's captured, it's available via the API. So there's a way to get to that data with little development help. Yeah. So that one's mine. All right. Well, I've got the poll launched for round three. Yeah, there's another one that I have coming up here that's kind of like, you know, it does what it says it does on the box. Doesn't do much else beyond that. If you want to do something more than that, you're probably still going to have to do something on your own. But... Yep. We'll get about another 10 seconds. So the SharePoint views versus the forms capability. Four, three, two, one. All right. Tom, you took round three. Thank you, thank you, thank you very much. All right. Okay, so let us proceed to four. So here's my Microsoft forms one, that again, I wish I had had that number three because then we could have gone forms versus forms. This has to do with progress bars, responder progress bars and forms. So I'm sure you've all had surveys that you've been filling out, maybe even Christians, who knows? And you'll sit there and you'll answer questions and you'll say next. You'll answer more questions, you're like next. And after about the fifth next, you're like, when's this gonna end? Am I gonna be here for the next 30 minutes or is the next, next, the last next and I'm done with it at that point? Well, now what you can do in forms is if you have different pages or different sections in your survey, you can actually use a responder progress bar to give your people who are filling this out an indication of how much more information they have to provide because they're in the middle of it and they can't tell where the end is. So in this case, you do your survey and if you go to your survey here and you have sections you have this option for show progress bar. That's all you need to do is just turn it on and once you turn it on and you start filling out your survey in this particular case, this was my first page there's another page after this but I can tell, hey, I'm on page one of two. And so I know when I click next I'm gonna have a wrap up screen or I'm gonna have one additional question to answer and I'm done. And it's not such a big deal when you're talking about a two-page survey here with only two questions and two options in each question. But if you're doing something that is an in-depth survey that has a number of questions and a number of pages and perhaps you're not showing them certain pages but the person's like, I really need to know how much more time I'm gonna have to commit to this thing. This is a really good feature to turn on. I really can't think of too many instances where if you have a multi-page survey you probably wouldn't wanna turn this on but definitely use this, your users will thank you. And one of the things I like as an admin of the forms is in the stats, it does tell you the average completion time that it takes. Oh, cool. So you're getting some data as the forms owner but you're right, having the progress bar I think certainly helps. Cause I've done that where I've started to take up a survey to answer five or six questions and it's showing like 5% completed. I'm like, I'm gonna get this, I'm an out. I hope there's a question here. I can say no, it's gonna butt me to 90 like real quick. All right, let me share. All right. So here's one of those again, very, very cool thing in when you're collaborating on content, the shoot view in Excel, essentially what this is if you are co-editing, you're manipulating a shared workbook, a table that you can go in and manipulate the data and create a custom view without changing the state of the table without interrupting other people that might be editing. So they might be in there actively updating line items and doesn't matter. You can go create your filter view of the world you can share that out or you can keep it for yourself. So how that works. So within Excel online, so you got this here I've got a very complex demo table there states and colors with numbers. What does it all mean? It's too complicated, Tom, I can't get into that detail. It's analysis that you'll have to take care of. Click on ideas. There's ideas here. I can tell you what to do with your data, I think. Yeah, if there are any publishers out there or of NASA's paying attention, yes, I'm available. So within this, so you have in the view you have the sheet view and by default this is what everybody goes and sees. So when you select new, what happens is that you get the shadowed, you know the shading around the box around the space so that you know you're within this custom view and it's called temporary view. You can save it, name it, whatever you want. You can then apply whatever filters right from this view and share that out. So here I've looked at all the states starting with M. Complex data set, I know. But it's great about this is I can keep it, save it. I can share it out and then the sharing is just like everything else. You can invite other people in, share that view with them. And so that's it. It's the ability to go in and invite people in to modify and say, hey, maybe you want somebody to provide an edit but you don't wanna bog them down with all of the other data sets. You say, here's this piece that I need your input on are we correct for the state of Michigan and apply the right numbers and that's all that they see and get back out. And this goes back to, Tom, you know this, you've heard me talk about this too is Microsoft R&D did this product. It was never released as a product but called GitHub. And if you never saw the demo for this is really exciting. A lot of the capabilities of GitHub and Julia White did a demo at the Microsoft Partner Conference years ago. So if you go and search for Julia White GitHub it's a really cool demo. But part of the capability and it just seems so futuristic back then. This was like five, six, seven years ago where she was like, you know what? We need to call in Steve into this web meeting and they buzzed him in and said, hey, we're reviewing a bunch of financials. We want you to look at the numbers for this thing that you owe. And so, right there they were able to go in and highlight we just want Steve to see this part of the window invited him in, he provided an update the changes to the stats. They thanked him and removed him from the meeting went back into the full view and how his updates of that one section where he securely only updated and only saw that was relevant to his role. And then the rest of the team could discuss the broader finances. It was a really cool demo. And back then knowing how some of these tools work I'm just like, oh, that's all smoking. It's cool, there's all smoking mirrors to get there. It's not real. It's slideware. But, you know, here we have this view which is one of my favorites. So, all right. So with that, launch the poll for round four. Yeah, it's one of those things that, you know when you initially think of collaborative editing of things, you go, oh, no, no problem. And with Word, it's like, yeah, it's not that big of a deal. But you get into Excel and swing because I'm going to do a filter here and you're just working away and all of a sudden all your work goes away. What? Oh, Sherry points out that it was in the desktop version. Yeah, it was removed and now the feature is back. Yeah, it's, I don't know if they just changed the underlying technology for the sharing capability and stuff around it that they removed it. But yeah, I noticed that too. All right, going to end the poll here in five, four, three, two, one, all right. All right, we are tied up in the number of rounds here. I took that one, 73%. All right, so let's go into the final round. This determines it, the grand Puba ship of this event. All right, archiving a Microsoft team. So a little bit of history here when Microsoft Teams first launched, one of the first things that people started complaining about is, hey, there's no way to archive a team. And the reality is, of course, it's not a simple container. A team has chats and files and tools and apps. Groups and everything. Groups and all of those different things that are part of that. There's multiple containers. So to archive that, you had to go in and suspend the group itself. You had to remove permissions there in Teams as well as in SharePoint, make changes in exchange because of the calendar and the sharing capability and the chat and what happens to the chat logs, the chat history, all the conversations and all of those things that you had to worry about. It just wasn't a clean process. There were a couple of third-party tools which for years have done migration and management of SharePoint and Teams and to some degree groups. But again, these were these point solutions around that. Well, in August or September, Microsoft finally provided this way to simply go in and archive a team. Because the main thing is think of it from a user standpoint. When you wanna archive it, essentially what you're doing is you're removing people's permissions and their visibility into that thing. And so if it's removed, it disappears from Teams, it's gone to them. From an administrative standpoint, archiving puts it into a holding pattern where you can then figure out what I wanna do with it short-term or long-term. You can read state it or you can delete it completely. And then there are some things that you need to think about on the backend to manage those assets. But just to show you what that process looks like and again, to clarify, this is something that an admin does. But within the Microsoft Teams admin center, you go into your list of Teams, I created this productivity demo, you select that team and up at the top, you can see the archive button there. So select archive and that process then gives you a warning like, hey, this is what you're doing. You're about to remove permissions from this team and halt creation within that. And then you also have the ability, right there, which I recommend of making the SharePoint site read only if you are truly locking down the assets, the resources within that. People, of course, if they participated in one-to-one or one-to-many chats, they'll still have a copy of those chats that's part of their personal exchange online, that personal record. The chats still exist, but the conversations that are within a channel, those will all be frozen and people will be removed from that, unable to participate, to continue on those threads. And so you can also then go down and lock out the SharePoint site or lock down the SharePoint site. Once confirmed, so it takes a few minutes to process that, you see that little spinning wheel there in the middle and then the end of that. So the admin can still see it, it's still there, but you have the ability when you select it, you can see up at the top, it now says unarchive. So you've frozen that, you've cleared out, you've shut out users from adding to it and removed it from their visibility from their navigation within Teams and archived it, paused it. So if you've got a project that is no longer active, but all those assets are still out there, you don't want to break any of those connections and you just want to remove it from active use. And maybe in six months, you started up again. If there's new funding comes in for that project, you have the ability to go and do that with archive. I'm really surprised. One of the other things I do as part of the community is I do a weekly Microsoft 365 roadmap webcast with three other people. And I'm surprised that I was not aware of this at all. Yes, brand new quietly came out and Dave asked a great question and I'd actually gone and looked and didn't find any reference. So there's nothing in the documentations, how new it is around how this handles private channels. Private channels, while within that team, operate as almost as a separate site collection. And so they don't know the answer. Yeah, I need to go and find that out. That's a great question, Dave. Yeah, this is one of those things that I look at and go, this is cool, but then all kinds of other questions swirl around my head. It's like, well, do I have a way to just tell the archive? Do I have a place where I can put metadata about why it was archived, when it was archived? And the one that probably scares me a little bit more would be with all the changes they make to teams. Would there be something in the future that they would make an update and all of a sudden unarchiving something wouldn't work because there's been a structural change underneath the covers that could nail you there. So I love the idea that they're doing this because I know that, like you mentioned, there's been third parties that do it, but a lot of times budgets are tight and you're not gonna get the ability to do that. I will just be following this one a lot closer to see how they flesh that out and what kind of features they add on it because I think this could be really cool. Well, I will be, so after, of course, we'll have the recording everything up of all the tips. I will be blogging on each of the tips that I've shared and Tom will do the same over on his blog. And I will definitely go in and research and try and get an answer on the private channels because I think that's an important question. I'm gonna ask, reach out to some folks like Tony Redman and see if there is an answer if that's an open question that's out there. So I don't know. Yeah, it could be. Let me go ahead and switch over to mine and see how I can try to stand up against that to see if I can take the final round here. So the org chart web part in SharePoint online, I have seen this thing promised for so long and I kept searching for it because in our organization, it seems like every group that has a division or a department side of some sort, like, oh, I need to put the new org chart up and they've used them in PDFs and they've done them in Word and they've done them with Visio. And it's always kind of a pain for them because they have to put a document out there and make sure that it overlays or update the links or stuff like that. Well, this org chart web part is a great addition, keeping in mind that it does what it says on the box but there's not a whole lot of configuration you can do to it if you wanna go over and above this. So basically I've got a SharePoint online page here. Click on the plus icon, scroll down and I see the organization chart web part. So when I go ahead and get that, what I do is I type in the name or the email address of the person at the level that I wanna report on. Keep in mind that this would be like, for me, it would be my manager. If I put my manager's name in there, I'm gonna see his name and everybody underneath him and my peers that report to him. Now, if I had gone up like two or three levels, say to my AD assistant director, I would have only seen the assistant director and the people that report directly to him. So keep in mind when you're picking a name, pick the name that makes more sense to the people who are actually doing the work, not necessarily to the highest level. But if you do wanna see a little bit of a chain of, okay, who does my manager report to? If you do get the panel for the configuration over here on the right by clicking on the pencil over there, it tells you how many levels if you wanna go up. And I wanna say, I think I said three on this. Well, I did say three on this one. I wanna say it's like five, but I can't remember completely right off the top of my head. But anyway, here I have my manager and then we have his boss, his boss's boss and his boss's boss's boss. So this would be really good on a department division webpage where you wanna give people an idea of how things are laid out, who reports to whom, stuff like that. Again, this is pretty much all the configuration you can do. So you can't go out and start saying, hey, well, I wanna get this, but I wanna get this cross-organization thing and bringing these other people, you really can't do that. Probably the best you're gonna be able to do in a case like that is you may need to use multiple org charts to say, okay, I want to allow people to see the org chart from the perspective of who reports to the CIO. And then another web part of who reports to the VP of infrastructure and another one for director. And then finally the manager with all the people underneath him. The other thing to keep in mind, whoops, the other thing to keep in mind is since this is pulling data from Active Directory, if you have service accounts, not service accounts, but basically super user accounts, stuff like that that are in Active Directory and they've got manager information associated with them, you are possibly going to see multiple entries for a particular person. So when I look at my manager, I see my regular account, but I also see two of my test account, admin account type things. So keep in mind, it may not be really clean, especially if you're doing this for like an IT group, but in terms of it does what it says it does, this is a really nice low impact way to get an org chart on your page without having to try to maintain something in Excel, Word, Visio, whatever. You might want to check this out. And this is not built in Silverlight. And this is not built in Silverlight. Gosh, I have not heard that term like this. I was going to say, I was going to throw in while you were talking about this, is your company involved in human cloning? Yes, they just get a bunch of little minions that are running around there. So teams archiving versus the org view web part, final vote out there. We'll leave that out there. And let me, while that is running, let me grab the share screen back. I think it would be awesome if we actually tied this round. We'll go for a couple of seconds. So overall winner, just a reminder while we're waiting for the stats to come in, again, you can go out to Buckley Planet. Up at the top of it, you see the productivity tips and that will lead you to this post which has links to all of our past recordings, all of the slide decks. And if you click on each one of those for each blog post, I always break out with a timestamp to the tip that was shared to the video. So you don't have to listen through the entire hour again. You can jump to that specific tip that was shared that you want to get to. All right, I'm going to close out the survey and... You're going to take it there, my friend. Took it. Nice job. Thank you, everybody. You know, that's three events in a row for me. I was going to say, I thought I had been like two of three for the last ones that we had done, so... Yeah, yeah. So we'll... So with that, we don't have another one to promote, but we will be back in January or February with a new format. It'll still be 10 tips, but it'll be more... We'll be driving people towards our blog. So I think what's going to change here, I'm pretty sure this is going to be the fact, but Tom and I will be coordinating on the topics that we'll cover. So it won't be the versus, the head to head, but we're going to shorten the time frame. So we're going to do this in like 30, 40 minutes, and we're going to have already blogged about it so that we'll already have reference sites where we will expand on each of the items shared. So I think it'll be a great reference webinar and point you to some of those resources right away. And I will just remind you, Christian, being that we'll be under a bit of a time constraint, so we'll be like, okay, you've got five minutes for yours. I've got five minutes for mine. I still do have my electronic foghorn here. I think we need to break that thing out. I think we might go that direction. Yeah, and you don't, you can't touch it, which is awesome. Because I know that you kind of were preemptive on some of your horns when we performed live at the SharePoint conference. Well, folks, we are right at time. Thank you so much for participating today. As I said, recording the links, the slides, will all be made available out on BuckleyPlanet.com. And so, Tom, thanks a lot. Thank you. Great doing this with it, and we'll see you in the new year. Woo-hoo! See you all later. Bye, everyone. Bye.