There are times when you are working on a Word document, and you have to match the formatting on your content to formatting found somewhere else in the document. Rather than try and figure out the font settings, you can instead use the Format Painter option to automatically match things up. Here’s how…
Author: oneminuteofficemagic
Spicing up your Microsoft Teams channel posts and conversations
In the Conversation tabs of your various Microsoft Teams channels, you can have a lot of information going back and forth that just sort of blends together into a blur. That’s fine for the normal team chatter, but you may have something to post in there that should be more noticeable than everything else. That’s when you want to use the Formatting feature in the post area. Here’s how to do that…
Using your Activity Stream in Microsoft Teams
If you belong to a number of Microsoft Team workspaces, it can be a little overwhelming to keep track of all the conversations and activities going on in every one of the Teams you are part of. However, you can use the Activity Stream and the associated filter to make it easier to see just the items that are most important to you at that point in time. Here’s how that works…
Concatenating Excel data with Fill Justify
This is one of those tips you may not know about, but it will be a lifesaver if you only have to use it once. Using the Fill > Justify feature in Excel, you can concatenate data from multiple Excel cells into a single cell. It’s easy, and here’s how it works…
Repeating Excel formatting functions with F4
This is a cool feature that I was unaware of… you can use F4 to repeat a formatting function in Excel. I tried out the F4 repeat on a couple of cell formats, and it works pretty well. Here’s how…
Multiple Office Clipboards in Office applications
Having done this tip gig for a number of years now, I don’t often find a tip that blows my mind. It’s even more rare that I find a tip that blows my mind, *and* has apparently been there for years. Today’s tip fits that bill… you can have up to 24 selectable Office Clipboard entries to choose from when you’re working in Outlook, Word, Excel, or PowerPoint. Even better is that they are shared across all those programs! Here’s how it works…
Adding shadowing to your PowerPoint images
This is a subtle tip (or at least it should be in my opinion). When you add an image into a PowerPoint slide, it normally starts out in a pretty flat state. However, you can use the Shape Effects option to add some depth to the image, and it can make your slides look a lot more professional. Here’s how to do that…
Using the Microsoft Stream web part in SharePoint Online
It’s one thing to have Microsoft Stream as your video portal for all your video content in the organization. However, if you’re using SharePoint Online, you might well want to embed a Stream video (or channel!) directly onto your page. You can do that with a Stream web part, and here’s how that works…
Getting your Microsoft Stream video content on your mobile device
I am a big fan of Microsoft Stream in Office 365. It’s a great way to share the video content in your environment in a managed and intuitive way. And now, it’s even better in that you can use the Microsoft Stream mobile application to watch your video content on the go! Here’s how that works…