Introduction xCHAPTER 1 WORKING WITH THE EXCEL USER INTERFACE 2The Ribbon User Interface 2The Anatomy of the Ribbon Interface 3Familiarizing Yourself with the Ribbon Tabs 4Understanding Contextual Tabs 6Understanding Workbooks and Worksheets 7Customizing the Quick Access Toolbar 8Adding Commands to the Quick Access Toolbar 9Adding Hidden Commands to the Quick Access Toolbar 10 CHAPTER 2 MANAGING WORKBOOKS AND WORKSHEETS 12Opening an Excel Workbook 14Closing an Excel Workbook 15Saving a Workbook 16Switching Between Open Workbooks 17Switching Between Worksheets 18Viewing Multiple Workbooks 19Inserting and Deleting Worksheets 20Renaming Worksheets 21Coloring Worksheet Tabs 22Moving Worksheets Within a Workbook 23Copying Worksheets Between Workbooks 24Password Protect a Workbook 25Protecting a Worksheet 26 CHAPTER 3 ENTERING AND MANAGING DATA 28Entering Data 30Editing and Deleting Existing Data 31Zooming Into Your Data 32Undoing and Redoing Changes 33Copying and Pasting Data 34Freezing Rows and Columns 36Splitting a Worksheet 37Inserting Cells 38Deleting Cells 39Inserting and Deleting Rows 40Inserting and Deleting Columns 41Moving Data 42Finding Data 43Replacing Data 44Applying a Data Filter 45Sorting Data 46Adding and Managing Cell Comments 48 CHAPTER 4 FORMATTING WORKSHEET DATA 50Changing the Font and Font Size 52Changing Column Width 53Changing the Color of the Cell Background and Cell Text 54Formatting the Display of Numeric Data 55Using a General Format 56Using a Number Format 57Using a Currency Format 58Using a Date Format 59Using a Text Format 60Applying Bold, Italic, and Underline 61Using Merge and Center on Cells 62Changing Horizontal Data Alignment 63Changing Row Height 64Changing Vertical Data Alignment 65Changing Cell Orientation 66Wrapping Data in a Cell 67Changing Borders 68Indenting Entries in a Cell 69Clearing Formatting 70Hiding and Unhiding Rows 71Hiding and Unhiding Columns 72Hiding and Unhiding a Worksheet 73Using Format As Table 74Copying Formatting 75Creating and Applying a Formatting Style 76Using Conditional Formatting 78 CHAPTER 5 WORKING WITH FORMULAS AND FUNCTIONS 80Using AutoSum (SUM) 82Finding a Cell Average (AVERAGE) 83Finding the Largest Cell Amount (MAX) 84Finding the Smallest Cell Amount (MIN) 85Counting the Number of Cells (COUNT) 86Entering a Formula 87Editing a Formula or Function 88Copying a Formula 89Assigning Names to a Cell or Range 90Referencing Names in a Function 91Using Functions Across Worksheets 92Using Auto-Calculate 94Finding Functions 95Calculating a Loan Payment (PMT) 96Performing a Logical Test Function (IF) 98Conditionally Summing a Range (SUMIF) 100Finding the Future Value of an Investment (FV) 102Fixing the #### Error 104Fixing the #DIV/0! Error 105Fixing the #NAME? Error 106Fixing the #VALUE! Error 107Recognizing the #REF! Error 108Recognizing Circular References 109Checking for Formula References (Precedents) 110Checking for Cell References (Dependents) 111 CHAPTER 6 WORKING WITH CHARTS 112The Chart Tools Contextual Tab 113Creating a Chart 114Changing the Chart Type 116Altering the Source Data Range 117Altering Chart Options 118Formatting the Plot Area 120Formatting the Chart Area 121Formatting the Axis Scale 122Altering the Original Data 123Adding Data to Charts 124Adding a Legend 125 CHAPTER 7 WORKING WITH GRAPHICS 126Using Drawing Tools 128Inserting Clip Art 130Inserting a Picture from File 131Using AutoShapes 132Inserting WordArt 133Using Smart Art in Excel 134Inserting a Diagram 135Inserting an Object 136Selecting an Object 137Formatting an Object 138Moving an Object 139Resizing an Object 140Deleting an Object 141 CHAPTER 8 PRINTING IN EXCEL 142Using Print Preview 144Setting the Print Area 146Adjusting Page Margins 148Inserting Page Breaks 150Working in Page Break Preview Mode 152Printing a Worksheet on One Page 154Printing in Portrait or Landscape Orientation 155Centering a Worksheet on a Page 156Printing Gridlines and Row/Column Headers 157Printing Cell Comments 158Printing Cell Error Indicators 159Printing Repeating Row and Column Titles 160Adding Headers and Footers 161Printing Worksheets 162 CHAPTER 9 WORKING WITH EXCEL PIVOT TABLES 164Creating a Pivot Table 166Rearranging a Pivot Table 168Refreshing Pivot Table Data 169Adding a Report Filter 170Adding Pivot Table Data 172Changing the Pivot Table Layout 173Customizing Field Names 174Applying Numeric Formats to Data Fields 175Changing Summary Calculations 176Showing and Hiding Data Items 177Sorting Your Pivot Table 178 APPENDIX EXCEL SHORTCUT KEYS 180INDEX 184