- Shopping Bag ( 0 items )
You're a smart person who wants to stay ahead in the corporate world. You know that using Office 97 is what you need to do-but that could mean struggling through piles of technical manuals! Push aside those overweight books! The Complete Idiot's Guide to Microsoft(R) Office 97, Second Edition feeds you a low-fat diet of Office 97 that's easy to swallow and easy to digest. Its lighthearted approach is perfect for new and experienced users who need to quickly take advantage of the best that Office 97 has to offer. ...
You're a smart person who wants to stay ahead in the corporate world. You know that using Office 97 is what you need to do-but that could mean struggling through piles of technical manuals! Push aside those overweight books! The Complete Idiot's Guide to Microsoft(R) Office 97, Second Edition feeds you a low-fat diet of Office 97 that's easy to swallow and easy to digest. Its lighthearted approach is perfect for new and experienced users who need to quickly take advantage of the best that Office 97 has to offer. So bypass fat, heavy books! Learning to be productive and efficient in Office will be a breeze.
|Pt. 1||Microsoft Office Over Easy||1|
|1||10-Minute Guide to Office 97 Professional||3|
|2||When in Doubt, Ask for Help||15|
|Pt. 2||Whipping Up Word Documents||25|
|3||Making and Editing Word Documents||27|
|4||Giving Your Text a Makeover||41|
|5||Newsletters R Us: Working with Columns and Tables||55|
|6||Spicing It Up with Graphics, Sound, and Video||71|
|7||Checking Your Spelling and Grammar||85|
|8||Creating Mailing Labels and Form Letters||95|
|9||Working with Long Documents||105|
|10||Everything You've Always Wanted to Know About Printing Documents||121|
|Pt. 3||Crunching Numbers with Excel Spreadsheets||135|
|11||Becoming a Data Entry Clerk||137|
|12||Doing Math with Formulas||153|
|13||Giving Your Worksheet a Professional Look||173|
|14||Graphing Data for Fun and Profit||187|
|15||Working with Worksheets||195|
|16||Everything You've Always Wanted to Know About Printing Worksheets||201|
|Pt. 4||Opening Your Own Print Shoppe with Microsoft Publisher||213|
|17||No-Brainer Publications with Wizards||215|
|18||It's All in How You Frame It||223|
|19||Adding a Professional Touch||233|
|20||Do-It-Yourself Greeting Cards and Invitations||239|
|21||Prepping Publications for a Professional Print Job||249|
|Pt. 5||Going Entrepreneurial with Small Business Financial Manager||257|
|22||Grabbing Data from Your Financial Program||259|
|23||Making Sense of the Numbers with Reports||267|
|24||Playing with Numbers with What-if Scenarios||273|
|Pt. 6||Looking After Your Life with Outlook||283|
|25||Whoa! Outlook Does All This?||285|
|26||Keeping Track of Dates, Mates, and Things To Do||297|
|27||Managing Your Email||311|
|Pt. 7||Tapping the Office Synergy||323|
|28||Sharing Data Between Applications||325|
|29||Creating and Publishing Your Own Web Pages||331|
|Pt. 8||Getting Productive with Office 97||347|
|30||Cruising the U.S. with Automap Streets Plus||349|
|31||Macros for Mere Mortals||359|
|32||Office 97 Productivity Tips||369|
|App||10-minute Guide to Internet Explorer 4||383|
|Glossary: Speak Like a Geek: The Complete Archive||395|
[Figures are not included in this sample chapter]
In This Chapter
When you're in a pinch, you can have a PageWizard whip out some prefab card. But
for some occasions, the standard fare isn't very appealing. You want a custom card,
one that shows off your flair for design and your ability to craft clever sayings.
And you don't want to have to work around a bunch of existing material that might
curb your creativity.
When the greeting card muse fills you with inspiration, create your own card from
scratch. In this chapter, you learn how to choose a type of fold for your card, add
graphics and text, embellish your card with graphic borders, and even print something
on the back. As an added bonus, this chapter contains a slew of tips for printing
and copying your card.
The most difficult part of creating a card is figuring out how to set up the pages
so that when you fold the card the pages appear in the proper order with everything
rightside-up on each page. Fortunately, Publisher can manage the card folds for you.
You just have to tell Publisher how you want the card to fold. Take the following
When Is a Page not a Page? When you're creating your card, keep in mind
that a page is not a sheet of paper. Think of a page as a square tile and the sheet
of paper as your floor. On a side or top fold card, you have four tiles on the floor.
Each card fold option provides you with four pages. If you chose the top fold
or side fold option, you have a document consisting of four pages that print on a
single sheet of paper. When folded, the card has a front, a back, and two inside
pages. A tent fold prints two pages on each of two sheets of paper (or on the front
and back side of a single sheet of paper, assuming you want to feed the sheet through
your printer twice). Tent folds are great for showing people where to sit at a dinner
Without an eye-catching front page, a greeting card is nothing more than pulp
for the recycle bin. You want a page that inspires awe in the recipient and compels
the person to open the card to see what other treasures are hidden inside. In the
following sections, you learn how to add a picture and WordArt object to the front
page. You also learn a little about cropping pictures.
The first item you should add to the front page is a picture. By adding the picture
first, you won't have to deal with any weird wrapping when you add your text. To
insert a picture, draw a picture frame, as explained in "Frame Construction
101," in Chapter 18. Double-click the frame and then choose a clip art image
and click OK.
When you insert a picture, the Import Picture dialog box appears, asking if you
want the picture to resize the frame to fit the picture or resize the picture to
fit the frame. Choose Change the Frame to Fit the Picture to prevent the picture
from being distorted. You can always resize it later by dragging the frame's handles.
See Chapter 18, "It's All in How You Frame It," for details on how to resize
and move pictures.
Publisher supports GIF and JPG graphic file formats (along with a bushel of other
formats), which are commonly used for graphics on Web pages. To save an image from
a Web page to your hard drive, right-click the image in Internet Explorer, choose
Save Picture As, choose the folder in which you want the image saved, and
click Save. You can then insert the picture in a picture frame by choosing
Insert, Picture File.
To have the image wrap around onto the back page, drag the left center handle
of the image to the left to extend the image onto the scratch area (the gray area
outside the page).
Sometimes you'll get a picture that includes a bunch of extra stuff you don't
really have room for. You can crop out what you don't need. Click the picture to
select it and then click the Crop Picture button. Move the mouse pointer over
one of the handles until it appears as a crop pointer and drag the handle toward
the center of the picture to crop out what you don't want. If you snip off too much
or change your mind later, follow the same steps, but drag away from the center to
Sure, you can stick a plain text frame on the front page, but if you want a little
more pizzazz on the front, WordArt's the tool of choice. Click the WordArt
button and drag a frame where you want the object placed. Type your text in the Enter
Your Text Here box (press Enter at the end of a line to start a new line).
Use the controls in the following table to change the shape and formatting of your
WordArt object. (You can edit a WordArt object later by double-clicking it.)
|Reshape bar||Reshape the WordArt object.|
|Typestyle bar||Choose a typestyle.|
|Font Size bar||Choose a font size. (Best Fit is not always the best fit.)|
|Bold button||Make the text bold.|
|Italic button||Make the text italic.|
|Same Height button||Make every character the same height, so a small "e" is as tall as a capital
"I." This looks weird.
|Vertically Stack button||Stack the letters vertically. (This looks pretty bad for any shape except Top to
|Stretch Text to Fill the Frame button||Stretch the text to fill the frame. This usually makes the text taller so that it
reaches up to the top and bottom of the frame.
|Align within Frame button||Align the text between the left and right edges of the frame: left, right, center,
or justified (stretched out to reach across the frame).
|Shove or Spread Letters button||Shove the letters together or spread them apart.|
|Rotate button||Rotate the text inside the frame or change the shape of the text.|
|Change Text Color button||Change the text color. (You'd think this would change the frame's background color,
but it actually changes the text color.)
|Drop Shadow button||Add a drop shadow to the text. This is cool.|
|Add Border button||Add a border to the text. This is sort of like making it bold.|
Whenever you choose a formatting option for the WordArt object, Publisher automatically
updates it, so you can see the change in action. If you click a button that displays
a dialog box, drag the dialog box's title bar to move the box out of the way so that
you can see the effects of your changes. (If you edit the text itself, you must click
the Update Display button to see how your new text will look.)
When you're done playing around with the object, click anywhere outside it. Click
the object again to select it. You can now change formatting for the frame itself.
For example, you can add a border, background shading, or drop shadow. (By default,
a WordArt frame is transparent, so if you lay it on top of your picture, you'll still
be able to see the picture behind the WordArt frame.)
Spin It In the previous table, you learned how to rotate the WordArt
text inside the frame. To rotate the frame and its contents, hold down the
Alt key while dragging one of the WordArt frame's handles.
That was fun, but now it's time to go inside and take care of business. Click
the Next Page button. If you're in Two-Page Spread view, you can see your
card as the recipient will see it when he or she opens it. However, in this view,
the pages are too dinky to work on, so choose View, Single Page, and
flip to page 3. (You can change views at any time by choosing the desired view from
the View menu.) You'll probably want to zoom in a little, too.
Insert a picture frame, as explained in "Dazzling the Recipient with the
Opening Picture," earlier in this chapter. In Two-Page Spread view, you can
size the graphic to make it straddle the fold so that it prints on pages 2 and 3.
Excel? Tables look sort of like Excel worksheets without the math. You
can select a column by clicking the gray bar at the top, or select a row by clicking
a bar at the left. Click the square in the upper-left corner to select the whole
As for the inside greeting, you have a few options: WordArt, text frame, or table.
For the basics of inserting these objects, see "Frame Construction 101,"
in Chapter 18. I don't want to stifle your creativity by telling you which one to
use, so I'll just give you a few pointers to help you decide and get you started:
Although you can leave the back of the card blank, the Hallmark commercials show
that every prima donna turns to the back first to check if the card is from Hallmark.
You really should stick some subtle design on the back to give your card a professional
look and feel.
The best tool to use for adding something to the back is the Design Gallery. Flip
to page 4 and click the Design Gallery button. Under Choose a Category, click
Attention Getters, Headlines, or Ornaments, and double-click
the desired design. Resize the object, edit any text it contains, and center it at
the bottom of the page. The most common text to place here is "Designed by"
followed by your name, but I'm sure you can come up with something more original.
After you've spent all that time designing and creating a custom card, you don't
want to cheapen it by printing it on some lightweight paper. Check your printer manual
to determine the types of paper you can use, and then go to your local office supply
store and get some high-quality card stock. While you're there, pick up some fancy
envelopes. Here are a few more tips that'll help you jazz up your card:
At this point, you should have a pretty cool card to send off. When you're ready
to make your next card, you should be able to do the following: