Prevent Links From Breaking

I have a secure upload site, and often send the link to my clients, so they can upload a large file for me to work on. Because the address is long, the link sometimes wraps in the email, and doesn't work when the recipient clicks on it.
To prevent this problem, you can use a link compression site, such as http://tinyurl.com or my new favourite, http://is.gd (Now I only have to type 4 letters, instead of 10!)

  1. Copy the long address, by using the keyboard shortcut Ctrl + C
  2. Go to the link compression site, and follow the instructions.
  3. Copy the short address, and paste it into your email.


Note: These shorter addresses are also handy if you're using Twitter, which has a 140 character limit.

What's Your Response Time?

How do you get any work done when the phone keeps ringing and the email alert dings every few minutes?
When I'm in the middle of an Excel programming project, I need to concentrate, or I lose time and momentum. To help reduce the distractions I turn off the email alerts and unplug the phone, then focus on the project for a few uninterrupted hours. It's amazing how much I can get done!
My clients know that I'm frequently unavailable, either out at meetings, or working away from the phone. If they leave a message or send an email, I'll respond within 24 hours. On those rare occasions that I'm away for a few days, I warn my clients in advance, and my voice mail gives my return date, so people know when to expect a reply.
In Take Back Your Life, Sally McGhee suggests adding a response time to your voice mail and your email signature.  You'll get more done because you can focus on your work, then respond to phone calls and emails once or twice during the day.

Even Word Has a Calculator

Yesterday I mentioned the Windows Calculator and Google Calculator. Did you know that Word has a calculator too? To use it, you can add a button to a Word toolbar, then select numbers, and click the Calculator button, to see the total.

To add the button to a Word toolbar:

  1. In Word, click the Tools menu, and click on Customize
  2. Click the Commands tab, and click the Tools category.
  3. Scroll down the list of commands, to find Tools Calculate
  4. Drag that button to one of your Word toolbars.
  5. To show a picture, instead of the text, right-click on the button in the toolbar
  6. Click on Default Style
  7. Right-click on the button again, and click on Change Button Image
  8. Click on the Calculator icon.
  9. Close the Customize dialog box

To use the Calculator button:

  1. Select a column or list of numbers in Word, or type and select a formula, such as 19*10/14.
  2. Click on the Calculator button.
  3. Look in the Status Bar, at the bottom left of the Word window, to see the result . The total is also automatically copied to the clipboard, so you can paste it in Word, or somewhere else.

Calculator at Your Fingertips

Most of the time I do my calculations in Excel, but occasionally I reach for a calculator instead -- and it's never where I left it. Fortunately, my keyboard has a button that launches the Windows calculator, so I can do quick calculations there.
The Calculator key is at the top of the keyboard, just above the ScrLk key, buried under a layer of dust and crumbs.  Fairly well hidden, but it's nice to have.


Another way to do a quick calculation is in Google. Type a formula in the Search box, then click Google Search, or press the Enter key, to see the result.

Find Office Files with Keywords

When you save a Microsoft Office file, you can store keywords to help you find that file later. For example, when you're creating an estimate for a client's Excel project:

  1. In Excel, click on the File menu, and click on Properties
  2. On the Summary tab, enter Estimate, Excel in the Keywords box, then click OK.


Later, you can use one or more keywords to find relevant files:

  1. In Excel, click the Open button on the toolbar.
  2. At the top right of the Open dialog box, click the arrow on the Tools button
  3. Click Search
  4. In the Search dialog box, click the Advanced tab.
  5. From the first drop down, select Keywords
  6. Enter a keyword in the third box, and click Add
  7. Enter more keywords, or any other search criteria, including location.
  8. Click the Go button, to start the search.

Tidy Up Your Charts

If you've created several reports in an Excel workbook, you might want to line them up and make them all the same size before printing. Instead of doing this manually, you can download and install Jon Peltier's free Align Chart Dimensions utility. There are installation instructions on Jon's site. 
After you install the add-in, you can select specific charts, or let the utility align all the charts on the sheet. Check the options to align and resize the charts, then click OK, and your report is ready.

Repair an Excel File

If you're having problems with an Excel file, using the built in repair feature might fix the problem. This can help when data validation drop down arrows don't appear, or there are other signs of corruption.

  1. Close the file
  2. In Excel, choose File►Open
  3. Locate and select the file
  4. Click the arrow at the right of the Open button
  5. Click on Open and Repair
  6. When prompted, click the Repair button.


This might save the file, and if not, you can follow the same steps, but click Extract Data instead, to retrieve as much of the data as possible. And remember to make backup copies of your work!