Learning new Microsoft Office tricks in "just a minute"
On more than one occasion, I’ve been in the position of having some data stashed in an Excel spreadsheet, but I need to have it be part of a Word document. I could give my audience two files to see everything, but I really want to have everything in a single Word document… What to do?
Instead of just copying and pasting some cells from Excel into Word, I can use the Paste button dropdown to get some interesting options on how the data will show up in Word.
OneNote is a great tool for taking notes, storing information, and a million other things. A team OneNote notebook can do wonders for keeping everyone on the same page. However, there are times when some of the content in your OneNote notebook needs to be locked down for security and privacy purposes. This is where password-protecting a section in your OneNote notebook comes into play.
If you’re in a meeting and you want to have a record of what was said, you can use OneNote to make an audio recording and save it automatically to a OneNote page. In addition, you can also take notes that will automatically have pointers to that specific part of the recording. Here’s how it works…
There’s nothing more frustrating to see some interesting writing on a page, and you can’t copy it into a Word document as it’s actually part of an image (like an image caption). But with OneNote, you can use the built-in Optical Character Recognition (OCR) feature to get the text in the image turned back into real text you can copy and paste. Here’s how…
I think AutoCorrect in the different Office programs (such as Word, Excel, and PowerPoint) is a lifesaver when it comes to creating documents with no (or fewer) typos.
What you may not know is that you have the ability to do a lot of customization in AutoCorrect in order to make it work best for your particular situations.
One of the cool newer transition features in PowerPoint is the Morph transition. If you haven’t tried it out, you may want to think about it.
I tend to do a lot of clicking and dragging the cursor to select text in Word. But these two tips are very useful for saving time and effort when it comes to grabbing sentences and paragraphs.
There have been times when I’d like to borrow some content from YouTube to make a point in a presentation… or just to have some opening music before the show starts. This tip shows you how to accomplish that.
This tip is cool in that it 1) shows me something I didn’t know I could do, and 2) makes me think about different ways I could design a PowerPoint presentation. It’s possible to create hyperlinks in your PowerPoint presentation that point to other slides in the same deck.
One Minute Office Magic 