Productivity 201: Dealing with Damaged Files

They say March Madness is the great workplace productivity killer. There’s a worse one: corrupted files. Often, when our callers reach us, they are just about to begin the onerous task of recreating damaged files from scratch. To that we say: “Hold on a minute!”

Here are some of the methods our tech support folks recommend before you retype:

They say March Madness is the great workplace productivity killer. There’s a worse one: corrupted files.

Using Open and Repair in Excel (2002, 2003, 2007, 2010)

If you open a file and notice something is amiss, or you simply cannot open the file at all, there might be a problem with the structure of the file itself. This is known as “corruption.” It is a generic term used to describe files that are no longer working correctly. If you think your file is shot, give the Open and Repair utility a try. It might save you from having to recreate the entire file.

Starting the process is slightly different depending on your version of Excel. [Read more...]

From Here to Productivity: Hyperlinking How-To

Hyperlinks make the world go ’round. They get us where we’re going more quickly and they help us present information in less time. Here are a few linking tips from our tech support consultants. Enjoy!

4 top tips for adding hyperlinks.

Creating a Hyperlink to Another Presentation or Web Page (Microsoft PowerPoint 2003, 2007, 2010)

During a slide show, you may find you need to either launch another presentation or access a web page. Here’s how you do it:

PowerPoint 2003 and older:

  1. In your presentation, click an object or text that you want to use as the jumping off point or shortcut.
  2. Click on the Insert menu and choose Hyperlink, or press Ctrl+K.
  3. Enter the Web address or path and filename.
  4. Click OK. [Read more...]

All About the iPad: Tips & Tricks

Although I truly cherish the Martha Stewart Makes Cookies app for iPad, it’s not quite up there on the list of top apps for business productivity. If you are using your iPad for work, you are more likely to need software like Keynote and Pages. The Tips and trickskey to using these apps is knowing how to get your documents from Point A to Point B; that is, from iPad to main computer or vice versa.

Here are some tips:

Export Keynote for iPad presentations to your Mac or PC

  1. Connect your iPad to your PC or Mac. In iTunes, select your iPad from the Devices list.
  2. Select the Apps tab from your iPad Settings window.
  3. Scroll down to the File Sharing section. Select Keynote from the apps list. You will now see a list of all the Keynote presentations on your iPad. Select the one you want to transfer to your computer, and click the Save To button.
  4. Browse to the folder on your hard drive where you want to save the presentation. Select it and then click the Choose button.
  5. Your file will be copied.

Import presentations to Keynote on iPad

  1. Connect your iPad to your PC or Mac. In iTunes, select your iPad from the Devices list.
  2. Select the Apps tab from your iPad Settings window.
  3. Scroll down to the File Sharing section, and select Keynote from apps list. In the Keynote Documents section you’ll see a list of presentations available in Keynote on the iPad.
  4. Select the Add button.
  5. Navigate to the presentation you want to copy to your iPad to edit or view in Keynote for the iPad. Keep in mind that with Keynote for iPad, you can edit only Keynote 2009 or PowerPoint presentations.
  6. Select your file and click Choose.
  7. Your presentation will now appear in the Keynote Documents section.
  8. Launch Keynote on your iPad and tap the icon that looks like a down-pointing arrow and a square bracket (it should be at the bottom of the screen in the center). Choose “Copy from iTunes.”
  9. Select the PowerPoint presentation you just uploaded to your iPad.
  10. Keynote will now import your uploaded presentation.
  11. Depending on the presentation, you may get a warning about incompatible fonts or other features that will slightly change the look of the presentation. Click “Done” to get past the screen, and check your presentation to be sure.

Import documents to Pages on iPad [Read more...]

An iPad Experiment

Christmas came early for me — in the form of an iPad, which I get to play with for two weeks thanks to my employer. It’s not all playtime; the whole point of borrowing it from my employer is so I can learn how to use it and thus offer tech support for it. I’ve had worse assignments.

I’m accustomed to a full keyboard, and my ham hands haven’t worked well with the touch keyboard.

A revolution for business?I was giddy when I heard I was getting my mitts on it. I’ve resisted buying one, convincing myself that throwing down $500 to $800 for something just because it’s “neat” is not reason enough. I’m not in the sales or medical fields, either. My jobs — tech support and writing — do not require that I own one, but I suspect I will soon find reason enough to.

With this is mind, I begin my experiment. I’m taking a week-long trip (for pleasure, not business) and I am leaving the laptop at home and instead conducting all my work-that-I-shouldn’t-be-doing-while-vacationing solely on the iPad. [Read more...]