Synopses & Reviews
Just because electronic spreadsheets like Excel 2002 have become almost as commonplace on today's personal computers as word processors and games doesn't mean that they're either well understood or well used. If you're one of the many folks who has Office XP on your computer but doesn't know a spreadsheet from a bedsheet, this means that Excel 2002 is just sitting there taking up a lot of space. Well, it's high time to change all that.
One look at the Excel 2002 screen (with all its boxes, buttons, and tabs), and you realize how much stuff is going on there. Excel 2002 For Dummies will help you make some sense out of the rash of icons, buttons, and boxes that you're going to be facing day after day. And when you ready to go beyond spreadsheet basics, this guide will also introduce you to
- Conjuring up charts
- Inserting graphics
- Designing a database
- Converting spreadsheets into Web pages
Most of all, Excel 2002 For Dummies covers the fundamental techniques that you need to know in order to create, edit, format, and print your own worksheets. In this book, you'll find all the information that you need to keep your head above water as you accomplish the everyday tasks that people do with Excel. This down-to-earth guide covers all these topics and more:
- Creating a spreadsheet from scratch
- Document recovery
- Formatting fundamentals
- Making corrections (and how to undo them)
- Retrieving data from your spreadsheets
- Protecting your documents
- Demystifying formulas
Now, even if your job doesn't involve creating worksheets with a lot of fancy financial calculations or lah-dee-dah charts, you probably have plenty of things for which you could and should be using Excel. For instance, you may have to keep lists of information or maybe even put together tables of information for your job. Excel is a great list keeper and one heck of a table maker. You can use Excel anytime you need to keep track of products that you sell, clients who you service, employees who you oversee, or you name it.
"Microsoft Excel 2002 For Dummies provides the key information you need to build spreadsheets, enter data, handle formulas, create charts and graphs, and tell a story with your work. This guide covers the newest features included with Excel including new time saving fill and formatting features as well as an updated interface.
This volume aims to offer clear, plain-English explanations on how to make the most of Excel. From worksheet basics to updaes, the author leads you through the steps to designing spreadsheets that help you manage information effectively and efficiently.
Your fun and easy road map to sensational spreadsheets
Get timesaving tips on the new fill and formatting features!
Find out how to save worksheets as interactive Web pages
Start crunching numbers today—even if you don't knowa spreadsheet from a bedsheet
Excel 2002 can help you keep records, track trends, and analyze results — once you get up to speed. That's where this friendly guide comes in. Packed with expert tips, it walk you through Excel fundamentals — including the new Task Pane interface — and shows you how to take advantage of voice recognition, handwriting recognition, and other cool features.
Discover how to: Create worksheets and enter data
Use formulas and functions
Make your spreadsheets look terrific
Organize multiple worksheets
Work with charts, databases, and hyperlinks
THE DUMMIES WAYTM
Explanation in plain English
"Get in, get out" information
Icons and other navigational aids
Tear-out cheat sheet
Top ten lists
A dash of humor and fun
Sign up for daily eTips at www.dummiesdaily.com
Choose from among 33 different subject categories
Get news you can use on everything from money to health to computers
About the Author
Greg Harvey is a veteran software trainer and the author of more than thirty compuer books.
Table of Contents
PART 1: GETTING IN ON THE GROUND FLOOR.
Chapter 1: What Is All This Stuff?
Chapter 2: Creating a Spreadsheet from Scratch.
PART II: EDITING WITHOUT TEARS.
Chapter 3: Making It All Look Pretty.
Chapter 4: Going Through Changes.
Chapter 5: Printing the Masterpiece.
PART III: GETTING ORGANIZED AND STAYING THAT WAY.
Chapter 6: Oh, What a Tangled Worksheet We Weave!
Chapter 7: Maintaining Multiple Worksheets.
PART IV: LIFE BEYOND THE SPREADSHEET.
Chapter 8: The Simple Art of Making Charts.
Chapter 9: How to Face a Database.
Chapter 10: Of Hyperlinks and Web Pages.
PART V: THE PART OF TENS.
Chapter 11: Top Ten New Features in Excel 2002.
Chapter 12: Top Ten Beginner Basics.
Chapter 13: The Ten Commandments of Excel 2002.
Book Registration Information.