Microsoft Office 2007

My last tech tip for your legal nurse consulting business was to clean it up, and my recommendation was to blow it out – your keyboard and air vents, that is. Today we’ll look at some different aspects of cleaning up for your CLNC^® business. This time it’s your data, not your dust.

Every document, PowerPoint^® presentation and photograph you create or edit personally or as a Certified Legal Nurse Consultant contains what is known as “metadata.” Metadata, or hidden data in Microsoft^®-speak, may include information about the file in which the metadata is included – in other words it’s data about data and may contain information about the quality, creator and/or characteristics of the data it’s contained in. Try this: open Word, click “Open” like you’re opening a file. Then single left click on any file followed by a single right click. In the menu that pops up scroll to the bottom and left click “Properties.” That shows you the underlying metadata telling you when the file was created, edited, who authored the document and when the file was last accessed.

Let’s say you use a legal nurse consulting file template created by someone else to create a document. Are you the author? Not according to the metadata. The author, should we look into the document properties, is the person who created the template – not you. Wouldn’t it be embarrassing if an attorney-client asked you who really wrote your report and someone else’s name showed in the Properties as author?

There are ways to avoid this. If you’re using Office 2007 you can inspect the metadata included in any document, clear it out and edit in the “correct” information (or you can choose to delete it). Simply open a Word document. Click the “Office Button” in the upper left corner then click “Properties” to see the simplest metadata. You can edit this to include your correct information. If you really want to get advanced, click “Document Properties” above the display of properties to see all the editable types of metadata you can store on a document. Another way to see the metadata is to close the document, navigate to the document in your Windows^® Explorer (not Internet Explorer^®) then right click on the document and left click on “Properties.” Now, left click on “Summary” in the “Properties” tab and then, click on “Advanced.”

Microsoft, in its infinite wisdom, has also given us a couple of ways to remove the metadata when you finalize a document. If you’re using Vista, it allows you to do it simply by bringing up the Properties box and the metadata can be cleared from there. In Office 2007, to clear out the metadata, open the Word document you wish to take to the cleaner. Click the “Office Button,” click “Prepare,” then click “Inspect Document” (if it asks you to save the document, do so) then click “Inspect.” The results box will show the different types of information stored in your document. You can then click the “Remove All” button by each type of information to remove that info. Reinspect the document and you’re ready to send it – without the metadata.

Almost every Microsoft Office 2007 document, PowerPoint and Excel document can be purged in this manner. If you’re using Office 2003/XP, there is a plug-in available from Microsoft to remove metadata just like Office 2007.

Beside Word documents, CLNC^® consultants routinely send out contracts as Adobe^® PDF documents rather than Word documents so as to be sure that the party receiving them cannot edit them. Adobe PDF documents also contain metadata that can be removed or edited prior to sending. Simply open the document with Acrobat, click File, then click “Properties” and you can edit the data. You’ll need Adobe Acrobat^® 8.0 or higher to do this (or a third-party application).

If you’re not scared enough by your legal nurse consulting documents, wait until you see what’s hidden in your digital photos! Try this. Open Windows Explorer and navigate to any photo stored on your hard drive. Right click on the photo to select it and in the menu that pops up, scroll to the bottom and left click “Properties.” Now, left click “Summary” in the “Properties” tab and then, here it is, left click “Advanced.” You may see the date the photo was taken, the type of camera, whether a flash was used and more information. Some of the newer digital cameras can even add GPS data to tell where a photo was taken. Think about that next time you snap a vacation pic – if you like the spot you can always use your GPS to navigate back to the exact spot the photo was taken (and so can anyone who you share that photo with via email or on the Internet).

Luckily there’s a simple application named JPEG & PNG Stripper that you can download and install on your computer. It does exactly what its name implies and strips the metadata from your photos. This is mandatory before posting them on the Internet or sharing them with friends/family (because they can be shared ad infinitum).

Metadata isn’t as persistent as you’d think but if you’re not aware of it you may be giving away more information than you wish to when you give away your documents and photos. Time to take steps to stop the sharing.

Keep on techin’,

Tom

If you’ve moved to Microsoft^® Office 2007 with its suite of upgrades, enhancements and head-banging, you’ve probably noticed the so-called “Ribbon.” This replaced all the good, old-fashioned, easy-to-use command buttons in Office 2003. I’ve been using this suite for about 10 months now and still misplace commands and I never remember where the darn “advanced options” can be found. If a techie is flummoxed, what’s a legal nurse consultant to do?

Well, fire up your favorite web browser and head on over to Microsoft’s excellent Get Started web page and check out the tutorials created for people just like us. Trust me – when it comes to software, you’re more like me than I am myself.

Look at Basic Ribbon Training. It will help you track down the commands that you can’t or won’t find on the new Ribbon. These are two terrific links and I keep them both bookmarked in my IE7 browser. I usually use the Firefox browser but found that for some strange reason Microsoft’s websites work best when using the Microsoft IE browser (something funny about that).

While I’m on the topic of Word 2007, do you ever use the little (?) help symbol up in the top right hand corner of your Office 2007 programs? This replaced the “Help” button and the “Type a question for help” box that was found in Word and some of the other Office 2003 programs. It’s a pretty good tool, but as many times as I’ve used this to search for a solution, I don’t always find what I want right away.

Here’s an example. When I insert a headshot of Vickie into a Word 2007 document, all I see is an empty box (in Windows-speak a “placeholder”) – not the photo.

Now, I’d really like to see this photo of Vickie so I can figure out how to wrap the text around it to make best use of the space on the page. When all I see is an empty box, it’s not much help. I can’t use any of the cool feathering tools, etc. on this darn box.

So I did an online search by typing in “I can’t see my inserted photos in Word 2007″ and I got some good leads, one of which told me to “Open the advanced tab under Images and un-click show placeholders.” The perfect answer right? Except in 2007 there is no “advanced tab” under the Image tab!

Giving up on that, I decided to use the built-in Windows help function. I clicked the little (?) and typed “show placeholders.” I got nothing. I typed “view placeholders” – got nothing, typed “view images” – got nothing. I finally remembered the Windows bar doesn’t say “images,” it says “pictures.” I typed “show picture placeholders” and I got the answer to “Go into advanced options and remove the checkmark for ‘view picture placeholders.’” Gadzooks! That’s the answer. Now all I need to do is find the “advanced options” and I can fix my problem. It’s simple. Click “tools,” click “options” and darn. There are no “tools” or “options” in Word 2007. So it’s back to the online “Basic Ribbon Training” page to use the Find Word 2003 commands in Word 2007 link to find my “options” and “advanced options” (they’re at the bottom of the Ribbon under “Word Options”). Now I see how to play with my inserted headshot of Vickie (not image of Vickie, duh!).

You can download a free “Get Started” tab from Microsoft that you can install right onto the tool bar of your Office 2007 versions of Word, PowerPoint and Excel. When you encounter a bump in the road or can’t find a command simply click the “Get Started” tab and you’re on your way!

The moral of this story isn’t to buy a Mac^® for your legal nurse consulting business – it’s if you’re searching for something in the Windows Help function, you should use Windows-speak to find it. The more you use the language of the software the more likely you will be to actually find a useful help answer! Something cool about the new online help function is that people can comment and add answers that truly help other people like me who are challenged by help.

So, like I said in the title – don’t be afraid to ask for help, just be careful how you do it.

Keep on techin’,

Tom

P.S. Please comment on your wild experiences riding the Ribbon.