Announcements

FREE After Rebates! Norton System Works 2002!!

WOW!

You read that right! We have Norton System Works 2002 for $44.97 and it has a $14.97 instant internet rebate plus a $30.00 mail in rebate (see site for rebate details)! So, between the two rebates, your cost is, well, nothing! Easily one of the best deals we've ever had!

With that nasty Bugbear virus on the loose, now's the time to get in on this deal!

Here's what's included:

# 1 Norton Anti Virus- OK, if you've been on this newsletter for more than a week, you already know I like this one. I personally think this is one of the best AV software programs on the market. It's quick, easy to use, and runs transparently in the background, always protecting you. Plus the updates are automatic, so you're always safe.

It protects you from all types of viruses, checks outgoing e-mail for viruses (to protect your friends), stops malicious internet code / scripts, and tons more. It really is the AV program by which all other AV programs are judged!

# 2 Norton Utilities - Here's one we use all the time help speed up our computers (the defrag program is great). It finds and fixes problems, keeps your data safe from most hardware / software problems, keeps an eye on your hard drive, has its own scan disk and defrag programs (much more advanced than the stuff included with Windows), and can even fix most of the problems it finds - quickly and easily.

It addition, it can also help you recover deleted files, help optimize your PC for better performance, plus give you detailed information about your system. And more! We use this program all the time here at WorldStart!

# 3 Norton Clean Sweep - Have too much junk on your hard drive? This software can help you remove unwanted programs (better than the Windows Add / Remove program thing), clean up internet temp files (cookies, excess plug-ins, temp files, etc), compress seldom used programs so they don't eat up a bunch of hard drive space, help you copy a program from one computer to another, and TONS more.

#4 - GoBack - Provides quick and easy system recovery. GoBack gives you the power to immediately undo common user errors and serious system problems on your PC. If you've ever messed up in a big way with your computer, this is for you. It lets you go back in time and retrieve lost data, unfreeze your computer when the system unexpectedly quits, or recover from a nasty computer viruses.

Again, this is FREE after rebates (again, please see site for details), and US Shipping is also FREE! So, it's a deal you do not want to miss out on. However, I'd strongly suggest you get to the site ASAP if you want in on this one.

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

PS - Don't miss out! Isn't keeping your computer running at its best worth grabbing this? And hey, you can't beat the price!

MS Office 101

Here's another cool tip for you keyboard enthusiasts - and I know you're out there!

Most people use the drop down menu to select a font size. It's quick and easy, but for those of you who hate the mouse and love the keyboard, did you know that you can change font size with a few keystrokes?

Well, you can and here's the combinations you're looking for:

• Ctrl + Shift + > will increase font size.
• Ctrl + Shift + < will decrease font size.

And for those of you who are new to the world of Microsoft, remember, you can highlight text by holding down the Shift key and using the arrow keys to move the cursor to the end of the section you want to highlight. Then you can...

• Ctrl + B will bold text.
• Ctrl + U will underline text.
• Ctrl + I will italicize.

Put all of this together and you've got some pretty easy text formatting at your fingertips! Literally!

Office Tip of the Day

For the last couple of issues, we've dealt with MS Word and the ability to view and simultaneously work in several files at once.

Now I'd like to take some time to address these ideas in MS Excel.

Splitting Windows in Excel: Same File, 2 Panes

First of all, you can split a file in Excel so that you can work in two places of the same file simultaneously.

To split into two panes, either select a cell in column A or a cell in row 1 and then go to the Window menu, choose the Split choice. (Or no matter which cell is currently selected, you can grab and drag down into the worksheet the little splitter bar located above the vertical scrolling bar.)

The file will split into two panes (horizontal if in column A and vertical if in row 1) and you're on your way.

By clicking into either of the panes you will be allowed to copy/paste, edit or whatever in four different locations of the same file.

If you choose a cell not in column A or row 1, you will get 4 panes of the same file. Sounds great doesn't it?

It does, I know, but when I tested the navigation in the 4 pane split, I found that moving the cell selection in one pane it actually adjusted the location in two panes simultaneously. So, this method really doesn't give 4 different sections of the file, only 2.

Anyway, two views of the file are still extremely useful. Just think, you can accomplish your editing without the hassle of the endless scrolling back and forth among the rows and columns. This can truly be a miracle in those ever-growing monster sized files.

To remove the split, simply go back to the Window menu and choose Remove Split from the list.

Splitting Windows in Excel: Different Files, 2 Panes

Next, we'll look at doing the same thing yet with two (or more) different files!

Open the files on which you are working. Keep in mind, the more files open, the smaller the viewing space in each file. So open only what you need and close the rest.

Then go to the Window menu and choose Arrange from the list. A small window will pop up allowing you to choose how the files should be arranged on the screen.

• Vertical will put them side by side.
• Horizontal will put them one on top of the other.
• Tiled will put them in a block of four (one in each corner, like playing a game of four square).
• Cascade will layer the files one on top of each other (not really the point of this discussion).

It's all a matter of personal preference. Make a decision and click OK.

You should have all the files fitted perfectly into the screen. Now you're ready to work from file to file very quickly without the annoying window changing.

To remove this window arrangement, simply maximize one of the files either by Ctrl+F10 or clicking on the maximize button (the squares to the right of the X for closing a file).

An Excel Bonus:

Did you know it is possible to set Excel to open the set of files and place them in the arrangement you chose?

Yep, it is!

Simply open the needed files and arrange the windows.

Then go to the File menu and choose the Save Workspace choice.

Like usual, a Save window will come up where you can name your workspace. (Notice that in the Type Of File box, it says Workspaces instead of Microsoft Excel Workbook. This is what makes it different from saving a workbook. Now it saves the group of workbooks as a workspace.)

Now, the next time you need to work on that particular set of files simply open the workspace you created. Excel will automatically open all files and arrange them as you had them at the time of the last workspace save.

Never fear though! You can still edit the files separately. This just allows you to open and arrange multiple files with only one open.

Talk about a time saver! If only I could arrange the workspaces of my school children so quickly...

~ April