EXCEL 2000 for Windows For Dummies
Home > Computing and Information Technology > Business applications > EXCEL 2000 for Windows For Dummies
EXCEL 2000 for Windows For Dummies

EXCEL 2000 for Windows For Dummies


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

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.

Table of 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.

About the Author :
Greg Harvey is a veteran software trainer and the author of more than 30 computer books.


Best Sellers


Product Details
  • ISBN-13: 9780764504464
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: Hungry Minds Inc,U.S.
  • Height: 235 mm
  • Returnable: N
  • Weight: 609 gr
  • ISBN-10: 0764504460
  • Publisher Date: 21 May 1999
  • Binding: Paperback
  • Language: English
  • Spine Width: 25 mm
  • Width: 192 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
EXCEL 2000 for Windows For Dummies
John Wiley & Sons Inc -
EXCEL 2000 for Windows For Dummies
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

EXCEL 2000 for Windows For Dummies

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!