|
EXCEL 2000 for Windows for Dummies (For Dummies S.)
Just because electronic spreadsheets like Excel 2000 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. Excel is a great organizer for all types of data, be they numeric, textual, or otherwise. Excel 2000 For Windows For Dummies covers all the fundamental
techniques that you need to know in order to create, edit, format, and print your own worksheets. In addition to showing you around the worksheet, this fun and friendly book exposes you to the basics of charting, creating databases, and converting spreadsheets into Web pages. Expect to pick up invaluable tips and tricks on Creating a spreadsheet from the get-go Dressing up the look of your cells Printing your spreadsheet masterpiece Facing a database Making sense of multiple worksheets Editing your worksheet Web pages Keeping things simple, this book cuts to the chase by telling you in plain terms just what it is that you need to do to accomplish a task using Excel. With spreadsheets as the focus, Excel 2000 For Windows For Dummies shows you how to Launch Excel from a toolbar or browser Mess around with the menu bar Fabricate fabulous formulas Tamper with how text wraps Add hyperlinks to a worksheet Work with WordArt Customize and design your own toolbars Explore top features of Excel 2000 One look at the Excel 2000 screen (with all the boxes, buttons, and tabs), and you realize that there's a whole lot of stuff going on. With this book as your expert companion, you can tame your anxiety over the tech stuff and cell-abrate success with all the computing, text-editing, and formatting potential in this powerhouse program.
Contents:
Introduction
About This Book
How to Use This Book
What You Can Safely Ignore
Foolish Assumptions
How This Book Is Organized
PART I: Getting In on the Ground Floor
PART II: Editing without Tears
PART III: Getting Organized and Staying That Way
PART IV: Life beyond the Spreadsheet
PART V: Doing a Custom Job
PART VI:The Part of Tens
Conventions Used in This Book
Keyboard and mouse
Special icons
Where to Go from Here
PART I: Getting In on the Ground Floor
Chapter 1: What Is All This Stuff? What the Hell Would I Do with Excel? Little boxes, little boxes
Send it to my cell address
So just how many cells are we talking about here? Assigning 26 letters to 256 columns
What you should know about Excel at this point
What you still need to know about Excel
Getting the Darn Thing Started
Starting Excel 2000 from the Programs or Desktop Office 2000 shortcut bar
Starting Excel 2000 from the Windows 95/98 Start Menu
Starting Excel 2000 from the Windows Explorer
Creating an Excel 2000 shortcut
Automatically opening Excel every time you turn on your computer
Mousing Around
Minding your mouse manners
Getting your mouse pointer in shape
So What Do All These Buttons Do? Turning on to the title bar
Messing around with the menu bar
Scrutinizing the Standard and Formatting toolbars
Fumbling around the formula bar
Winding your way through the workbook window
Manually manipulating the workbook window
Slipping through the sheets
Scoping out the status bar
You AutoCalculate my totals
The Num Lock indicator and the numeric keypad
You Gotta Get Me Out of This Cell! The secrets of scrolling
Calling up new columns with the horizontal scroll bar
Raising up new rows with the vertical scroll bar
Scrolling from screen to screen
Scrolling with the IntelliMouse
The keys to moving the cell pointer
Block moves
When you gotta go to that cell right now! Lotsa luck with Scroll Lock
Ordering Directly from the Menus
Penetrating the pull-down menus
Now you see 'em, now you don't
Comprehending shortcut menus
Digging Those Dialog Boxes
Ogling the Online Help
Conferring with your Office Assistant
Things to do when Clippit doesn't understand you
Putting Clippit back in his drawer
Choosing a new persona for the Office Assistant
Taking tips from the Office Assistant
Carving out context-sensitive Help
Tackling the Help topics
When It's Time to Make Your Exit
Chapter 2: Creating a Spreadsheet from Scratch
So What Ya Gonna Put in That New Workbook of Yours? The ins and outs of data entry
You must remember this
Doing the Data-Entry Thing
It Takes All Types
The telltale signs of text
How Excel evaluates its values
Making sure that Excel's got your number
How to get your decimal places fixed (when you don't even know if they're broken)
Tapping on the old ten-key
Entering dates with no debate
All the way in Y2K!
Fabricating those fabulous formulas! if you want it, just point it out
Altering the natural order of operations
Formula flub-ups
Fixing Up Those Data Entry Flub-ups
You really AutoCorrect that for me
Cell editing etiquette
Taking the Drudgery Out of Data Entry
I'm just not complete without you
Fill 'er up with AutoFill
Working with a spaced series
Copying with AutoFill
Creating custom lists for AutoFill
Entries all around the block
Data entry express
How to Make Your Formulas Function Even Better
Inserting a function into a formula with the Paste Function and the Formula Palette
Editing a function with the Edit Formula button
I'd be totally lost without AutoSum
Making Sure the Data's Sate and Sound
PART II: Editing without Tears
Chapter 3: Making It All Look Pretty
Choosing a Select Group of Cells
Point-and-click cell selections
Shifty cell selections
Nonadjacent cell selections
Going for the big cell selections
Selecting the cells in a table of data, courtesy of AutoSelect
Keyboard cell selections
Extend that cell selection
AutoSelect keyboard style
Nonadjacent cell selections with the keyboard
Cell selections a la Go To
Trimming Your Tables with AutoFormat
Festooning Your Cells with the Formatting Toolbar
Transient toolbars
Toolbar docking maneuvers
Using the Format Cells Dialog Box
Getting to know the number formats
Currying your cells with Currency Style
Look Ma, no more format overflow!
Currying your cells with the Comma Style
Playing around with the Percent Style
Deciding how many decimal places
The values behind the formatting
Ogling the other number formats
Sorting through the Special number formats
Creating custom number formats
Calibrating Columns
Rambling rows
Now you see it, now you don't
Hiding columns and rows, courtesy of the pull-down and shortcut menus
Hiding columns and rows with the mouse
Futzing with the Fonts
Altering the Alignment
Intent on Indents
From top to bottom
Tampering with how the text wraps
Reordering the orientation
Shrink to fit
Bring on the borders! Putting on new patterns
Showing Off in Styles
Fooling Around with the Format Painter
Conditional Formatting
Chapter 4: Going through Changes
Opening the Darned Thing Up for Editing
Opening more than one workbook at a time
Opening recently edited workbooks from the File menu
When you don't know where to find them
Searching the wide disk over
Playing favorites
File hide-and-seek
Making a positive ID
Opening files with a twist
Much Ado about Undo
Undo is Redo the second time around
What ya gonna do when you can't Undo? Doing the Old Drag-and-Drop Thing
Copies, drag-and-drop style
Insertions courtesy of drag and drop
Formulas on AutoFill
Relatively speaking
Some things are absolutes! Cut and paste, digital style
Paste it again, Sam
So what's so special about Paste Special? Let's Be Clear about Deleting Stuff
Sounding the all clear! Get these cells outta here! Kindly Step Aside
Stamping Out Your Spelling Errors
Chapter 5: Printing the Masterpiece
Starting the Show with Print Preview
The Page Stops Here
Printing it right away
Printing it your way
Printing in particular
Setting and clearing the Print Area
My Page Was Setup! Getting the lay of the landscape
Packing it all on one page
Massaging the margins
From header to footer
Getting a standard job
Getting a custom job
Sorting out the sheet settings
Putting out the print titles
When Ya Gonna Give Your Page a Break? Letting Your Formulas All Hang Out
PART III: Getting Organized and Staying That Way
Chapter 6: Oh, What a Tangled Worksheet We Weave! Zeroing In with Zoom
Splitting the Difference
Fixed Headings Courtesy of Freeze Panes
Electronic Sticky Notes
Adding a comment to a cell
Comments in review
Editing the comments in a worksheet
Getting your comments in print
The Cell Name Game
If I only had a name
Name that formula! Naming formulas with data table headings
Seek and Ye Shall Find..
You Can Be Replaced! You Can Be So Calculating
Putting On the Protection
Chapter 7: Maintaining Multiple Worksheets
Juggling Worksheets
Sliding between the sheets
Editing en masse
Don't Short-Sheet Me! A sheet by any other name
Getting your sheets in order
Opening Windows on Your Worksheets
Passing Sheets in the Night
To Sum Up
PART IV: Life beyond the Spreadsheet
Chapter 8: The Simple Art of Making Charts
Conjuring Up Charts with the Chart Wizard
Moving and resizing a chart in a worksheet
Changing the chart with the Chart toolbar
Editing the chart directly in the worksheet
Changing the Chart Options
Telling all with a text box
Formatting the x- or y-axis
Vacillating values mean changing charts
Changing perspectives
Picture This! Getting clip art online
Drawing your own
Working with WordArt
One on Top of the Other
Nixing the Graphics
Printing Charts Only
Chapter 9: How to Face a Database
Designing the Data Form
Adding records to the database
Adding e-mail and Web addresses to a hyperlink field
Locating, changing, and deleting records
Scrolling the night away! Finders keepers
Sorting It All Out
You AutoFilter the Database to See the Records You Want
Viewing the top ten records
Getting creative with custom AutoFilters
Chapter 10: Of Hyperlinks and Web Pages
Adding Hyperlinks to a Worksheet
Follow those hyperlinks! Editing and formatting hypertext links
Editing and formatting graphics with hyperlinks
Spreadsheets on the Web? Saving a static Web page
Saving an interactive Web page
Acting out with interactive worksheet data
Acting up with an interactive database
Acting on an interactive chart
Adding worksheet data to an existing Web page
Editing your worksheet Web pages
Editing a worksheet Web page in Excel 2000
Exporting an interactive Web page to Excel
Drag and drop tables, anyone?
Previewing and Publishing Your Web Pages
Previewing Web pages with your browser
Creating Web folders for publishing your Web pages
Setting up FTP locations for publishing your Web pages
Sending Worksheets via E-Mail
PART V: Doing a Custom Job
Chapter 11: Macros Like Your Mom Used to Make
Recording Macros
Personally Speaking
A Macro a Day
It's playback time! A macro for all months
Relative macro recording
Re-recording a macro
Chapter 12: Button Up That Toolbar! Toolbars - Now You See 'em, Now You Don't
Customizing the Built-In Toolbars
Adding buttons from the Customize dialog box
Removing buttons from a toolbar
Playing musical chairs with buttons
What a bunch of spaced-out buttons! It's not my default! Designing Your Own Toolbars
Adding custom buttons that play macros
Assigning a macro to a menu item
Assigning a hyperlink to a custom button
Cute as a button
PART VI: The Part of Tens
Chapter 13: Top Ten New Features in Excel 2000
Chapter 14: Top Ten Beginner Basics
Chapter 15: The Ten Commandments of Excel 2000
Index
Book Registration Information.
Brief Description:
An exploration of how to use Excel 2000. It discusses how to build and format worksheets, produce charts, add interactivity to worksheets with hyperlinks, add QuickTime VR movies to spreadsheets, and publish worksheets on an intranet or on the Web.
|
