My Excel 2013

Hiding and Unhiding Rows 76 Hiding and Unhiding Columns 78 Hiding and Unhiding a Worksheet 80 Using Format as Table 81 Copying Formatting 82 Creating and Applying a Formatting Style 84 Using Conditional Formatting 85 Chapter 5 Working with Formulas and Functions 89 Using AutoSum Calculations 89 Find a Cell Average (AVERAGE) 91 Find the Largest Cell Amount (MAX) 92 Find the Smallest Cell Amount (MIN) 93 Count the Number of Cells (COUNT) 94 Entering a Formula 95 Editing a Formula or Function 96 Copying a Formula 97 Assigning Names to a Cell or Range 99 Referencing Names in a Function 100 Using Functions Across Worksheets 101 Using Auto-Calculate 104 Finding and Using Excel Functions 105 Calculate a Loan Payment (PMT) 107 Perform a Logical Test Function (IF) 110 Conditionally Sum a Range (SUMIF) 113 Find the Future Value of an Investment (FV) 115 Recognizing and Fixing Errors 118 Fix the #DIV/0! Error 119 Fix the #NAME? Error 120 Fix the #VALUE! Error 122 Recognize the #REF! Error 124 Recognizing Circular References 126 Checking for Formula References (PRECEDENTS) 128 Checking for Cell References (DEPENDENTS) 130 Chapter 6 Working with Charts 133 Creating a Chart 134 Changing the Chart Type 136 Altering the Source Data Range 137 Altering Chart Options 138 Formatting the Plot Area 142 Formatting the Chart Area 144 Formatting the Axis Scale 146 Altering the Original Data 147 Adding Data to Charts 149 Adding a Legend 150 Chapter 7 Working with Graphics 153 Using Drawing Tools 153 Inserting Clip Art 156 Inserting a Picture from File 157 Using AutoShapes 158 Inserting WordArt 160 Using Smart Art in Excel 161 Inserting a Diagram 163 Inserting Objects 164 Working with Inserted Objects 166 Format an Object 167 Move an Object 168 Resize an Object 170 Delete an Object 171 Chapter 8 Printing in Excel 173 Using Print Preview 174 Setting the Print Area 175 Adjusting Page Margins 177 Inserting Page Breaks 178 Working in Page Break Preview Mode 181 Printing a Worksheet on One Page 182 Printing in Portrait or Landscape Orientation 184 Centering a Worksheet on a Page 185 Printing Gridlines and Row/Column Headers 186 Printing Cell Comments 187 Printing Cell Error Indicators 188 Printing Repeating Row and Column Titles 189 Adding Headers and Footers 190 Printing Your Worksheets 191 Chapter 9 Working with Pivot Tables 195 Creating a Pivot Table 196 Rearranging a Pivot Table 199 Adding a Report Filter 201 Refreshing Pivot Table Data 203 Adding Pivot Table Data 204 Customizing Field Names 206 Applying Numeric Formats to Data Fields 207 Changing Summary Calculations 209 Showing and Hiding Data Items 210 Sorting Your Pivot Table 211 Chapter 10 Using SkyDrive to Store and Share Excel Files 215 Signing Up For SkyDrive 215 Signing into SkyDrive 217 Saving a Workbook to SkyDrive 218 Opening a SkyDrive Workbook 220 Downloading a Workbook from SkyDrive 222 Sharing Your SkyDrive Workbooks with Others 223 Managing SkyDrive Workbooks 224 Appendix A Excel Shortcut Keys 227 Using the Excel Shortcut Key Reference Table 227 Index 231