Podcast: Play in new window | Download
Welcome back to the podcast!
This week’s edition…
“Out with the Old and in with the New”: Using Find and Replacê in Microsoft Office
I’m a bit of a digital packrat. I keep everything. Not only do I keep stuff, I also have multiple back-ups of the documents I have saved.
I suspect I am not unique, either. Recently, I was talking with a colleague and she admitted that she keeps everything too – but she never goes back to use it again. She said she makes backups so she has “just-in-case” copies, but readily admits that she creates the same documents over and over again from scratch.
When I hear her complaining about how she cannot remember how she worked around a particular glitch, I ask her the same question: “Why didn’t you just copy the old one and change it?” Her reply: “It’s too much work.”
It may seem like too much work, but repurposing content is an age-old practice. For example:
Did they cancel “Bewitched” when the first Darren didn’t work out? No, they just found another Darren
And then there’s Shakespeare. Why create new content when you can just replacê Romeo and Juliet with Maria and Tony and call it “West Side Story”?
Make your life easier; use Find and Replacê.
Almost every Microsoft Office program enables you to Find and Replacê, even the basic text editor Notepad.
In this week’s podcast, we offer Find and Replacê tips for a gaggle of Office apps. Among them:
- Change is Not Always Hard: Using Find and Replacê in Microsoft Excel
- Presto-Chango: Using Find and Replacê in Microsoft Word
- Go Green with PowerPoint: Recycle slides using Find and Replacê in Microsoft PowerPoint
- Adding can be Maddening: Using paste special to alter numbers in a worksheet
- Up to Date: Using update queries in Microsoft Access to update values in a table
That’s it for this week’s podcast. Until next week, and keep this in mind: It’s OK to reuse files, but not OK to reuse tissues.
You can find all of our tips on our blog at www.productiveUpodcast.com. Hate us? Love us? Have a suggestion? Tell us in an iTunes review. We would love to hear what you have to say.
See you next time!
Music courtesy of Clayton & Fulcrum
