| Introduction |
|
1 | (4) |
| Part 1: Basic Training |
|
5 | (100) |
|
|
|
7 | (18) |
|
A brief look at how spreadsheets work. Acclimate yourself to the Excel environment and learn what all the program elements do, plus find out what's new and improved in Excel 2000. |
|
|
|
|
|
25 | (16) |
|
Learn all the basics for finagling your files, such as opening and closing workbooks, starting new workbooks, saving files, and assigning filenames. You even learn how to juggle multiple files while chewing gum at the same time. |
|
|
|
|
|
41 | (16) |
|
When you're ready to enter data into your Excel worksheet, this is the chapter to turn to; learn about the various data types and how Excel deals with them all. |
|
|
|
The Wonderful World of Worksheets |
|
|
57 | (18) |
|
A chapter dedicated solely to the mysterious inner workings of your Excel worksheets; learn how to navigate, add and delete sheets, and assign them affectionate names, such as ``Cruncher.'' |
|
|
|
|
|
75 | (16) |
|
If you ever feel like you're drowning in a sea of worksheet cells, grab onto Excel's Help tools to keep you afloat. Learn where to look for help with Excel, including how to find help on the Internet. |
|
|
|
|
|
91 | (14) |
|
Tired of the same old Excel screen? Then try a little redecorating. Customize the toolbars and menus, turn off program elements to view more of your worksheet, and learn a few other customizing tricks in this chapter. |
|
|
| Part 2: Putting Excel to Work |
|
105 | (56) |
|
Working the Wide-Open Ranges |
|
|
107 | (10) |
|
Here, you learn how to work with Excel ranges, including selecting and naming them for use in formulas. |
|
|
|
|
|
117 | (16) |
|
Finally, time to put on those safety goggles and head to the worksheet lab. Learn all about creating formulas in this chapter, including how to use mathematical operators and absolute and relative cell addresses. |
|
|
|
Functions: Fast Formulas for Fast Results |
|
|
133 | (18) |
|
To really speed up your number juggling tasks in Excel, toss in a few readymade functions, as explained in this chapter. |
|
|
|
|
|
151 | (10) |
|
Your formula isn't working and there's a big old error message in the cell---what do you do? Turn to this chapter, of course, for a run-down of various ways to correct formula mistakes. |
|
|
| Part 3: Worksheet Grooming |
|
161 | (78) |
|
Formatting for Fun or Profit |
|
|
163 | (18) |
|
Nothing adds polish to a worksheet faster than a coat of high-gloss lacquer. But if you're looking for other ways to spruce things up, tap into Excel's formatting commands. This chapter shows you how change fonts, make your numbers more attractive, and realign your data. |
|
|
|
Rearranging Your Worksheet Data |
|
|
181 | (18) |
|
Here's another chapter on the benefits of redecorating. This time, the focus is on rearranging your worksheet data to make everything look nice. Learn how to resize, add, and delete columns and rows; move or copy data; and find a needle in a large Excel haystack. |
|
|
|
|
|
199 | (14) |
|
They say a picture is worth a thousand words, but what if you're working with numbers? The saying still applies. Learn how to add clip art and graphics to add pizzazz to your workbook. You also learn how to use Excel's drawing tools to create your own shapes and WordArt objects. |
|
|
|
Adding Borders and Backgrounds |
|
|
213 | (12) |
|
Why not make your cells really stand out with borders and backgrounds? Learn how in this chapter. |
|
|
|
|
|
225 | (14) |
|
When you're finally ready to print your worksheet masterpiece, flip over to this chapter for steps on previewing and printing. Here, you find information about setting page margins, adding headers and footers, and creating page breaks. |
|
|
| Part 4: Charting New Territory |
|
239 | (34) |
|
|
|
241 | (10) |
|
When it comes to making your data talk, don't bother with a soundtrack. Turn your numbers into nifty charts and graphs using Excel's Chart Wizard tool. |
|
|
|
|
|
251 | (12) |
|
After you've created a chart, you'll want to apply a few formatting techniques to make your data look it's best, as covered in this chapter. |
|
|
|
|
|
263 | (10) |
|
Hey! Did you know Excel comes with a tool for creating geographical map charts? Well it does, and you learn how to use it in this chapter. |
|
|
| Part 5: Building and Analyzing Databases |
|
273 | (46) |
|
Build Your Own Excel Databases |
|
|
275 | (12) |
|
Here's another interesting use for Excel worksheets: Turn them into databases to keep track of lists and organize data. Learn how to build a database and enter records in this chapter. |
|
|
|
|
|
287 | (8) |
|
What do you do with a database after you build it? You slyly manipulate it against its will to do your every bidding, which basically amounts to sorting and filtering the data. |
|
|
|
|
|
295 | (16) |
|
If you're really into heavy-duty data manipulation, then check out Excel's PivotTable feature. Use it to analyze your worksheet data like a pro. |
|
|
|
|
|
311 | (8) |
|
More data manipulation tricks---learn how to use Excel's Goal Seek tool and project what will happen to this or that with Excel's Scenario tool. |
|
|
| Part 6: Nothing but Net |
|
319 | (36) |
|
Integrating Excel with Other Applications |
|
|
321 | (12) |
|
Here's a chapter devoted to ways to make Excel share data with other Excel users, with non-Excel users, and with itself. Learn how to link and embed data, import and export data, and use that nifty new Clipboard toolbar. |
|
|
|
|
|
333 | (14) |
|
Use Excel's Web tools to tap into the power of the Internet, all from your Excel program window. Find out how to surf the Web, download files, and run a Web Query (a way cool feature you won't want to miss). |
|
|
|
|
|
347 | (8) |
|
Don't be left out of the mad rush to publish to the Web. You can turn any Excel worksheet into a Web page that would make your mother proud. This chapter shows you how. |
|
|
| Appendix: Windows 98 in a Flash |
|
355 | (12) |
|
New to Windows? No problem---here's a simple beginners' guide to using Windows and understanding the lingo tossed around in this book. |
|
|
| Glossary: Speak Like a Geek |
|
367 | (4) |
|
A compendium of geeky computer terms used throughout this book. |
|
|
| Index |
|
371 | |
|
Where to turn to find what you're looking for. |
|
|
Other versions by this Author
