Table of Contents -- Introduction -- PART I: JUST THE BASICS -- Chapter 1 Creating a Basic Excel Worksheet -- Exploring Excel -- Moving Around the Excel Screen -- Entering Excel Data -- Selecting Cells on a Spreadsheet -- Editing a Worksheet -- Moving and Copying Data -- Working with Range Names -- Chapter 2 Working with Formulas -- Creating Formulas -- Editing Formulas -- Controlling Recalculation -- Copying Formulas -- Creating an Absolute or Mixed Formula Reference -- Chapter 3 Using Excel Functions -- Considering Form versus Function -- Understanding Function Syntax -- Creating a Total with the SUM Function -- Calculating Results Without Entering a Formula -- Nesting Functions -- Using Other Functions -- Chapter 4 Troubleshooting Formula Errors -- Displaying Formulas in a Worksheet -- Understanding How Excel Handles Formula Errors -- Telling Excel Which Errors to Flag -- Telling Excel to Flag Result Cells with an Error -- Checking for Errors Automatically One at a Time -- Controlling Whether Errors Print -- Chapter 5 Making the Worksheet Look Good -- Adjusting Columns and Rows -- Formatting Cell Content -- Applying Numeric Formatting -- Applying Conditional Formatting -- Applying Office Themes and Layouts -- PART II: HANDLING LARGER WORKBOOKS -- Chapter 6 Managing Large Amounts of Excel Data -- Working with Multiple Worksheets -- Using Find and Replace -- Managing Worksheet Views -- Chapter 7 Sorting Data -- Sorting from the Ribbon -- Working with the Sort Command -- Creating a Subtotal Report -- Creating Manual Groups from Sorted Rows -- Chapter 8 Filtering Data -- Creating an AutoFilter -- Performing a Secondary Filter Selection -- Exploring Special Filters -- Creating Custom Filters -- Using Formulas with Filtered Data -- Chapter 9 Preparing to Print -- Setting the Print Area -- Previewing Your Worksheet -- Adjusting Page Layout.

Switching Worksheet Views -- Adding Headers and Footers -- Inserting a Watermark -- Chapter 10 Printing and Other Output Formats -- Printing Your Workbooks -- Handling Special Printing Needs -- Printing Charts -- Printing a Draft -- Changing Printers -- Printing Without Opening Excel -- Choosing an Alternative to Printing -- Printing from the Quick Access Toolbar -- PART III: WORKING WITH GRAPHICS -- Chapter 11 Generating Excel Charts -- Creating a Basic Chart -- Changing the Chart Options -- Chapter 12 Inserting Illustrations -- Designing with Illustrations -- Formatting Illustrations -- Working with Shapes -- Creating SmartArt -- Using Screenshots -- Adding WordArt -- PART IV: USING EXCEL TOOLS -- Chapter 13 Setting Security Options -- Inspecting for Private Information -- Hiding Data -- Protecting Data -- Marking a Workbook as Final -- Chapter 14 Collaborating with Others -- Considering Your Collaboration Options -- Using Comments in Collaboration -- Validating Excel Worksheet Content -- Importing and Exporting Your Excel Content -- Chapter 15 Using PivotTables -- Creating a PivotTable -- Using the PivotTable Tools -- Sorting and Filtering PivotTable Data -- Formatting Your PivotTable -- Creating a PivotChart -- Index -- A -- B -- C -- D -- E -- F -- G -- H -- I -- K -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V -- W -- X-Y -- Z.