Archive for November, 2010

Microsoft Excel Tip: Activate Cell

Saturday, November 27th, 2010

To edit the active cell, hit F2. It’s much faster than double-clicking on it.

Microsoft Word Tip: Ctrl-Z

Saturday, November 27th, 2010

Make a mistake? Instead of pulling down the Edit menu to hit “undo,” simply hit Ctrl-Z. This shortcut works in other programs as well.

Internet Tip: Homepage

Friday, November 26th, 2010

Get to your homepage quickly. Hit Alt-Home.

Window Tip: Web Forms

Friday, November 26th, 2010

When filling out Web forms, don’t use the mouse to click in each blank. Hit the TAB key instead. Shift-TAB will move you in the opposite direction.

Online Diversion: Escape the Room

Thursday, November 25th, 2010

You are trapped in a room.  Using your mouse, you must figure out how to escape.  You have no instructions.  These ingenious puzzles will keep you occupied for hours!

If you truly get stumped, you can click on a “walkthrough” for the answer.  Pay attention to the details.  Mouse over the screen looking for clickable items.  Sometimes you can “pick up” objects that can be used elsewhere.

I won’t tell you anymore.  Begin your “quest for the exit” at Submachines!

Site of the Week: Custom Guide

Thursday, November 25th, 2010

Who doesn’t love cheat-sheets?  Today’s software is full of features many of us would never learn to use. My site of the week offers two-page quick reference guides you can keep by your computer. They even let you download some samples.  Check out their free PDF guides for ExcelOfficeOutlookPowerPoint, and Word.  To see their full catalog, visit their site.

5 Keys to a Perfect Web Address

Wednesday, November 24th, 2010

Did you pick a good web address?  Are you stumped trying to come up with a good “.com” address for your company?  I help customers every day come up with domain names for their websites and email addresses (A domain name is the “something.com” or something.org” a company uses).  Here are the basic rules I follow:

1. A domain name must be easy to tell someone over the phone without spelling it. I would rather have a long domain name that was easy to remember versus a short abbreviation that I have to constantly spell out.

2. Your domain name doesn’t necessarily need to be based on your company name. While you may have worked hard to brand your name, consider choosing a domain name that communicates what you do.  A name like ChicagoPlumber.com will benefit you more in Google than HarrysPlumbing.com.

3. Buy aliases for easily misspelled domain names. My website is the perfect example of the need for domain aliases.  Most people don’t know that my last name has two n’s.  So, when I tell people to visit my site, EricSpellmann.com, most people forget the second “n.”  I registered EricSpellman.com and pointed it at the same site!  Roughly one-third of the people visiting my site enter the misspelling of my name!

4. Avoid hyphens at all costs. No one remembers the dash. You may have chosen a domain name with a hyphen in it because your competition already grabbed your preferred address.  However, you will discover that you have to verbally remind people to enter the dash when typing in your site.  In fact, a large number of your clients will end up forgetting the hyphen and going to your competitor!  You cannot let that happen.

5. Write it out before you choose it.
Some people choose domain names without checking out how they look.  Why is that important?  Well, I once had a client that wanted to register a domain for a website called Lawyers Exchange.  I told them to pick a different domain name.  They didn’t understand until they wrote out the address: lawyersexchange.com.

The Business Case for an Apple iPad

Wednesday, November 24th, 2010

You know you want one.  In fact, some of your colleagues are already sporting them at meetings.  The iPad has turned into the must-have device for the workplace.  But how do you justify the expense?  After all, you can easily end up spending up to $1000 before it is all said and done.

The key is to understand what the iPad DOES and DOESN’T.  First, the iPad handles e-mail incredibly.  The large screen makes reading messages effortless.  I can churn through my inbox much faster on my iPad than on my iPhone.  The screen also allows me to view web pages very easily, which comes in handy during meetings.

Let me give you an example: During a typical meeting with a client, I have their records pulled up on my iPad, giving me everything I need in one place.  If they ask a question, I can have their answer in just a few “finger-swipes.”  This ability alone has improved our customer experience tremendously.

I bought the version of the iPad with 3G.  That means, using the AT&T network, I can access the Internet anywhere my iPhone can. This feature has allowed me to easily work off-site, including customer sites.  But you have to weigh the pro’s and con’s. The iPad is large enough to serve as a sales and training platform in a one-on-one situation.  And with the additional adapter, I can use my iPad to project my presentations at large conferences.

Basically, the iPad has replaced my laptop.  And the “instant-on” ability means I can be ready to go in seconds instead of waiting for my laptop to boot

By downloading various apps, I have also discovered other uses for the iPad: Dragon Dictation allows me to “speak” my meeting notes into the iPad.  My speech is turned into text that can be easily copied to our Customer tracking systems.

The primary limitations of the iPad revolve around the keyboard.  If you enter a lot of text, you may want to buy the Apple wireless keyboard.

I could go on and on, but space limits me.  To learn more about the Apple iPad, check out these videos.

Microsoft Excel Tip: Gridlines

Tuesday, November 23rd, 2010

Need to see the gridlines on a printed copy of your spreadsheet? Don’t draw borders. Just pull down the File menu, choose “Page Setup,” click the “Sheet” tab, and check “Gridlines” under the Print heading.  In Excel 2007, click Page Layout, and check the Print Box under Gridlines.

Microsoft Word Tip: Paste Special

Tuesday, November 23rd, 2010

When copying and pasting text, I usually choose “Paste Special” from the Edit menu (instead of plain old “paste”) and then choose “Unformatted text.” That way, the new text inherits the formating of the text around it. Less cleanup!