| |  | Copyright |
| | | About the Author |
| | | Acknowledgments |
| | | We Want to Hear from You! |
| | | Introduction |
| | | | Conventions Used in This Book |
| | | Part I. Excel Basics |
| | | | Hour 1. Getting Started |
| | | | What Is Excel? |
| | | | Planning Strategies for Excel Worksheets |
| | | | Starting Excel |
| | | | Looking at the Excel Screen |
| | | | Working with Toolbars |
| | | | Using Excel Menus and Dialog Boxes |
| | | | Working with Dialog Boxes |
| | | | Examining the Task Pane |
| | | | Getting the Most Out of Help |
| | | | Moving Within a Workbook |
| | | | Summary |
| | | | Q&A |
| | | | Hour 2. Entering Data |
| | | | Typing Data in a Cell |
| | | | Entering Labels |
| | | | Automating Your Work |
| | | | Creating a Simple Spreadsheet |
| | | | Entering Values |
| | | | Adding Dates and Times |
| | | | Copying from Cell to Cell |
| | | | Making Changes to the Worksheet |
| | | | Inserting and Deleting Cells |
| | | | Working with Rows and Columns |
| | | | Summary |
| | | | Q&A |
| | | | Hour 3. Organizing Your Files |
| | | | Saving Your Workbook |
| | | | Saving Your Work for the First Time |
| | | | Saving Your Work Later |
| | | | Understanding Excel Filenames |
| | | | Protecting Your Work with AutoRecover |
| | | | Saving an Existing Workbook with a New Name |
| | | | Other Save Options |
| | | | Rearranging Your Files |
| | | | Summary |
| | | | Q&A |
| | | | Hour 4. Managing Your Files and Workbooks |
| | | | Creating a Blank Workbook |
| | | | Opening an Existing Workbook |
| | | | Making Use of the Getting Started Task Pane |
| | | | Searching for the Right File |
| | | | Working with Workbooks and Worksheets |
| | | | Getting a View of the Workbook |
| | | | Using Ranges |
| | | | Changing Worksheet Views |
| | | | Workbook and Worksheet Navigation Tools |
| | | | Summary |
| | | | Q&A |
| | | | Hour 5. Letting Excel Do the Math |
| | | | Why Use Formulas? |
| | | | How Formulas Work |
| | | | Creating a Simple Formula |
| | | | Referencing Cells |
| | | | Using AutoSum |
| | | | Using Range Names in Formulas |
| | | | Using Relative and Absolute Addressing |
| | | | Copying Formulas |
| | | | Troubleshooting Formula Errors |
| | | | Summary |
| | | | Q&A |
| | | | Hour 6. Using Excel Templates |
| | | | What Is a Template? |
| | | | Exploring Excel Templates |
| | | | Creating Your Own Template |
| | | | Saving a Worksheet as a Template |
| | | | Summary |
| | | | Q&A |
| | | | Hour 7. Printing Your Workbook |
| | | | The Value of Hard Copy |
| | | | Checking Your Spelling Before You Print |
| | | | Setting Up Your Page |
| | | | Changing the Orientation and Paper Size |
| | | | Adding Headers and Footers |
| | | | Choosing What to Print |
| | | | Controlling Where Pages Break |
| | | | Printing What You Want |
| | | | Summary |
| | | | Q&A |
| | | Part II. Dress Up Your Work |
| | | | Hour 8. Changing the Appearance of Text |
| | | | Formatting Your Text |
| | | | Treating Numbers Like Text |
| | | | Using Fonts |
| | | | Changing Cell Alignment |
| | | | Rotating Cell Entries |
| | | | Centering a Heading |
| | | | Controlling the Flow of Text |
| | | | Copying Formatting with the Format Painter |
| | | | Removing Formatting |
| | | | Adjusting Column Width |
| | | | Altering Row Height |
| | | | Finding Data |
| | | | Replacing Data |
| | | | Working with Comments |
| | | | Summary |
| | | | Q&A |
| | | | Hour 9. Changing the Look of Values |
| | | | What Formats Are Available? |
| | | | Choosing a Number Style |
| | | | Working with Decimal Places |
| | | | Designing Custom Numeric Formats |
| | | | Formatting Conditionally |
| | | | Hiding Zeros |
| | | | Working with Dates |
| | | | Summary |
| | | | Q&A |
| | | | Hour 10. Adding Borders, Colors, and Fills |
| | | | Have It Your Way |
| | | | Changing the Color of Cell Entries |
| | | | Adding Borders to Cells and Ranges |
| | | | Working with Fills, Shading, and Color |
| | | | Formatting with AutoFormat |
| | | | Summary |
| | | | Q&A |
| | | Part III. Interactive Data Makes Your Worksheet Come Alive |
| | | | Hour 11. Working with Graphics Objects |
| | | | What Is a Graphics Object? |
| | | | Why Use Graphics? |
| | | | Using the Drawing Toolbar |
| | | | Adding Clip Art |
| | | | Adding Special Effects with WordArt |
| | | | Manipulating Graphics Objects |
| | | | Combining Multiple Objects |
| | | | Deleting Graphics Objects |
| | | | Summary |
| | | | Q&A |
| | | | Hour 12. Adding a Chart |
| | | | Why Use a Chart? |
| | | | Chart Elements |
| | | | Types of Charts |
| | | | Creating Charts with the Chart Wizard |
| | | | Working with Charts |
| | | | Chart Formatting Techniques |
| | | | Creating a Pie Chart |
| | | | Summary |
| | | | Q&A |
| | | | Hour 13. Other Types of Charts |
| | | | Creating Other Chart Types |
| | | | Creating an Excel Diagram |
| | | | Summary |
| | | | Q&A |
| | | Part IV. Advanced Excel Techniques |
| | | | Hour 14. Working Smarter |
| | | | Working with Multiple Workbooks |
| | | | Working with Formulas That Reference Other Workbooks and Worksheets |
| | | | Creating Links Between Worksheets and Workbooks |
| | | | Customizing Excel |
| | | | Protecting Your Data |
| | | | Protecting Your Files |
| | | | Saving Your Workspace |
| | | | Using Excel Add-ins |
| | | | Summary |
| | | | Q&A |
| | | | Hour 15. Using Functions |
| | | | Advantages of Excel Functions |
| | | | Using the Insert Function Dialog Box and Formula Palette |
| | | | Financial Functions |
| | | | Date and Time Functions |
| | | | DATEVALUE |
| | | | Logical Functions |
| | | | How to Use Lookup Functions |
| | | | Summary |
| | | | Q&A |
| | | | Hour 16. Auditing and Validating Your Work |
| | | | Auditing Workbooks |
| | | | Validating Input |
| | | | Using Named Constants and Formulas |
| | | | Defining Label Ranges |
| | | | Summary |
| | | | Q&A |
| | | | Hour 17. Analyzing Your Data |
| | | | Using the Scenario Manager |
| | | | Using the Goal Seek Tool |
| | | | Summary |
| | | | Q&A |
| | | | Hour 18. Working with Pivot Tables |
| | | | What Is a Pivot Table? |
| | | | Learning the PivotTable Lingo |
| | | | Building a Pivot Table |
| | | | Modifying a Pivot Table |
| | | | Working with Pivot Table Reports |
| | | | Building a PivotChart |
| | | | Creating a Chart from PivotTable Report Data |
| | | | Summary |
| | | | Q&A |
| | | | Hour 19. Integrating Excel with Other Office Applications |
| | | | Using Objects in Excel |
| | | | Inserting Objects |
| | | | Using Hyperlinks with Other Office Documents |
| | | | Sending Your Document Via Email with Outlook |
| | | | Summary |
| | | | Q&A |
| | | | Hour 20. Automating Tasks with Macros and Smart Tags |
| | | | What Is a Macro? |
| | | | Creating a Macro |
| | | | Running the Macro |
| | | | Fixing Macro Errors |
| | | | Attaching a Macro to a Toolbar |
| | | | Using a Macro in Other Workbooks |
| | | | Understanding Macro Viruses |
| | | | Working with Smart Tags |
| | | | Summary |
| | | | Q&A |
| | | Part V. Creating and Using Databases in Excel |
| | | | Hour 21. Building an Excel Database |
| | | | Basic Database Concepts |
| | | | Starting with a Plan |
| | | | Creating a Database |
| | | | Entering and Adding Data |
| | | | Searching for Data |
| | | | Saving the Database |
| | | | Summary |
| | | | Q&A |
| | | | Hour 22. Working with Your Database |
| | | | Working with Subtotals |
| | | | Using Advanced AutoFilter Functions |
| | | | Setting a Criteria Range |
| | | | Retrieving Data with the Query Wizard |
| | | | Choosing a Data Source |
| | | | Saving Data Queries |
| | | | Summary |
| | | | Q&A |
| | | Part VI. At the Office and on the Internet/Intranet |
| | | | Hour 23. Sharing Your Work with Your Colleagues |
| | | | What Is a Network? |
| | | | Sharing Workbooks |
| | | | Setting Up a Shared Workbook |
| | | | Opening a Shared Workbook |
| | | | Tracking Changes in Your Worksheet |
| | | | Summary |
| | | | Q&A |
| | | | Hour 24. Worksheets and the Web |
| | | | What Is the Internet? |
| | | | Using Internet Explorer 6.0 |
| | | | Searching on the Web |
| | | | Adding a Hyperlink to a Worksheet |
| | | | Saving Excel Documents to the Web |
| | | | Posting Your Worksheet to the Web |
| | | | Summary |
| | | | Q&A |
| | | Index |
