Using Microsoft Excel 2000: (Using)

Using Microsoft Excel 2000 is structured in content and approach to fill the needs of the intermediate user, showing you how to get a task done and get on with your job. It provides enough information to be a through reference for all but the most advanced users while not intimidating newer users. This book brings you real-world, practical content that can not only increase the ability to use the software, but also increase your actual productivity level.

Table of Contents:
Introduction. Why This Book? Who Should Use This Book? How This Book Is Organized. Conventions Used in This Book. I. WORKBOOK BASICS. 1. Starting, Quitting, and Getting Help. Starting and Quitting Excel. The Excel Environment. Getting Help. 2. Opening, Searching For, and Closing Files. Opening Files. Searching for a File. Using Hyperlinks. Closing Workbook Files. 3. Saving Files and Using Templates. Saving Files as Workbooks. Creating and Using Templates. 4. Saving Excel Data as a Web Page. Saving a Worksheet as a Web Page. Saving a Static Web Page. Saving an Interactive Web Page. Using an Interactive Web Page. 5. Selecting and Navigating Worksheets. Naming Worksheets. Selecting Worksheets. Deselecting a Group of Worksheets. Moving Around in a Worksheet. Selecting Cells in a Worksheet. Adding and Deleting Worksheets. Changing the Default Number of Sheets in a New Workbook. Rearranging Worksheets. 6. Changing Your View of the Worksheet. Freezing Worksheet Panes to Keep Rows or Columns in View. Splitting Worksheet Panes to View Multiple Areas in a Worksheet. Using Multiple Windows. II. BUILDING WORKSHEETS. 7. Entering Data. Entering Data Directly in a Worksheet. Entering Data with a Data Entry Form. Validating Data During Entry. 8. Copying and Importing Data from Other Files. Trading Data with Other Programs. Copying Data from Word. Sending Data Over from Access. Sending Excel Data to Access. Importing a Text File. 9. Editing Data. Editing Cell Entries. Finding and Replacing Data. Deleting Data. Undoing Mistakes. Moving and Copying Cells on the Same Worksheet. Moving and Copying Cells to a Different Worksheet. Inserting and Deleting Rows and Columns. Inserting and Deleting Cells. Separating a Single Column into Multiple Columns. Adding Worksheet Comments. Using AutoCorrect. Letting Excel Check Your Spelling. 10. Simple Calculations. Simple Calculations, Quick Answers. About Cell References. Writing Your Own Formulas. 11. Complex Calculations. Understanding Functions. Using Functions. Using Cell Names and Labels. Converting Formula Results to Values. Locating Worksheet Errors. III. FORMATTING. 12. Formatting Cells. The Formatting Toolbar. Formatting the Font. Making the Cell Fit the Text (and Vice Versa). Formatting Borders. Formatting Colors. Copying Formatting with Format Painter. Using AutoFormat to Create a Table with Built-In Formats. Adding a Graphic Image to a Worksheet. 13. Formatting Numbers. Applying Number Formats to Cells. Formatting Dates and Times. Formatting Text Entries. Creating Conditional Number Formats Converting Actual Values to Displayed Values. Hiding Zeroes. 14. Formatting with Styles for Less Effort. Applying a Built-In Style. Changing a Style Definition. Creating a Custom Style by Example. Copying Styles from Other Workbooks. Deleting a Style. IV. SORTING, FILTERING, AND SUMMARIZING DATA. 15. Sorting Lists. Sorting a List by a Single Column. Sorting a List by Two or Three Columns. Sorting a List by More Than Three Columns. Sorting According to a Custom List. Sorting a List Randomly. Undoing a Sort and Returning the List to Its Former Arrangement. 16. Filtering Lists. Filtering Records. Calculating Filtered Records. The Query Wizard: A Better Filter. 17. Finding Answers and Making Decisions. Goal Seeking for Answers. Creating and Comparing Scenarios. 18. Summarizing Details with Consolidation or Subtotals. Understanding Consolidations and Subtotals. Consolidating a Table. Subtotaling a Table. Outlining a Table Manually. Summarizing Details with PivotTables and PivotCharts. Working with PivotTables. PivotTable Terms. Creating a PivotTable. The PivotTable Toolbar. Changing PivotTable Arrangement. Changing PivotTable Calculations. Showing Underlying Details. Formatting a PivotTable. Working with PivotCharts. PivotCharts Versus Normal Charts. Creating PivotCharts. Rearranging PivotCharts. Formatting PivotCharts. V. CHARTS. 20. Creating a Chart. Creating a Chart with the Chart Wizard. Types of Charts. The Chart Toolbar. Changing the Chart Type. Changing Chart Data. Changing Chart Orientation. Moving and Resizing a Chart. Changing the Chart Location. 21. Formatting a Chart. Formatting Chart Colors, Lines, and Fonts. Deleting a Chart Element. Changing Axis Scale. Reordering the Series. Resizing and Exploding a Pie Chart. Changing 3D Perspective. Adding a Trendline. Adding a Secondary Axis. Adding Data Labels. Creating Picture Markers. Saving and Reusing Your Custom Chart Format. 22. Putting Data on a Map. Introducing Microsoft Map. Creating a Geographical Data Map. Adding Features to Your Map. Labeling Map Items. Repositioning and Enlarging a Map. Using the Map Control. Creating Custom Pin Maps. VI. PRINTING. 23. Deciding What to Print. Previewing Printed Pages. Printing a Quick Copy of a Worksheet. Printing Part of a Worksheet. Setting a Print Area. Printing a Chart. Printing an Entire Workbook. 24. Formatting the Printed Page. Changing Page Breaks. Changing the Page Layout. Printing a Worksheet on a Specific Number of Pages. Printing Row and Column Labels on Every Page. Creating a Custom Header or Footer. Printing Worksheet Gridlines. Printing in Black and White. Formatting Printed Charts. VII. SHARING DATA WITH OTHER USERS AND OTHER APPLICATIONS. 25. Sharing a Workbook with Other Users. Sharing a Workbook. Whos Using a Shared Workbook? Saving a Shared Workbook. Reviewing Changes in a Shared Workbook. Tracking Changes in a Shared Workbook. Accepting and Rejecting Tracked Changes. Merging Shared Workbooks. Printing a History of Changes. Unsharing a Workbook. Saving a Workbook as Read-Only (the Opposite of Sharing). Protecting Workbooks and Worksheets. 26. Sharing Data Between Applications. Sharing Data: Pasting, Embedding, and Linking Objects. Sending Data from Excel to Word. Bringing Data from Word into Excel. Changing a Links Source. Dragging a Hyperlink or Shortcut Icon into Excel. Pasting Excel Data to a PowerPoint Slide. VIII. CUSTOMIZING AND AUTOMATING. 27. Customizing Your Excel Screen. Customizing Screen Elements. Changing Your Screen Display. Personalizing Your Toolbars. Customizing Your Menu Bar. 28. Automating Repetitive Work with Macros. Introducing Macros. Recording a Macro. Running a Macro. Editing a Macro. Attaching a Macro to a Toolbar Button or Menu Command. Creating a Toggle Macro. 29. Using Excels Built-In Templates. Working with Templates. Installing the Template Wizard Add-In. Entering Automated Information in the Template. Setting Up the Collection Database. Saving Copies of the Template to Collect Summary Data. Using the Collection Database. IX. CREATIVE EXCEL. 30. Drawing Objects. Basic Drawing. Creating AutoShapes. Drawing Text Boxes. Converting Objects to 3D. Creating WordArt Objects. 31. Creative Worksheets. Creative Approaches to Worksheet Applications. Kurts Invoice--a Creative Invoice Solution. Theatre Seating. 32. Creative Charts. Creative Approaches to Charting. Giffs Chart. Stacked Columns. Dynamic Chart Display. Glossary. Index.