Excel 98 for Macs for dummies Book

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 Icons Used in This Book 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 from the Office Manager pop-up menu on the menu bar Starting Excel from the Office 98 folder Starting Excel from its alias Starting Excel from the Launcher by adding its alias as a button Mousing Around Minding your mouse manners Getting your mouse pointer in shape So What Do All These Buttons Do? Turning on to the menu bar Working with the Workbook title bar Scrutinizing the Standard toolbar Finding your way around the Formatting toolbar Fumbling around the formula bar Winding your way through the workbook window When a workbook sheet is not a worksheet 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 The keys to moving the cell pointer Block moves When you gotta go to that cell now! Lotsa luck with Scroll Lock Ordering Directly from the Menus Encountering the Excel menus Sizing up the shortcut menus Digging Those Dialog Boxes Ogling the Online Help Conferring with your Office Assistant Choosing a new persona for the Office Assistant Taking tips from the Office Assistant Carving out context-sensitive Balloon help Tackling the Help topics When It's Quitting Time 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 (Of Data, That Is) 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 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 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 Safe 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 Extending that cell selection AutoSelect keyboard style Nonadjacent cell selections with the keyboard Cell selections à la Go To Trimming Your Tables with AutoFormat Fancying Up 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 the Currency Style Fixing the format overflow 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 recently edited workbooks from the File menu When you don't know where to find them (your files, that is)can't find a workbook File hide-and-seek Advanced hide-and-seek Making a positive ID Doing stuff besides opening files Much Ado about Undo Undo a bunch 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 Getting the Full Screen View 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 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! Working with WordArt QuickTime Anytime Movie time in the old spreadsheet Changing the old poster frame One on Top of the Other Graphics: Now You See Them, Now You Don't Printing Charts Only Chapter 9: How to Face a Database Designing the Data Form Adding records to the database 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 HTML Adding Hyperlinks to a Worksheet Follow those hyperlinks! Editing and formatting hypertext links Editing and formatting graphics with hyperlinks Excel 98 Web Toolbar at Your Service Spreadsheets on the Web? Converting worksheet data into an HTML table Creating a table in a new HTML document Creating a table in an existing HTML document Checking your HTML table with your Web browser Part V: Doing a Custom Job Chapter 11: Macros Like Your Mother Used to Make Recording Macros Personally Speaking A Macro a Day It's playback time! A macro for all months Relative macro recording Rerecording 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 buttons that play macros Cute as a button Part VI: The Part of Tens Chapter 13: Top Ten New Features in Excel 98 Chapter 14: Top Ten Beginner Basics Chapter 15: The Ten Commandments of Excel 98 Chapter 16: Top Ten Things in Excel 98 That Can Trip You Up Chapter 17: Top Ten Ways to Impress the Boss Chapter 18: Top Ten Thousand Keystroke Shortcuts Index Book Registration Information