 All right. Well, thank you everybody for joining. This is the office. Oh, so I forgot to change the title slide It's the Microsoft 365 productivity tips. Yeah, we're going old-school. Tom. We're talking about office 365 productivity but it is the June Jam and So it's the the I guess the summer of love with the dance party that is life right now and quarantine Sure. Yeah, okay. Let's go with that And how are you doing Tom? It's kind of a off-day found out that my dad's wife is basically in her final days if not hours and I'm expecting to call at some point to say that she is no longer with us Oh, that's right kind of a kind of a down day and this is the second time he's had to do it because that happened with my mom 30 some odd years ago too with cancer and so, you know, it's one thing when you're 50 something and that happens it's another thing when you're like nearly 90 and Trying to come back from that again. I am Fearing for him in addition to, you know her passing away quietly and peacefully so yeah It's one of those kind of days not going for the sympathy vote here. Just way to set the tone Tom Yeah, well, yeah, obviously hey, that's a I mean a serious thing and you know, hey prayers with you and your family Tom and thank you and and of course with with you guys out there as well and and Um, yeah, well anyway, we'll have another conversation afterwards about my trip to Minnesota next month. So yeah Oh, okay. I do have a call right after this, but I'll ping you when I get a chance. Yeah, no worries Um, so anyway with all that out of the way Thanks everybody for joining And I think we've got some some good tips today Just a lot that's going on in the tips world So it's like my third tips session of this sort this month Um, I'm just promoting brand Tom in those other uh sessions that I do so yay me. Thank you Well for those that are joining for the first time, uh, if there's anybody out there Hopefully we got a bunch of repeat customers here, but uh quick introductions. I'm Christian Buckley. I run a company called collab talk I'm based out of Lehigh, Utah about 45 minutes south of salt lake city Uh, and I may uh eight almost hopefully nine time will find out in a week in a week Uh, whether I get renewed for a ninth time as a office apps and services mvb and microsoft region director and I have a blog called buckley planet And that's me and and uh tom I am a software engineer at camby health solutions, which is based in the pacific northwest I actually live in minnesota And I have a blog also. Yay One-minute office magic where if you go out there, you'll find a lot of these tips That I post when I write them up usually once or twice a week So feel free to go over there and join in And what's great about this is so tom and I've been doing this for three three and a half years I don't know how long it's been now, but well, I guess you can see on the next slider But we keep track. We keep score of all of these events And right now tom is I am a champion And uh, tom's the most humble man that I know There he is rubbing it in But uh, yeah, it's it's amazing since we've been doing this since september of 2017 How close it is look at that the total votes over those those three years That's so close me away. We're 19 points away from each other Um, so anyway, so that's the here's the rules of engagement. Here's how we run these things We have the boxing theme the rules of engagement. So we take turns Uh, if you've never seen one of these before tom and I never repeat our tips So we're always sharing every month that we do this 10 new tips and we also can't duplicate each other So I only have one backup today I've tried to make it a practice. I have two backups. Yeah I only have one also All right, and and we've had to uh, uh use those I think once each Once yeah, yeah, so there's no duplicates there The audience will do a quick round of voting afterwards. So we kind of keep track and it's just kind of you know fun and short But it's what makes this difficult is that tom might share something from one note I might share something from powerpoint. They're apples and oranges And yet you're voting based on the comparison of those two no sympathy votes Sorry, please no sympathy votes as much as you loaded it front loaded the this this discussion Um, no, try to I was being very transparent. But yeah, no sympathy votes here And it's and it might be that that you know, both of them are fantastic. But which one do you think would Bring you the most immediate productivity, uh in your daily work Um, we always say no hitting below the belt Tom always hits below the belt because he's short. That's right. And then Fact hashtag fact you get very much Then winner based on overall voting and that's how we run it and let's go ahead and get started So I'll kick things off where we can do, you know, each of us takes turns, uh leading in the rounds and And we hand off. All right, here we go round one ding ding ding ding Here's something short and sweet. Love this feature though Restoring previous versions in file explorer Uh, and as I'm glad I have a backup Do you have this in yours? Yes, oh wow. Yeah, this is a great you have to admit tom. This is an awesome edition. Oh, it was it is it is So this is one of those incremental improvements And so as most of you are aware that Previously you would have to go into like power point is a great example You go in and be like dang it, you know, I deleted the wrong slides on this You'd have to open up power point go into the version history And find it that way or go into share point or one drive and go into version history that way or talk with your admin To go in and restore a version those kinds of things Well, now it's just really simple and file explorer. You just simply right click on the document And what opens up is the the dialogue box you select the version history And then you see the all of the edits that were made all of the saves to that file And go back to that last version's check through multiple versions To find the one that you were before you made the mistake of deleting that essential information Short sweet awesome feature Uh, can you go back to your prior screen? Um, because I want to point out a couple things that I was trying to remember to uh to look at Yeah, um, so this only works for things that you have In one drive in your syncing one drive locally in your file system in your computer The other thing to remember too is on the status column that you see there You'll see that green check mark That means it's actually residing both in the cloud and on your local machine And it has to reside on your local machine for you to pull this off If it's on the cloud only then you would actually have to go into one drive via the browser and Do everything there. Yeah, but yeah, this is a really really cool feature that is a long time coming and I just like it because Most people still work in file shares. Yep. And If you can use windows file explorer or whatever the mac equivalent is It's a lot more straightforward Rather than having to go go to the browser Find the waffle find one drive drill down Along with the appropriate Waits and time for things to load This just makes really quick and easy to do versioning and to get what you need back so you can continue working Yeah, and this is one of those things again Microsoft is doing a lot of this kind of thing where they're making these little incremental changes where you think Well, why do they change that or they slightly change the the menu options around this? And a lot of it is just because it's streamlining those experiences so that and and this will be a recurring theme today That you can remain working in context the environment where you are You're not having to go do the context switching switching between applications to get work done Yeah, I do a weekly webcast with Jennifer Mason Adam oaks and tamar brettemis And it's a weekly Microsoft 365 roadmap webcast where we discuss the new things that are coming out and Jennifer likes to use the term It's a delider It's not one of those things. It's a huge enhancement But it makes things a little easier and it delights you and those are sometimes kind of some of the coolest things out So yep Great. Let's talk to you see. Okay. Good So the first one I want to go with is surprisingly. It's a one drive feature also It's not going to stand up. Well, he has but hey So a lot of times when you have things in one drive and you're sharing them with other individuals That's all great. But over time Especially if you've shared like folders You may find that You might be sharing things that you didn't intend to share because you dropped it in a folder and you forgot That you were sharing it with the entire company or something like that So there's a feature where you can do a one drive sharing report now So you can audit your one drive area and see exactly what you're sharing and who you're sharing it with So if you go into one drive in your browser, click the options icon up in the upper right corner That will give you the one drive settings and if you click on one drive settings It gives you more settings and you click on the run sharing report And so the first thing it does when you click on run sharing report is it looks at all the files that you have In your one drive area And ask you to pick one that it can put the report into in my case I just clicked collection folder because I didn't have anything in there Click save and really in like seconds almost it comes through Puts a csv file out there that when you open it, it's probably going to open it in excel And what you end up getting is something that's really nice and there's other columns here I just clipped the ones that were most pertinent, but it gives you the actual path So here in my documents folder Microsoft team chat files that i've got images and stuff like that It tells me what kind of file it is What kind of permissions i've given people and who those people are that i've given it to Also, whether it's shared internally or whether it's an external So again, this is something that I like to recommend people do like every three to six months More if you've got more Critical information on there that you want to make sure it doesn't get out But this is a really good way to self audit your one drive area And make sure that you're not making a mistake in there That would lead you to share things with people who shouldn't see stuff like Financial reports and stuff like that So a little question, but when you when you save down the version the csv Does that automatically go to a specified folder or does it give you the option to save it to that location? It gives you the option to save somewhere in there. So again in my case I could have put it anywhere there or I could have just put it the root Of what I was dealing with. Yeah, but in my case collection folders seemed applicable for what I was doing So it worked Well, I'm gonna launch the I'm gonna launch the poll here for for one. I one other question more of a comment of you know, microsoft is doing more especially around teams And providing these kind this kind of insights. This would actually be really valuable and seeing across the teams like The from the files perspective, which of course can include One drive and share point and cloud storage So being able to So I Maybe you know this tom. Is there anything that's similar to that that looks at it comprehensively from the team's perspective Or do you have to go into individual? storage tools to be able to see that Like going to share point separately one drives. Yeah I'm not really sure. Um I will have to take a look at that. I don't yeah that because that You know, it seems to me like because that's an awesome report I would love to see that at a team's level based on what I've added into my files and be able to go and look at that especially Um, be able to have that level of visibility and external sharing. Oh, yeah. Yeah Most definitely. Okay All right, uh round one Ending the poll there if you've not voted five four three two One all right and the poll and uh, I took that one 68 to 32 percent Well deserved. Well deserved. All right, so let's go on to round two here And guess what? Hey, look you can hack sync one drive version history Uh, we'll just go right less relevant now here less relevant now. Yes Uh searching in channels and chats for microsoft team. This is a really big thing that has been painfully missing from teams up into this point and that is you've got all these different Work spaces and channels and chats But to try to find one particular item was next to impossible unless you knew where it was already in which case You wouldn't need to search for to begin with But they have now done enhanced searching in microsoft teams So that makes it a whole lot easier now to find stuff So up in the um command bar where normally you had to type slash something for a command Now you can just type in a search term and in this case. I wanted to find stuff that Involved my co-worker sander mahan. So when I typed in her name You'll see here on the left side It gives me the option to narrow things down to messages or people or files So we're going to scroll through some of the options here And then there's a link at the end because there's a whole lot more than just this but To keep up with the one minute office magic. I kind of had to narrow it down and just show you a few of the things so When i'm sitting here at messages I'm able to click on the from so I can say hey, I only want to see messages that are From sander or from me and in this case searching for sander mahan. It's like well, you've already got those Let's say I was searching for Finance or something like that. I could say I only want to see things That have finance in them from sander mahan I can also specify the type Do I want to see it from a chat only or do I want to see it from a channel that we have in there? And furthermore in the filters I can say Search for a certain subject search a certain date range Or find a particular team that you want to search in so in this case I only wanted to see things from sander mahan That were in our spark connect workspace and you'll see now on the left hand side I'm only seeing results that have team spark connect in there So that works out really nice to be able to find messages that are out there You can also if you type in a person's name like I did you can narrow it down to people So in this particular case when I typed in mahan It gave me both sander's name And sander's test account And then the items that are blurred out there because I don't like to include people unless I know exactly that They'll let me do that We had different names that weren't mahan specifically But they were close with maybe you know m a m Something something something so it gives you different names so you can be close But you don't have to be exact which is good Now files finally we've got in there because you're often putting files out in teams If you say I want to look at files. It's going to give you some filtering options there too One you can say I only want to see files associated from a particular team And or you can also say file types I only want to see excel files that have sander mahan involved So when I click that These are all files that sander mahan had posted out there That I have access to in teams So this is a really cool feature to be able to go out Search your workspaces Find the things that you need to find without spending hours and hours and hours Scrolling through endless chats to find that one little piece of information. I highly recommend using this If you're doing any work with teams at all and you need to do searches Now, are you able to also up in the search bar? Can you put in like mahan colon date range or or any other attributes I'm gonna play ignorant once again, which is a really easy act for me. Um, I don't remember if that's the case Again, I would strongly suggest Afterwards downloading the slides once christian posts them out there and click on this search for messages and more in teams Because that goes into great detail about all the different features you have in there And again, I had to make this kind of brief just to fit within timeframes. But again, you can There's a lot of search. Yeah. Yeah a lot of power under the hood there This is one of those kind of they silently kind of well added this in and there was there was a little bit of fanfare But uh, you know, they added this in there. But yeah, I mean some really powerful stuff there I I believe that you can add those other search terms like putting things with the quotes when you're searching for a specific Term a phrase or a name those kinds of things, you know, one of the things which is missing I'm sure we all want to see a number of other refiners and things But one of the obvious uh, misses as a filter would be on the tags the new tags feature I'm sure it's coming But um, it's more and more people use that that I want to be able to go and search on a phrase and then Refine that based on certain tags and and exactly other things, but that would be nice. Anyway, all right. I will stop sharing So here's a simple one working on documents without leaving teams And this is just another one of those ones that we've Talked around for a long time. It's been there pretty much to well not pretty much It's been there since day one And people forget about it. We get into the habits of how we work and I look I'm a fan of using the desktop applications Uh, I was just looking at this morning. I was playing with the differences because I was some of the new calendar Adding features in outlook for web that you you can't do in the desktop version of it And I just keep forgetting that Microsoft is they've been saying for years now We're going to develop for the web for the cloud first And when it makes sense to bring those features to the desktop to the local applications, they'll do And while it's it's not entirely true with the office productivity suite Um, we're seeing that more and more And I'm using the browser versions and the mobile versions of apps more than I am The desktop apps in a lot of cases, but here's an example of Working in context of not switching between various applications And this was I was reading an article out on the european share point website And there's a link to it within the slides there of some other kind of basic hidden features within teams And this one was just kind of a no-dub moment But when you have if you go into your your file tab within teams And you have all of the content that's been collected as part of that that team part of that that activity um, you know rather than You know Clicking and opening up and editing that in your local desktop application You have the the various options where this really becomes powerful and and it has meaning there because The reality is whether you open it on the desktop or in the browser It's the same file. You're working on the file that exists there in teams You're not having to you know the old school way of checking the file out editing it checking it back in Syncing so everybody can see that file No matter where you open that you'll be working in the live version if you're online and connected, of course You can still do offline. It'll sync again when you're you're back online But you can edit it straight from teams There in the browser without opening up any other window And it will automatically save to that cloud location and where this becomes powerful Is really when you look at if you've got content that is spread between your share point site that's there's part of whether it's a legacy share point environment that you've Linked into teams or it's the out-of-the-box share point environment that your teams the channel all the files Automatically save to or you've linked your one drive or you have some other third-party cloud storage device All of those are within that file experience So and I see from comment somebody's making about not seeing any other options So it depends on the environment. What do you have access into if you go into files? You know everything should be within You know teams automatically that your admin does have the capability if Depending on your user license what you have access to Whether you can get into the share point environment and open it that way Or if you're restricted to opening everything within teams But if you are the owner of a team or a primary user of that Yes, tom says you may also need to make sure that you have the latest version Of the teams client. You're using the browser version. It should be always the latest version But there you have options as an admin to restrict what your end users can do So there's always caveats around these things of what you have permissions to go and do But you have that ability to to go in and And like if I go and I I can see automatically because I'm the admin. I'm the owner of my tenant I can see all the different content types And I often will go into a project and I've talked about this in the past where I so I have part-time employees on research projects that are bringing grad students and I will go in and create for a research project A team and a series of channels relevant to that Research project and I will provide the tabs and the all of the the links to all of the relevant tools and outside websites and partner solutions Inside of that team and one thing I'll do is I'll bring in I've got my methodology in a share point site It's a legacy share point site. So it's not teamified It's not part of a team But I will then link to that within the files of every new team that I create so everybody can Access that centrally accessible site And if people want to open up a file or edit within that centralized site, they do it from one place within files So it's uh, yeah as jennifer says, you know, opening up the desktop app is the same as opening directly in the app So yeah, you can it's it's great to be able to do that It's just a it's a slight change in thinking about How you edit and open the tools again I I find myself doing the same thing Going back to the you know opening it up locally like there's any difference the features are the same It probably is more of a resource drain on my cpu cycles Opening it locally that it is in the browser for what I need to do And so most of the interactions the collaborations I'm doing the editing on docs It makes no sense to open it locally just open it there in the browser do my edits review the documents add comments get back out Yeah, I tend to like to use the client app because I like all the features But the other day sandra and I were working on something and we thought Yeah, you can do that in the browser and we went to the browser brace version of word. It's like Take that back. That's now apparently part of the browser base version of word So it always pays to check it out again just to see if they make changes Yeah, and and again, they're they're making sure that there are The the parody is between those those versions and in most cases there is complete parody If not more features in the cloud versions the browser versions All right. I'm going to close out the poll and tom I was going to say I think you should add one to that because I know sandra would have voted for me No, you're not buying this. Sorry. Yeah, okay fine. Go ahead. All right round three over to round three So here is something that is more of an organizational View of the world and this is uh, we we've probably all heard about this Are you guys using this internally tom? I I'm gonna say probably not but this is kind of outside of our little area Uh, because this would be more of the admin type things so we don't get involved with the whole info sex stuff. So sure Well, this is productivity score. I'm sorry. I was thinking the security score No, we haven't played with this. Of course. It's in private preview too. Yeah, so And so yeah, and I don't know how locked down it is for organizations. There's a request form I've got the link that's at the end of this if you're interested But the I mean it's all about better understanding and user adoption engagement within your organization And you can of course see within the scope now. Let me preface this by saying that microsoft This is kind of the side by side or the next step. I should say with the my analytics And that's something of course you can go in there and see I get my every monday the emails For portana that's sharing kind of the stats and different insights and I took the suggestion way back about blocking out me time And so I but I leveraged that that feature has been fantastic to block out time to actually get work done Versus sitting in meetings all the time But anyway, um, so this is kind of the next part Well, one of the things that microsoft was very clear on because when people saw the the the my analytics Some of the first questions out of the shoot where it's like, well, I want to be able to look at my five direct reports They're they're analytics and and I want to see who's doing what microsoft microsoft said No, that's not the purpose of this And they they said we're in fact where we are going to provide something which is this productivity score We are going to provide something but it's going to be anonymized for certain And you can't even get access to it until you have I think it is ten or more pieces like that. Yeah looking in So you cannot be used to go after and follow like one individual and what they're doing the stalker features You know, um, right and so this is so which is just great that they have that in mind So the goal of the productivity score is to give you visibility and how your organization works Give you provide insights of where you can improve the experiences to to help people And then give you those Those actions to make you actionable give you suggestions on actions um So as you start to look into that, um It goes into both employee experience the technology experience and provides you as you can see Uh, you know a bunch of stats here if you've not gone and read one of the blog posts around what's available It's interesting even as an end user just to understand What's being captured and why? Sometimes that might change behaviors If you're well human beings when we understand how we're being measured we tend to optimize towards those measurements A hot corn effect. Yeah. It's called gaming the system. I mean and look it's it's not a bad thing necessarily We all want to perform well. I guess there's another reason why with analytics um, you know admins management needs to constantly be reviewing and Updating uh, uh upgrading those those measurements because as you get more data you learn more and you make adjustments And similarly what they say is, you know, what gets measured gets done. So right? um, so it's it's about Getting people making helping people to be more productive to get more engaged um, and and fitting and changing evolving the technology to better fit The collaboration culture of the organization because that's the most important thing Is that you want to you're not just applying and force fitting technology on the organization You want to best leverage the technology to get the most out of the tools And to best fit the the organization Um, so it's about all about optimizing that technology. So some examples Um being able to show it'll come back and say well look of all the devices Here's what's happening. The performance of devices is is slowing down Um, it'll then come back with some recommended actions like here's things that you can go and do to fix This is what the uh, the change will be you'll even see this over in the azure environments if you're leveraging azure where It will go through and optimize how you're using azure and this is almost counterintuitive Microsoft is providing data and recommendations which could mean that you use fewer licenses And they're providing this because it's about the best experience Optimizing your experience because if if microsoft has come back and saying, you know, you're buying too many licenses You're never leveraging these other tools. You actually don't need this many of this Additional license like you're you've bought a hundred power bi licenses. You're only leveraging 30 of them for example, right? So that you can save some money. You'll be a happier customer and get more out of the solution So here's some examples there of some of the actions And i'll let you read through i'm spending too much time on this but There's the link there uh with the link to the form the the just aka.ms productivity score preview So if you're interested um go definitely go request that and uh and take a look but read more There's a lot of information much more in depth and also does kind of a side by side There's a couple different blog posts out in tech community Where they talk about how this fits side by side with the my analytics and how you look use both Sets of data to improve collaboration inside your organization Very cool Looking like you've seen my video now Uh, my third round tip is audience targeting in share point online navigation links Uh, really cool. They've had audience targeting for like web parts and stuff like this, but just recently They've actually rolled out site navigation audience targeting And it actually also after this I found that it's also like for header and footer stuff too But what this means is you can put links on your page That will only be seen by people who are in particular active directory groups So to start this off, we've got a a site here if you go down to your left side navigation and click edit That gives you the left side panel for navigation in edit mode And you'll see this new option at the bottom that says enable site navigation audience targeting You just go ahead and turn that on And then when you turn it on and you create a new link you still have the add a link add the address display the text Now you can put up to 10 different active directory groups in there That will specify who can see that particular link. It's not security It's just filtering. So for instance, if you had a site out there that had news for the company or something and On the left side, you've got four different locations and you've got a link that says link to location a link to location bcd You could go out there and put all four links out there But turn on audience navigation to say only the people who are in the location a ad group Will see that first link Uh, you know location b. They'll only see that link so on and so forth. So you can start to Personalize your page into what shows up and we think this is really cool because A lot of times we have people going well They see a bunch of links, but they may not we may not want them to see the link or The link isn't pertinent to them or stuff like that. Well now with audience targeting You can start to reduce the number of things that people see And make your site more streamlined to only show the things that certain people should see Instead of just flooding a ton of information out there. So again, I encourage you to try it It's a great addition in my estimation and we're starting to use that quite frequently Yeah, anytime you can Personalize that that experience. Uh, you're going to improve collaboration Right. The poll is open We'll let that go for a while. Yeah, you know, there's um, I I shared in uh, this other webinar that I did on teams tips, uh, you know talked Shared a number of features a couple of yours a couple of mine, but around You know navigation improvement in fact, I think that's one that we shared in this series Like a year year and a half ago the two-way Uh connections between The various environments it's uh, right it's all about improving Being a streamlined navigation experience and get people to the information that's relevant to them The quickest and it's uh, we used to have these conversations all the time in the share point world about how can we simplify navigation? How can we customize the results of what people are seeing within the portal? So that they're only seeing what's relevant to them And it was a real pain It's crazy though how you see usage jump up when people only see the content that's relevant to them Yep, the poll Tom 71 percent Woohoo Okay, let's see if I can close the door on you in our next tip for round four Adding your own images to microsoft teams meetings. So this I think we covered this last time I believe yes in the fact that you could use background images And if you knew the hack you could actually put your own images out there but involved drilling down about 16 levels of folders And I was not terribly thrilled to want to let people Know about that because I could see them going through and deleting the entire folder and teams didn't work and I just I think the community was pretty loud and clear to microsoft like Hey, come on. Yeah, you're almost there And the thing is when you drill down to all those folders You saw the images that you saw by default and there was a folder in there that said downloaded images I was like Okay, you're gonna let us do it. Why don't you give us the user interface for it? Well, they finally did So if you want to add your own images and just remember just because you can doesn't necessarily mean you should You go into teams and you click on show background images like you're used to Doing if you want to add a background or if you want to show a background image But now you'll see at the top under the words background setting. You've got an option to add new And so this is going to do all that stuff for you that you used to have to drill down into the folder features And so in this particular case, I went out to where I had some images stored I took an image of the akaba amphitheater in petra because we had a wonderful vacation in jordan This year before covid hit. It was great So what happens is it goes ahead and adds that in there real quickly and it becomes one of the options for a select Selectable background. So I went ahead and selected it clicked on apply and turn on video And voila, I'm coming to live from akaba So this is really great. You can start to customize some of your features Some of the things that mean something to you or you like as a background But do keep in mind that there are certain limitations. You can't take a little You know 100 by 100 icon and make it a background. That's just not going to fly So there's a hand that it won't look good Well, in this case it won't even let you now Okay, if you try to add it, it'll say ant sorry didn't meet the minimum size specifications Which are 360 by 360 Even that if you've got a large screen that may pixelate on you not wonderful Conversely maximum size 2048 by 2048 That's going to be really nice But it's going to take a little while to load because it's probably a large image out there You can use jpegs pngs and bmp files. Keep in mind bmp files are quite often really large Size-wise so you may want to Bring that down to a png or a jpeg issue and then an aspect ratio has to be greater than four But within those confines They've actually made it really easy for you now to go out and start adding your own custom backgrounds We have one meeting. We were really not too long ago before they actually started allowing you to do that and somebody had this background image that You know, it's like oh, that's kind of cool But then they kind of came back on the camera And he'd actually tape this huge picture on the back of this wall It's like, oh gosh, we really could have helped you with that, you know But um again All of that just that that oh god. Yeah, it was it was rather humorous. I had to laugh Um, but yeah now you can go out there put your own folder put your own images out there for backgrounds on your team meetings It's actually a nice user interface And you can do it without any chance of messing up your entire team's things So have at it, but just remember this is usually a business situation. So make sure that your backgrounds are appropriate Are those all your pictures over there on the right like the the ones that you see there? Yeah, the the sphinx and the Chiro pyramids. Yeah, those are all some of the pictures that we took The one there next to it was at one of the market places at night. It's a beautiful picture Uh queen nefertiti's tomb the jackal right above that Oh my gosh, you would have thought those things were painted yesterday and they're over 5 000 years old It is just unreal Tom. I have to say I'm a little disappointed I believe I did request that you bring back some kind of mummified creature for me and I'm still waiting so Yeah, I'm yeah, I opened the little Thing and kovat got out and I just closed it back up and I decided I didn't want anything to do with it So sorry Yeah, I was thinking of you by not opening that can of worms or pandora's boxes may happen to be All right, I'm grabbing back Natural language queries in excel So I'm a huge fan. I've talked about it several times before the whole ideas movement that's happening within office Talked about you know ideas and powerpoint Uh, just I absolutely love that You know, I don't have the the time or the patience to go make power points look pretty And so just able to dump my the images in the text into a you know, just a Vanilla template and it come back with 20 different beautiful versions of it I get to select from those and they all match. It's fantastic when excel what I shared previously Was ideas was basically your pathway to learning power bi and being able to create Visualization so you you add in your table of of data just You know simple data and the example that I shared and be able to go in and And select the data set In your file click on ideas and it would automatically Generate these visualizations Very cool. Well, there's kind of the other half of what ideas provides Which is the advanced query capabilities So you can go in there's a couple different ways you select the data Click on the the sheet and uh in your spreadsheet click on ideas And the first thing you click on the query box and it will drop down kind of suggested questions common questions Based on the data that you have there including some visual visualizations You can or you can type in using natural language about your data Just start asking a question. What are the total sales? Of locks and helmets and in this data set and it will attempt to provide using the ai capabilities and answer As well as a visualization based on that response. And so you can select from those response types So it's really just that simple. There's the little animation. That's a little bit blurry here But kind of shows this feature Um, but again just you know, you've got your table of data click on ideas And then just go start asking questions It's a great way to explore your data and to see what's possible And what's what's cool about this as well is is if you're you've got this data set You're planning to share that rather than just creating a table format dumping the table into a A presentation and sharing that is to get some ideas for more creative ways of sharing that same Data it asking questions right there You could even do that as people are asking questions about your data while you're sitting there in a meeting You can even pose those questions Into your data and see if there's anything more informative that falls out of the ideas Which you can share there in a live meeting But that's it. So there's more information about it at the link there, but uh, again, huge fan superfan Of what do they call superfans? Fanatics, yeah, yeah I know fanatics. Yeah, but they they're talking about like the superfans of like the k-pop kids. They they call Oh, yes. Yes Or or stand stand. Yes. Thank you Thank you. Yes Yeah, this stands. Yeah, so I'm a stand for uh ideas Stands. There you go. There you go Okay. Oh with that. All right. I'm gonna launch round four poll Okay Yeah, I I am using ideas More and more so I just was using playing around with uh, I wasn't gonna add this Uh, and it was until last week. I you know, I've got my v next version of the slides And as I come across it, hey, that looks cool. Let me I'll think about that If I want to add that in for the next week or the coming month and I'll You know kind of add in kind of a placeholder Um, of course, I also there's a lot of things which are not yet available That I'm just like I want to talk about this in the future Tom or I need to cover this Um, but it's not yet available. So I don't You know, don't chat about it yet. And so I've got those placeholders out there Um, like I if you caught us last month where I fooled tom when I he thought I was going to talk about the list app That was uh, still not available. Um, somebody just asked yesterday when it said is that available? I can't see the list app yet. It's still not available All right, uh closing out the this if you've not voted five four three two one And we're split So I took that one two two All right, we go to round five. Let's close this out All right, you don't take another one of mine because I'm in my backup now. Okay. Here we go Expanding your outlook calendar Okay, I'm good Well, this is uh, so this is one of those things we're talking about um, you know the the Online versus desktop versions. So we're talking about the cloud version of outlook the browser version of outlook There's so many new features that are coming out. Um, in fact, a lot of the I talked about in prior episodes the power point capabilities like the the the coaching that's in power point Like that's all out there generally available now. It's being rolled out now if you don't yet see it in your tenant Um, but similarly you should have this it should be global It's all generally available But it's expanded uh outlook calendar capabilities And so this is just great way that you can go and and add Other you've always been able to add additional calendars And if you're not using this feature like I have people that I you know personal connections work You know connections to where I can have you know views into different calendars But microsoft has provided some canned experiences that are really cool Um, not everything applies to my life But I see where they're going with these features and I can see where this is expanded So if you go into Outlook calendar in uh in the browser And go into the add calendar dialogue. You'll see this new Uh experience and down at the bottom there you see those options where you can add in You know share this with other people Create a blank calendar or you can add school holiday team snaps sports and tv Uh and then provide feedback to microsoft and other calendar types that you want to add what that actually looks like. So I I See if you go moves forward here Um, so the different options that are that are they out of the box what those things mean So here for example, let's say that you're really plugged in you have to have on your schedule the must watch tv on your life And hey, no no judgments here Laughing taking into account that I did not laugh that tom laughed at your tv watching habits. I'm just saying Not just laughing at your tv habits my friend. Oh, this is this is other people Just an example here. So you go in you add the calendar you select the tv It'll ask you for your time zone the network that you want to select from and then all of the programs And you then add that in it will then add a new calendar with all of the programming What's in the schedule so you can go in there then you know add the things that you want to watch and Delete the things removed from that calendar that you don't care about But if again if you're trying to keep tabs on your favorite shows For some people out there. This is hey, this is an awesome thing um It's uh, of course, it doesn't have like netflix and and some of the other streaming services that are on there But all the other traditional broadcast cable networks. Here's the one that's a little more relevant. I think to us So here I think it's important if you've got Kids in school is to be aware of their calendars. What's happening? um Like I was always stymied by the fact that I could never keep track of My kids were in when they were in elementary school, of course They're all in college and two of them married and stuff. So they're they're they're old. I'm old But uh, I would always be stymied by like what do you mean this week? They're all half days. What's going on? Oh, it's teacher training day or whatever it was and I'd be like, okay, so Both of us are working and yet one of us needs to now go pick up the kids at noon Rather than three and so keeping track of those schedules Uh, or which days were holidays? I I have my own business. So holidays just another working day for me Track of all this stuff. So now I can go in so I could go into schools Enter in my zip code It'll pull up in the zip code all of the schools that are in the area Select my kid's school and it will then add that calendar. You can see on the left the elementary school So I've got their holiday schedule any special events anything that's visible there. This is fantastic Um, the other options I should go back here I forgot to add this back in so that I did talk about the other options there of schools the holidays, of course Um, national international holidays team snap. That is for children or intramural sports leads So it's a specific app for tracking that. I'm not a user of that app. I don't play intramural sports But that is I went and looked at it briefly. It's a really cool app if you're into that stuff Keeping track of that and then your favorite following your favorite sports teams being aware Where they're playing when they're playing. So that's really awesome for those people I know my brother-in-law works for microsoft. I'm pretty sure he's not aware of this He's one of those that has the nba league pass wasted money this season That capability be able to track I mean pretty awesome So and and why this is so important too is that I live around my calendar I mean I have my personal time blocked out. I have my vacation schedule I have it as I'm mentioning at the beginning of this I have it integrated with Calendly so I can have when people want to set appointments with me I point them to that Calendly link and it automatically knows my schedule It knows when I'm available and will go and allow anybody to go block out that time when I am free Uh schedule meetings with me. Um, so that is you know, I live and breathe by my calendar by outlook Still is that primary collaboration workspace and uh, so having this capability is very cool This one out. Yeah, definitely gonna check this one out. All right. I'm gonna stop sure Okay, and we're actually gonna do outlook outlook this time outlook on the web You're mentioning earlier You know things coming to the web before they come to the client. Yes I have actually now switched To only using outlook on the web and Almost everything is the same or better Um, but one thing that I had seen that they were doing for outlook on the mobile device That now they've actually pulled into the cloud based uh web based version Is that they have suggested replies available to you now If you've used gmail before you're used to you know, you start typing something gmail It tries to complete something for you or gives you a set of like three responses You can just single click boom. You're done Lincoln does that as well. Yeah. Okay. Same thing Um, now you have that in outlook on the web. So I had gone ahead taken of uh Email that I had up here and when I did reply It gave me the option to say welcome. You're welcome. No problem. Whatever Um, and so I was able just to click on that and it sent off the email with no problem whatsoever So you're welcome boom off it went But if you noticed in that first one I like this and the fact it says are the suggestions above helpful. Yes or no So if you've got suggestions that you're like None of these are really Adequate or if you're working in a non-english language, you're going um that translation does not mean what you think it means You could always click on no. This wasn't helpful And then it says please tell us why okay or not now and when you click on okay It gives you the option to check box off which ones that you know bothered you For being rude or not the correct language or whatever And you can go into a description to tell them why you don't think that was best So I think this is really cool And this is one of those things that I'm starting to look more and more for it now when I had an answer like this morning somebody sent me a request Said does such and such occur blah blah blah and one of my things was no it doesn't But click okay that one's done Rather than having to sit down and type out the answer Which probably wouldn't have been a whole lot different But I'm just liking the fact that you have that option. So If you've got the web based version you should be seeing that Um definitely check it out. You know one thing that I use more than anything Tom is like in facebook messenger and even over on linkedin is the little icon of the thumbs up Yes, that one's kind of cool too. I'm starting to use that more and more Yeah, that's that's like a uh, and I'm gonna let me share back again really quick But it's uh what I like the thumbs up as a auto response Just because it's an acknowledgement like I read it Like great no questions. There's a lot that you can kind of You know throw into that It's uh, it's a really nice to have that feature But like you I mean in mobile it's fantastic where I'm not going to go into a lengthy response I might wait until I'm back at the desktop Um before I do the lengthy response Uh, so it's great having those quick and easy Tom you have one again Wow, I fully expected a calendar one to take that one Oh, well, I think uh as far as productivity, I would disagree with you. I think that uh Yours is the winner. I would have selected yours Well, thank you very you stay right now I love that feature. It's it's great. I use it every day Um, I think about it every time I use it like I this is great Um, I like this one. Yeah, so anyway So uh for for everybody that uh, thanks for joining We don't have a date for july tom and I need to coordinate schedules And we're going to try and get the next two three months Locked down and and let everybody know we'll share that that link out So if you like the format, please come back What I will say Is that tom and I both try to go through and add to our respective blogs all of the items that we have shared out So please subscribe to follow both of our blogs This entire recording I should have out this evening should have it out on youtube so you can share it with team members Um, and those that have been back and are aware that I'll also have a blog post up on buckley planet dot com In fact, if you go to buckley planet dot com up at the top There is the productivity tips in the menu and you can access every single one of our recordings or previous recordings As well as this one will be made available And in the blog post for each of those recordings I also break it down with a link to the specific tip So you don't have to listen through again to 60 minutes to try and find What was tom talking about at the 35 minute mark? Um, I provide a list of the 10 tips with a link to that time slot that or that uh, that that uh Time stamp in the video so you can jump to that tip as well as we provide our slides So you can download and and get to all of that content. So lots of ways that you can consume this content after the fact That's a lot And with that with that thanks a lot tom Thank you very much. I can't wait to see next month stats. Whoo. Whoo. Yeah We'll head a little bit more tom Have a good one and we will talk to you next month. I'll see you later. Bye. Bye