Learning new Microsoft Office tricks in "just a minute"
This tip is the result of someone asking me yesterday whether they could edit a transcript once a video had been uploaded to Microsoft Stream. My initial thought was either “no” or “you can upload your own”, but then I hit the interwebs for some research. Much to my surprise, you *can* edit a video transcript, and it’s pretty easy!
This was a simple little thing I saw Sandra Mahan do during a Teams meeting yesterday, but it had completely skipped my notice earlier. When you’re in a Teams Channel tab (other than Conversation), you can expand the screen to remove all the Teams information on the left side of your screen. There’s an Expand Tab icon that does that for you. Here’s how it works.
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…
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…
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…
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…
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…
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…
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…
One Minute Office Magic 