April on Thu, 6 Mar 2003 11:14:01 +0100 (CET)


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

[Nettime-bold] MS Office Tips 03-06-2003 [ Outlook (and OE) Shortcuts + Cool Text Splitting in Excel ]


Title: MS Office Tips & Tricks

Useful Links

Message Board
Subscribe
Software Store
Computer Terms

Guides

Windows Shortcuts
Downloading
E-mail
Virus Guide
Digital Cameras
Emoticons :-)
Internet Errors
Software Install
File Sizes
Image Formats

Software Deals!

Check out our new bargain bin!
Click here now!


Master Cook Deluxe 6.2
15 Cookbooks with over 4,000 recipes!


Only $14.97!


Gizmos Mega-Pak
25 Ways to Improve your PC


Only $12.95!


Neato CD/DVD Labeler Kit w/ Applicator
Design-Print-Apply
Perfect Labels Every Time!


Only $18.97!


Dragon Naturally Speaking
Delivers high accuracy speech recognition - even on laptops!


Only $39.97!


Learning Microsoft Windows XP
Interactive learning


Only $12.97!


Pajama Sam's Sock Works
Awesome Kids Game!


Only $7.97


Business Cards
The easy way to make business cards!


Only $6.97!


American Heritage Talking Dictionary
A dictionary that "talks" to you!


Only $12.97!


Bartlett's Quotations
Over 22,000 searchable quotations


Only $6.97!


 

Announcements

I'm *Really* Excited About This One!

Oh, do we have an AWESOME title in!

It's Home Depot's Home Improvement 1-2-3 (plus a bonus :-) and it's very, very cool.

This interactive CD ROM guide has over 250 projects! It uses video, animation, narration, and photographs to help guide you though just about any home improvement project you can think of. With spring right around the corner, you know you'll be wanting this one!

It covers:

Plumbing Electrical Painting
Staining Cabinetry Walls
Countertops Ceilings Shelving
Floors Storage Exterior Maintenance
Weatherproofing Insulation Wallpapering
Planning / Design Doors Windows

And tons more!

Each project takes you step by step through the entire process. It's like having an expert right at your finger tips.

It works like this: Let's say you were going to install a new ceiling fan. You just go to the electrical section and select the Mounting Ceiling Fans project. From there, it takes you though the entire process—everything you need to know and then some—step by step. It has excellent illustrations and narration to help guide you through the process. It makes it so easy, even I could do it!

In addition, it also tells you what type of stuff you're going to need (tools, materials, aspirin, etc) and how long the project would take based on your skill level. It even has a "work smarter" section that give you the pros and cons of installing whatever it is you're going to install. Of course, it also includes safety information too—live to fix another day, right?

Heck, you can even print the project out and take it with you!!

This is the BEST home improvement CD ROM I've ever seen. If you do any do-it-yourself type projects, this is a must have. I still can't believe how impressed I am with it! I had a few projects I was hesitating about doing around the house, but thanks to this CD I was able to do them myself.

Now for the price. This retails for $39.95 and we normally give you a super deal at only $16.97, but right now it's on sale for only $12.97 with FREE US Shipping! That's our lowest price ever! This is a current title and works all versions of Windows.

I attracted a lot of attention in my office with all my "Oh, this is soooo cool", and "Wow, that's just great" type comments. In fact, everyone I've shown this to has wanted one!

If you've ever been involved with a project and got stumped, this CD would have come in handy. I can't begin to tell you how much time, money, and frustration it has saved me!

http://www.worldstart.com/store/homedepot.htm

PS - Don't miss out! Everyone I've shown this to has bought one! It's absolutely awesome and I can't recommend it highly enough. Remember, we have a 30 day satisfaction guarantee. If you don't like it - even after you try it - we'll take it back! You have nothing to lose!

Sorry for going on and on, but I can't remember the last time I was this excited about a piece of software :-)

Bonus! In addition to Home Depot's Home Improvement 123, we'll also throw in a program called 6100 Home Plans if you order now! Only while supplies last!

MS Office 101

Outlook & Outlook Express Keyboard Shortcuts


I thought it might be time for another keyboard shortcut installment for those users who really love learning a mouse-less way to accomplish their tasks.

Today I thought we'd focus on MS Outlook and Outlook Express.

Here's a few of the most common tasks and the keyboard shortcuts you need to get the job done ASAP.

  • Ctrl + N will create a new email.
  • Ctrl + M or F5 will send and receive mail.
  • Ctrl + Shift + B will open the address book.
  • Ctrl + R will reply to a message.
  • Ctrl + Shift + R will reply to all.
  • Ctrl + F will forward a message.
  • Ctrl + Shift + F will open the advanced find window.
  • Ctrl + Enter or Ctrl + Q will mark a message as read.
  • Ctrl + D or Delete Button will delete the currently selected message(s).
  • Esc will close the message currently open.


While this list is no where near exhaustive—it's certainly a good start.

Happy Emailing!

Office Tip of the Day

MS Excel Text Into Columns

Have you ever found yourself wondering what in the world possessed the person who created your MS Excel file to put both first and last name in the same cell?

Now how are you supposed to sort that list alphabetically by last name when first name is listed first?

The answer is that you can't—you have to separate the first and last names—somehow...

But how?

You could spend your time retyping the last name into the next column. It works but it's not a great plan since it could take "forever" if your list is really long.

Or... maybe you have other text / data that really should be separated into different cells for easy sorting and editing.

Would you like a fast way to separate the data? (This works best with data that's pretty consistent and not too complicated.)

Most of us would say "yes". (Even if you don't have an immediate use for this one, it's one of those handy little pieces of information that may just get you out of a jam one day. :-)

So let's get to that faster way...

The first thing you'll need to do is to highlight the data that needs to be separated.

Now go to the Data menu, Text into Columns choice.

A 3-step wizard will start to guide you through the process.

On step 1 check at the top that the data will be delimited.

Then click Next.

In step 2 you need to check the Space option in the Delimiters section. (Make sure all other choices are unchecked.) Basically what you're doing here is telling Excel what character separates your pieces of data—so that when it find a space it knows to stick the next piece of text in a new column.

Did you notice the preview of your data in the bottom window? See how the names are now divided into different columns?

Click Next.

Step 3 will allow you to do some formatting and placement of your data—but for now, as beginners, just click the Finish button.

Poof!

Just like magic your first and last names are in two separate columns, ready to sort - no retyping necessary.

(Ok—maybe not magic but, if your list was long, you'll feel like it was when you realize how much time you just saved.)

~ April

Copyright & Disclaimer

ISSN: 1529-336X
Copyright 2001, WorldStart. All unauthorized reproduction strictly prohibited.

You are welcome to reproduce this newsletter (i.e. print it, store it) for your own personal use. You are also welcome to forward it, in its entirety, to friends and family.

If you would like to reproduce this publication, or any part of it, in any other publication, be it web based or otherwise, you must contact us for permission. Any unauthorized re-distribution will be considered a copyright infringement and grounds
for a lawsuit.

Finally, you agree to try any advice contained or suggested in this newsletter at your own risk.

To remove yourself from this list, simply place a check next to the "Remove Me >From This List" checkbox then click the "Remove" button below. If that doesn't work, head to:

http://www.worldstart.com/newsletterunsub.htm

Remove Me From This List

If your e-mail address doesn't appear below, enter it and press the Remove button to unsubscribe.



You are currently subscribed as nettime-bold@nettime.org

 

 

_______________________________________________ Nettime-bold mailing list Nettime-bold@nettime.org http://amsterdam.nettime.org/cgi-bin/mailman/listinfo/nettime-bold