Page 18 - Excel Timesaving Techniques for Dummies

00c_574272_cintro.qxd 10/1/04 10:20 PM Page 3
What’s In This Book
Part IV: Worksheet Formula Timesavers Part VII: Streamlining Data Listing 3
and Data Analysis
The techniques in this part are devoted to enabling
you to create efficient and well-formed formulas in This part is dedicated to skillful means for turning
your Excel spreadsheets. Here you find out how to great quantities of raw data into usable information.
accurately copy formulas using all types of cell ref- Here you find techniques for organizing, searching,
erences, greatly speed up table creation through sorting, and filtering the data you keep. You are also
the use of array formulas, and document formulas introduced to what-if analysis and data summation
through the sagacious use of range names. As if this in all its glory in the form of data tables, scenarios,
weren’t enough, you also find out how to create for- goal seeking, and those wonderful pivot tables and
mulas that trap Excel error values and prevent them pivot charts.
from spreading far and wide throughout the spread-
sheet and, in the event that they do succeed in get- Part VIII: Internet-Related Timesavers
ting out, how to trace their source and eliminate
them on the spot. The techniques in this part give you the inside track
on sharing Excel data on the World Wide Web. Here
Part V: Worksheet Editing Timesavers you find out how to instantly convert your Excel
worksheet data and charts into HTML documents
The techniques in this part center on how to make ready to publish to your Web pages either on the
efficient editing changes in a completed spread- Internet or your company’s intranet. You also find
sheet. Knowing these techniques can save you out how to easily import data from Web pages
oodles of time if you’re among the more common directly into Excel where you can manipulate the
worksheet users who spend a majority of the time data to your heart’s content and how to add hyper-
adding to and updating existing company work- links to your worksheets to make any kind of jump
books. Here you find out how to quickly find the you need, from one worksheet to another in the
workbook you want to edit, control the Excel screen same workbook all the way to any address on the
display so you can see what you’re editing at all Internet.
times, use the editing tips and tricks of the pros,
as well as consolidate data from several worksheets Part IX: The Scary (Or Fun) Stuff
and subtotal their data without even breaking a
sweat. This last part contains a potpourri of techniques,
some of which are thrown in for the fun of it and oth-
Part VI: Tips for Printing, Sharing, ers that you may at first perceive to be somewhat of
and Reviewing Workbooks a stretch. (I don’t actually include techniques here
that you really need to apprehensive of.) Among the
Tops among the techniques in this part is the first fun techniques, you find out how to use Excel 2003
one on spreadsheet security and how to protect lists (which are a real delight and are so easy they
your sensitive data from unwarranted opening or almost create themselves), how to do worksheet
edits without ending up being locked out of the file data entry and issue Excel commands with the power
yourself. Here you also find out how to produce flaw- of your voice, and how to spruce up the look of your
less printed reports, share Excel data with the other spreadsheets with art images (both those you draw
programs you run, share your workbook files on a and others you import).
local network, and send your files out to coworkers
and clients for a formal review. Among the less instantly comfortable techniques
in this part are creating lookup formulas that return
data from schedules and other data tables, creating