Free Backup Software

From June 2-8, the full version of NTI Shadow 3 backup software is available free. Regularly $29.99, this software makes backups as you work, so you can save important documents onto a removable drive, such as a thumb drive, for safekeeping.

The program has received fairly good reviews, with some complaints of slow copying, and it may need to be started manually if you restart your computer.

However, at this price you can afford to test it for yourself, and see if it meets your needs.

Move Quickly With Excel Shortcuts

In an Excel worksheet, you can use the keyboard navigation keys (Home, End, arrow keys) to move up down or sideways. There are mouse shortcuts too!

Keyboard Navigation Shortcuts

Here are a few keyboard shortcuts, to help you move through the worksheet cells, quickly:

  • Right ………. Tab
  • Start of worksheet …… Ctrl + Home
  • End of worksheet  …… Ctrl + End
  • Start of row ………. Home
  • Up/ down screen … Page Up/ Down

Work in Excel List

The following keyboard shortcuts help you make smaller movements through a range of cells on an Excel sheet:

  • Select current range …… Ctrl + *
  • Move to range border ……. Ctrl + arrow
  • Move down ………. Enter
  • Move up ………. Shift + Enter
  • Move right ………. Tab
  • Move left ………. Shift + Tab

Mouse Navigation Shortcuts

If you’re a mouse user, like I am, a quick way to navigate is to:

  • point to the border of the active cell
  • when the pointer changes to a 4-headed arrow, double-click.

That will take you to the end of the list in that direction, stopping just before the first blank cell.

point to the border of the active cell
point to the border of the active cell

More Excel Shortcuts

For more time-saving Excel shortcuts, go to the Microsoft Excel Shortcuts List page on my Contextures site.

Excel Keyboard Shortcuts - Number Format
Excel Keyboard Shortcuts – Number Format

Clean Up Your Browser Bookmarks

The free utility AM-Deadlink can find dead links and duplicates in your list of browser bookmarks.

I run it on my machine every couple of months, to clean things up and save me from wasting time in following dead links. You can download the utility here: AM-Deadlink

It’s easy to install and use, and takes only a couple of minutes to check my 1600 bookmarks. Then I sort the list by error number, and delete any 404 pages.

Effective Financial Reports

Although the book is out of print, the advice from the 3M Meeting Management Team, in How to Run Better Business Meetings, is still pertinent.

  • “The controller is the diagnostician who determines when and where the company is ill.
  • The manager is the surgeon who operates on that ailment.
  • The surgeons need a diagnosis, and not a course in anatomy. The simpler and more focused the [financial] presentation, the better.
  • The most creative job the financial presenter can do is select the meaningful data and present them in sharp focus.
  • This makes for shorter, more lively presentation, and does a better job of preparing the managers for their work as surgeons.”

Compare Shipping Costs

Don’t waste time comparing shipping rates at individual carrier sites. Enter your starting point and destination, and let ShipGooder calculate the rates for you.

This free service compares major courier and postal services, and local carriers.

You can also find US or Canadian postal codes, by address or city.

For example, if I want to ship one of my books to a client in Chicago, here are some of the rates available.

Move and Resize Windows With FreeSnap

As you work on your computer, you probably have several windows open most of the time. Even with multiple monitors, it can be difficult to arrange the windows so you can see the ones you need, and get the others out of the road temporarily.

FreeSnap is a free utility that lets you use keyboard shortcuts to control the windows’ size and position.

You can read about FreeSnap and download it at the Blue Onion Software site. It works with the Window key on the keyboard, and the number keypad and navigation keys.

One feature that I like is the shortcut to resize windows to a specific dimension, such as 800×600. This helps when I’m creating forms in Access or Excel, and want them to fit my client’s screen.

Open Folders Quickly

When saving or opening a file in Excel or Word, you might have to navigate through several layers of folders to find the one that you need.

To make it easier to open folders that you use frequently, add them to the My Places bar. To do this in Excel:

  1. Click the File menu, and click Save As
  2. Locate and select the folder that you want to add to My Places
  3. At the top right of the dialog box, click Tools
  4. Click Add to “My Places”

My Places

The folder will appear at the bottom of the My Places bar. To reposition it, right-click on the folder icon, and click Move Up.

For Excel 2000, you can download the Places COM add-in from the Microsoft web site, to customize the My Places bar.

List Your Project’s Next Steps

While working on a project, such as creating a database, or programming an Excel file, I make notes about the changes I’m making.

Before quitting for the day, I add a few notes on what steps should be taken next. For example, “Create a data entry form” or “Add project codes list”.

This makes it easier to get up and running the next time I resume work on the project.

If you use this technique, you won’t have to spend several minutes reviewing your work to figure out where you left off — your “Next Steps” notes will jog your memory. Well, most of the time!