The Back-Up Plan

Clients often ask me this question. My somewhat cynical answer is “Often enough not to commit suicide when your hard drive crashes.” Because we know that someday that hard drive will crash!

Amount of Data Input

If I’m sitting at my desk entering client data for 8 hours a day, I want to back up hourly.

If I’m occasionally using my computer for a client proposal or letter, daily will be enough.

Difficulty in Re-creating the Data

If I lost my bank reconciliation for one month, it would be easy to re-do that work. Not pleasant, but easy.

If I lost a BIM file, CAD drawing or project management file, it would hard to re-create the work. Lots of time to duplicate the work. Double payroll. Deadline delays.

If I lost a design concept, it would be impossible to re-create the file.

Importance of the Data

If I’m audited, I need my accounting records have to be available for seven years.

If I need to re-construct events, emails documenting a project can be invaluable in case of legal action, etc.

So based on the above questions, you need to decide how often to back up.

Multiple Backup Copies

The more important the data, the more copies of the back up you want to have and the farther apart the copies should be. Don’t have one CD of your critical files! For example, my client data is my business. So I have a copy in my office in case I need to go back a couple of years to retrieve a brochure that a client wants updated.  I have a second copy in my car. If the office burns down, the car would probably survive since I have detached parking. Then I have a third copy online.

Online Backup Services

I love online backups. They automatically happen on a set schedule. Heaven knows we don’t want to rely on my memory!! I get an email if something goes wrong with the backup. I can access the files from any computer in case I need something when I’m at a client’s office. Some services even allow file sharing to eliminate the need for a separate storage account to share with collaborators.

Features between online companies vary greatly. Email me if you would like a copy of my comparison chart. 

Some services charge by user by file size. Others charge just by file size. So an architectural firm with huge BIM and CAD files would want to shop for the best file size provider. A one person resume firm would do better with a per user account.

Time and Stress Tips

Set up your files so that EVERYTHING goes into My Documents: your QuickBooks file, Microsoft Office files, photos, … EVERYTHING.  Then when you back up either to a DVD or to your online service, all you have to do is back up My Documents. You don’t have to wander all over the hard drive to spot different files. This will also save you a lot of time finding your files!

Don’t place files on your Desktop.  Put the file in My Documents. Then put a short cut on the desktop. Your files are safe in the back up set but you have quick access!

Outlook pst files can cause a problem with online backup if you use a service that backs up the entire file every time instead of doing an incremental backup.  In other words, if you add a 2 KB email to your Outlook file, an incremental service will back up just the new 2 KB email.  A total file replacement could be 4 GB or more depending on your version of Outlook and set up.

Online Backup Services

            iDrive.com

            Mozy.com

            Carbonite.com

            SOSonlinebackup.com

            Securusvault.com

Written by:  Pamela Bir, Your Computer Lady

As published in Sources+Design Magazine June/July 2011 Issue

12 Tips for Creating Better PowerPoint Presentations

Ever wonder how to create a good PowerPoint presentation? Creating professional, unique PowerPoint presentations with the latest version of Microsoft Office is much easier than you think. This article will help you find the tools to create exactly the presentation you want.

Click here to continue reading this great article from Microsoft at Work.  

Try Not To Do This

Excellent article about writing subject lines for your emails! This is an area where I certainly fall down. Maybe you do too in the rush of getting an email out. We write boring subject lines then complain that people didn't open our emails. 63% of readers say they open an email based on the subject line!

So read this article by Michael Katz of Blue Penquin Development and write some good subject lines!

Microsoft Word 2007 - Inserting Symbols and Special Characters

Sometimes you need to insert symbols or special characters into your Word 2007 document. Unfortunately, symbols and characters don't appear on your computer keyboard.

To insert a symbol or special character into your document, follow these steps:

1. Position the cursor where you would like to insert the symbol or character.
2. Click on Insert in the ribbon.
3. Click Symbol in the Symbol section.
4. If you don't see the symbol or character you'd like to insert, click More Symbols.
5. When you find your symbol or special character, click it and then click Insert.

Email and social media statistics

Interesting stats on the rise of email. Check out the historical facts at the bottom!

8 Tips for Successful Business Blogging

Good article for companies considering a blog or companies getting started with their blog.
8 Tips for Successful Business Blogging

Excel 2007 Shortcut and Function Keys

The following lists contain CTRL combination shortcut keys, function keys, and some other common shortcut keys, along with descriptions of their functionality.

Click here to see the full list of Excel shortcuts.  

Failure is a good thing!

Why I Hire People Who Fail
by Jeff Stibel


Jeffrey Stibel is Chairman and CEO of Dun & Bradstreet Credibility Corp. and author of Wired for Thought.

Keep Your Existing Clients

This article builds a good case for holding on to your existing clients. Email marketing is an effective tool for doing that!  "Hold on Loosely - But Don't Let Go"

An unusual version of the Hallelujah chorus

http://voxvocispublicus.homestead.com/Index.html

Nothing to do with computers or software but it's so clever!

Learn Common PC Hardware Terms

If you haven’t shopped for a computer for a while, the following list of terms used for common PC features and functionality can help you make sure you get everything you need in your new PC.

Click here to continue reading this article from Microsoft at Home.  

12 Days Of Christmas: Cost Of Song's Many Gifts Tops $100,000

The price of partridges, pear trees and turtle doves has spiked, pushing the cost of every item mentioned in the carol "The Twelve Days of Christmas" above $100,000 for the first time.

Click here to read the full article.

Microsoft Word 2007 - Changing Font Case

Have you ever started typing and realize you had CAP LOCKS on?  You could retype the text, but that is time consuming. Fortunately, there is an easier way to change the font case in Word 2007.

Follow these steps:

1. Select the text you’d like to change
2. Click the Change Case button in the Font section of the Home ribbon (the button has an upper case and lower case A)
3. Choose either sentence case, lowercase, uppercase, capitalize each word or toggle case

Microsoft Excel 2007: Text-To-Speech Commands

Did you know that Excel can read back to you?  I used this recently to help me double check data entry work that I did.  It was great and it saved me a lot of time.

1. Next to the Quick Access Toolbar, click Customize Quick Access Toolbar
2. Scroll down, and click the Speak Cells commands, and then click Add.
3. Click OK.

When you want to use a text-to-speech command, click on it in the Quick Access Toolbar.

To play back a group of cells:

1. Select a group of cells to read back.
2. Choose how the computer will read back your data by clicking By Rows or By Columns.
3. Click Speak Cells
4. To correct an error, click Stop Speaking and use your mouse and keyboard to make the necessary changes.
5. Click Speak Cells to make the computer continue to read back your selection.

You can select a specific range of cells for the computer to read back to you, or you can click Speak Cells Button image without selecting any cells and Excel will automatically expand the selection to include the neighboring cells that contain values.

Try it!

How to Back up Files and Recover Data

Even computer novices know that file backups are important in case of hard drive crashes, but many people wonder exactly how to back up files and how to recover data. This article covers the Backup and Restore feature in Windows 7 and in Windows Vista, which can help save you a lot of time and trouble. It also focuses on how to back up Microsoft Outlook files and how to back up files in the cloud. All of these tools and processes can all help with data recovery in the event that something happens to your computer.

Click here to read the full article on Microsoft at Home.