• EXCEL 2000 for Windows For Dummies See large image

    EXCEL 2000 for Windows For Dummies (For Dummies) (Paperback) By (author) Greg Harvey

    Hard to find title available from Book Depository

    $17.86 - Save $12.80 41% off - RRP $30.66 Free delivery worldwide Available
    Dispatched in 2 business days
    When will my order arrive?
    Add to basket | Add to wishlist |

    DescriptionJust 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.


Other books

Other people who viewed this bought | Other books in this category
Showing items 1 to 10 of 10

 

Reviews | Bibliographic data
  • Full bibliographic data for EXCEL 2000 for Windows For Dummies

    Title
    EXCEL 2000 for Windows For Dummies
    Authors and contributors
    By (author) Greg Harvey
    Physical properties
    Format: Paperback
    Number of pages: 432
    Width: 192 mm
    Height: 235 mm
    Thickness: 25 mm
    Weight: 609 g
    Language
    English
    ISBN
    ISBN 13: 9780764504464
    ISBN 10: 0764504460
    Classifications

    BIC E4L: COM
    B&T Book Type: NF
    B&T Modifier: Region of Publication: 01
    B&T Modifier: Subject Development: 20
    BIC subject category V2: UF
    Nielsen BookScan Product Class 3: S10.4
    B&T Modifier: Text Format: 01
    DC21: 005.369
    LC subject heading:
    B&T Merchandise Category: COM
    LC subject heading: , ,
    DC22: 005.369
    BISAC V2.8: COM054000
    Ingram Subject Code: XW
    Libri: I-XW
    Warengruppen-Systematik des deutschen Buchhandels: 16350
    LC subject heading:
    LC classification: HF5548.4.M
    BISAC V2.8: COM055000
    B&T General Subject: 230
    LC classification: HF5548.4.M523 H3668 1999
    Thema V1.0: UFC
    Illustrations note
    illustrations
    Publisher
    John Wiley & Sons Inc
    Imprint name
    Hungry Minds Inc,U.S.
    Publication date
    21 May 1999
    Publication City/Country
    Foster City
    Author Information
    Greg Harvey is a veteran software trainer and the author of more than 30 computer books.
    Back cover copy
    Get time-saving tips on data entry, formatting, and moreFind out how to save worksheets as interactive Web pagesStart crunching numbers today ? even if you don't know a spreadsheet from a bedsheet Excel 2000 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 and tricks, it walks you step-by-step through Excel fundamentals ? and shows you how to take advantage of the enhanced Internet and workgroup tools as well as other cool features.Discover how to: Create worksheets and enter dataUse formulas and functionsMake your spreadsheets look terrificOrganize multiple worksheetsWork with charts, databases, and hyperlinksCustomize ExcelThe Dummies WayExplanations in plain English"Get in, get out" informationIcons and other navigational aidsTear-out cheat sheetTop ten listsA dash of humor and funGet smart! www.dummies.comRegister to win cool prizesBrowse exclusive articles and excerptsGet a free Dummies Daily e-mail newsletterChat with authors and preview other booksTalk to us, ask questions, get answers
    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.