| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| Top Ten Questions | |
| |
| |
| If I give/send an Excel 2000 file to someone who has Office 97, will that person be able to open it? | |
| |
| |
| How do I turn off the Office Assistant? | |
| |
| |
| How do I get Excel to show my menus normally like they did in earlier versions? | |
| |
| |
| Does Excel support the new Euro currency format? | |
| |
| |
| How can I enter year 2000 dates? | |
| |
| |
| Will I be able to work on my Excel files in Excel after they have been converted to HTML format? | |
| |
| |
| The menus in all the Office 2000 applications are changing themselves on me! What's going on? | |
| |
| |
| When making a pivot table, I no longer see all the steps to drag and drop the items in the wizard | |
| |
| |
| What is the easiest way to bring in table data from a Web page? | |
| |
| |
| Am I selecting cells properly? They don't highlight like they used to | |
| |
| |
| Excel Worksheets | |
| |
| |
| ? Opening, Saving, and Closing Files | |
| |
| |
| ? Moving Around the Worksheet | |
| |
| |
| ? Selecting Cells | |
| |
| |
| ? Copying and Moving Cell Contents | |
| |
| |
| ? Security | |
| |
| |
| Data Entry | |
| |
| |
| ? Text and Numerical Entry | |
| |
| |
| ? Editing Data | |
| |
| |
| ? Entering Dates | |
| |
| |
| Formulas and Functions | |
| |
| |
| ? Performing Calculations with Mathematical Formulas | |
| |
| |
| ? Excel's Built-in Functions | |
| |
| |
| ? Troubleshooting | |
| |
| |
| Worksheet Design | |
| |
| |
| ? Worksheet Appearance | |
| |
| |
| ? Font Selection | |
| |
| |
| ? Enhancements | |
| |
| |
| ? Using Styles | |
| |
| |
| ? Troubleshooting | |
| |
| |
| Advanced Formula Construction | |
| |
| |
| ? Linking to Other Workbooks | |
| |
| |
| ? Absolute and Relative References | |
| |
| |
| ? Array Formulas | |
| |
| |
| ? Other Advanced Formula Considerations | |
| |
| |
| Excel Workbooks | |
| |
| |
| ? Grouping Multiple Sheets | |
| |
| |
| ? Creating Formulas while Using Multiple Sheets | |
| |
| |
| ? Formatting Multiple Sheets | |
| |
| |
| ? Troubleshooting | |
| |
| |
| Working with Ranges | |
| |
| |
| ? Naming Ranges | |
| |
| |
| ? Using Named Ranges | |
| |
| |
| ? Troubleshooting | |
| |
| |
| Charting Techniques | |
| |
| |
| ? Creating Charts | |
| |
| |
| ? Enhancing Charts | |
| |
| |
| ? Troubleshooting | |
| |
| |
| Printing and Viewing Results | |
| |
| |
| ? Printing Worksheets | |
| |
| |
| ? Printing Charts | |
| |
| |
| ? Other Printing Considerations | |
| |
| |
| Data Manipulation | |
| |
| |
| ? Creating a Data List | |
| |
| |
| ? Searching for Data | |
| |
| |
| Customizing Excel | |
| |
| |
| ? Changing Excel's Default Features | |
| |
| |
| ? Creating and Changing Menus | |
| |
| |
| ? Customizing the Office Assistant | |
| |
| |
| PivotTables in Excel | |
| |
| |
| ? Creating PivotTables | |
| |
| |
| ? Controlling the Display of PivotTables | |
| |
| |
| ? Working with PivotTables | |
| |
| |
| Using Forms in Excel | |
| |
| |
| ? Creating Forms | |
| |
| |
| ? Using Forms | |
| |
| |
| ? Validating | |
| |
| |
| Excel Macros | |
| |
| |
| ? Recording Macros | |
| |
| |
| ? Debugging Macros | |
| |
| |
| ? Working with Visual Basic | |
| |
| |
| Excel and Other Applications | |
| |
| |
| ? Excel and Other Office Applications | |
| |
| |
| ? OLE Objects | |
| |
| |
| ? Linking to (and from) Other Applications | |
| |
| |
| Miscellaneous Excel Topics | |
| |
| |
| ? Excel Odds and Ends | |
| |
| |
| Index | |