Excel 2010 just the steps for dummies

Excel® 2010 Just the Steps™ For Dummies®......Page 1
  Why You Need This Book......Page 9
  Get Ready To.........Page 10
 Part I: Putting Excel to Work......Page 11
  Chapter 1: Working with Excel Files......Page 13
   Open and Explore Excel......Page 14
   Close Excel......Page 15
   Change Status Bar Indicators......Page 16
   Save a Workbook......Page 17
   Open an Existing Excel File......Page 18
   Delete a File......Page 19
   Specify Workbook Properties......Page 20
  Chapter 2: Entering Spreadsheet Data......Page 21
   Change the Active Cell......Page 22
   Select Multiple Cells......Page 23
   Enter Cell Data......Page 24
   Edit or Delete Cell Data......Page 25
   Move Data......Page 26
   Transpose Data......Page 27
   Extend a Series with AutoFill......Page 28
   Insert Cells......Page 29
   Delete Cells......Page 30
   Use Named Ranges......Page 31
   Manage Range Names......Page 32
   Validate Data Entry......Page 33
   Locate Cells with Data Validation......Page 34
  Chapter 3: Building Formulas......Page 35
   Create Simple Formulas with Operators......Page 36
   Create Compound Formulas......Page 37
   Find an Average Value......Page 38
   Edit a Formula......Page 39
   Copy Values with Paste Special......Page 40
   Summarize an Array......Page 41
   Troubleshoot Formula Errors......Page 42
   Identify Formula Precedents and Dependents......Page 44
  Chapter 4: Using Excel Functions......Page 45
   Build a Formula with the Function Wizard......Page 46
   Manually Type an IF Function......Page 47
   Change the Cell Text Case......Page 48
   Convert a Text Date to a Date Value......Page 49
   Round Values with Math Functions......Page 50
   Locate Data with Lookup Functions......Page 51
   Remove Unwanted Spaces with the TRIM Function......Page 52
   Estimate the Future Value of an Investment......Page 53
   Calculate a Loan Payment......Page 54
  Chapter 5: Protecting Excel Data......Page 55
   Make a File Read-Only......Page 56
   Mark a Workbook as Final......Page 57
   Unlock Cells......Page 58
   Protect Worksheets......Page 59
   Restrict User Data Entry......Page 60
   Inspect for Private Information......Page 61
   Assign a File Password......Page 62
 Part II: Sprucing Up Your Spreadsheets......Page 63
  Chapter 6: Formatting Cells......Page 65
   Format Values......Page 66
   Adjust Column Width......Page 67
   Change Row Height......Page 68
   Align Data Horizontally and Vertically......Page 69
   Change Font Color......Page 70
   Apply Cell Background Colors......Page 71
   Rotate Text......Page 72
  Chapter 7: Applying Additional Formatting Options......Page 73
   Change the Default Font......Page 74
   Work with Date Formats......Page 75
   Format Telephone, Zip Code, and Social Security Numbers......Page 76
   Indent Data in Cells......Page 77
   Format Cells as a Table......Page 78
   Specify Conditional Formatting......Page 79
   Add Data Visualizations......Page 80
  Chapter 8: Designing with Graphics......Page 81
   Illustrate with Arrows......Page 82
   Insert Saved Images......Page 83
   Use Picture Styles......Page 84
   Change a Picture......Page 85
   Annotate with Text Boxes......Page 86
   Add Clip Art......Page 87
   Create WordArt......Page 88
   Manipulate Graphics......Page 89
   Flip an Object......Page 90
   Align Multiple Graphics......Page 91
   Group Objects......Page 92
  Chapter 9: Managing Workbooks......Page 93
   Delete Worksheets......Page 94
   Copy Worksheets......Page 95
   Move or Copy Worksheets to a Different Workbook......Page 96
   Change Worksheet Tab Colors......Page 97
   Generate References to Other Worksheets......Page 98
   Cross-Reference Other Workbooks......Page 99
   Insert a Hyperlink......Page 100
 Part III: Viewing Data in Different Ways......Page 101
  Chapter 10: Changing Worksheet Views......Page 103
   Use the Zoom Controls......Page 104
   Change Worksheet Views......Page 105
   Freeze Worksheet Titles......Page 106
   Arrange Windows......Page 107
   Save as a Template......Page 108
   Create a Workbook from an Existing File......Page 109
   Monitor Cells in the Watch Window......Page 110
  Chapter 11: Sorting Data......Page 111
   Use the Ribbon to Sort......Page 112
   Work with the Sort Command......Page 113
   Sort by Multiple Criteria......Page 114
   Create a Customized List......Page 115
   Remove Duplicate Records......Page 116
   Sort by Cell Format......Page 117
   Search for Data......Page 118
   Locate Cells Based on Format......Page 119
   Use the Replace Command......Page 120
  Chapter 12: Creating Charts......Page 121
   Add Sparkline Markers......Page 122
   Edit Sparkline Data......Page 123
   Create a Basic Chart......Page 124
   Insert a Chart......Page 126
   Adjust the Chart Location......Page 128
   Display a Chart Title......Page 129
   Add a Data Table......Page 130
   Select a Chart Color Style......Page 131
   Change Axis Options......Page 132
   Enhance a 3-D Chart......Page 133
   Adjust Chart Data......Page 134
  Chapter 13: Printing Workbooks......Page 135
   Set a Specific Area to Print......Page 136
   Make Worksheets Fit Better on a Page......Page 137
   Specify Repeating Rows and Columns......Page 138
   Preview before Printing......Page 139
   View Other Header and Footer Options......Page 140
   Create a Custom Header or Footer......Page 141
   E-Mail a Workbook......Page 142
  Chapter 14: Saving Time with Excel Tools......Page 143
   Set Excel General Options......Page 144
   Manage AutoCorrect......Page 145
   Examine Advanced Editing Options......Page 146
   Customize the Ribbon......Page 147
   Find the Right Word with the Thesaurus......Page 148
   Check Your Spelling......Page 149
   Work with Assistance Tags......Page 150
   Split Data into Multiple Columns......Page 151
   Merge Columns......Page 152
 Part IV: Analyzing Data with Excel......Page 153
  Chapter 15: Working with Outlines......Page 155
   Create a Data Entry Screen......Page 156
   Manage Records through the Form Screen......Page 157
   Generate a Subtotal......Page 158
   Control Individual Subtotals......Page 159
   Create Multiple Subtotals......Page 160
   Remove Subtotals......Page 161
   Use AutoOutline......Page 162
   Remove Items from a Group......Page 163
   Consolidate Data by Category......Page 164
  Chapter 16: Filtering Data......Page 165
   Create an AutoFilter......Page 166
   Search for Blank or Non-Blank Cells......Page 167
   Perform a Secondary Filter Selection......Page 168
   Use a Comparison Filter for Text......Page 169
   Use a Comparison Filter for Numbers......Page 170
   Filter for the Above or Below Average Values......Page 171
   Filter by Color......Page 172
  Chapter 17: Creating PivotTables......Page 173
   Create a PivotTable......Page 174
   Refresh PivotTable Data......Page 177
   Change the Calculation Type......Page 178
   Format PivotTable Values......Page 179
   Generate Multilevel Totals......Page 180
   Group Data......Page 181
   Add Your Own Calculations......Page 182
   Rename a PivotTable......Page 183
   Reorder PivotTable Fields......Page 184
   Add a PivotTable Slicer......Page 185
   Create a PivotChart......Page 186
  Chapter 18: Building Simple Macros......Page 187
   Record a Macro......Page 188
   Open a Macro-Enabled Workbook......Page 189
   Run a Macro......Page 190
   Check Macro Security Level......Page 191
   Delete a Macro......Page 192
 Part V: Utilizing Excel with Other People and Applications......Page 193
  Chapter 19: Collaborating in Excel......Page 195
   Edit Comments......Page 196
   Share a Workbook......Page 197
   Track Changes......Page 198
   Accept or Reject Changes......Page 199
   Merge Workbooks......Page 200
  Chapter 20: Integrating Excel into Word......Page 201
   Copy Excel Cells into Word......Page 202
   Edit an Inserted Worksheet......Page 203
   Link an Excel Worksheet into Word......Page 204
   Copy a Word Table to Excel......Page 205
   Create a Word Mail Merge Form Letter Using an Excel List......Page 206
   Make Mailing Labels with Word and Excel......Page 208
  Chapter 21: Blending Excel and PowerPoint......Page 209
   Copy Excel Cells into a PowerPoint Slide......Page 210
   Drag an Excel Table into a PowerPoint Slide......Page 211
   Insert a Saved Excel Worksheet or Chart onto a PowerPoint Slide......Page 212
   Link an Excel Worksheet into a PowerPoint Slide......Page 213
   Add an Excel Chart to a PowerPoint Slide......Page 214
  Chapter 22: Using Excel with Access......Page 215
   Import Data from Excel to an Access Table......Page 216
   Link an Excel Worksheet to an Access Database......Page 219
   Update an Access-to-Excel Linked Table......Page 220
 Part VI: Practical Applications for Excel......Page 221
  Chapter 23: Creating a Commission Calculator......Page 223
   Create the Commission Table......Page 224
   Total Sales with the SUMIF Function......Page 225
   Calculate Commission with a Nested IF Statement......Page 226
   Create Totals......Page 227
   Protect Your Work......Page 228
  Chapter 24: Tracking Medical Expenses......Page 229
   Create Totaling Formulas......Page 230
   Specify Data Validation......Page 231
   Determine Print Settings......Page 232
   Duplicate the Worksheet for Other Family Members......Page 233
   Create a Totals Worksheet......Page 234
 Index......Page 235