Excel 2003 Just the Steps For Dummies (For Dummies (Computer Tech))

easy Steps For Creating Spreadsheets You Can Really Use simple Steps... ...for Great Results use Autooutline choose Data Group And Outline Autooutline. Figure 11-9 Illustrates A Worksheet With Outline Headings For Both Rows And Columns. Row Outline Symbols Are At The Top Of The Worksheet. autooutline Works Best If The Worksheet Has Summary Formulas That Reference Cells In The Detail Cells. The Summary Formulas Must Be Adjacent To The Detail. to Expand The Outline, Click The Show Detailbuttons To The Left Of The Rows Or Above Thecolumn Headings. (see Figure 11-10.) to Collapse The Outline, Click The Hide Buttonsto The Left Of The Rows Or Above The Columnheadings. to Remove The Autooutline, Choose Data Group And Outline Clear Outline. get Ready To format Cells And Data build Formulas And Functions save Time With Excel Tools add Color Graphics Toyour Spreadsheets analyze Your Data create Charts And Pivottables About the Author 5 Contents at a Glance 7 Introduction 9 About This Book 9 Why You Need This Book 9 How This Book Is Organized 9 Part I: Putting Excel to Work 11 Chapter 1: Working with Excel Files 13 Open and Close Excel 14 Create a New Excel File 15 Save a Workbook 15 Open an Existing Excel File 16 Delete an Existing Excel File 16 Use the Office Assistant 17 Separate the Excel Toolbars 18 Display Different Toolbars 18 Specify Workbook Properties 19 Search for a File by Properties 20 Save or Open Files in Different Formats 20 Chapter 2: Entering Spreadsheet Data 21 Change the Active Cell 22 Enter Data 23 Undo Data Entry 24 Edit or Delete Cell Data 24 Select Multiple Cells 25 Copy and Paste Data 26 Name a Range of Cells 26 Extend a Series with AutoFill 27 Locate Cells with Data Validation 27 Validate Data Entry 28 Chapter 3: Building Formulas 29 Create Simple Formulas with Operators 30 Create Compound Formulas 31 Add Numbers with AutoSum 32 Find an Average Value 32 Copy Formulas with AutoFill 33 Edit a Formula 33 Define an Absolute Formula 34 Copy Values Using Paste Special 34 Build a Formula with the Function Wizard 35 Generate an IF Statement Formula 36 Troubleshoot Formula Errors 37 Audit Formulas 38 Part II: Sprucing Up Your Spreadsheet 39 Chapter 4: Formatting Cells and Data 41 Align Data 42 Format Values 42 Indent Data in Cells 43 Create a Title by Merging Cells 43 Select Font Attributes 44 Wrap Text in a Cell 44 Rotate Text 45 Work with Date Formats 45 Adjust Column Width 46 Change Row Height 47 Copy Formatting 48 Use AutoFormats 48 Manage Formatting Styles 49 Chapter 5: Adding Color and Graphics 51 Use Font Color 52 Apply Shading to Cells 52 Place Borders Around Cells 53 Specify Conditional Formatting 54 Illustrate with Arrows 55 Annotate with Text Boxes 56 Draw AutoShapes 57 Shade Your Drawings 57 Make Objects 3-Dimensional 58 Insert Saved Images 58 Add Clip Art 59 Manipulate Graphics 60 Chapter 6: Working with Workbooks 61 Insert Additional Worksheets 62 Delete Worksheets 62 Copy Worksheets 63 Rename Worksheets 63 Change Worksheet Tab Colors 64 Hide and Unhide Worksheets 64 Hide Rows or Columns 65 Redisplay Rows or Columns 65 Unlock Cells 66 Relock Cells 66 Protect Worksheets 67 Create File Passwords 68 Generate a Reference to Another Worksheet 69 Include a Reference in a Formula 69 Cross-Reference Other Workbooks 70 Insert a Hyperlink 71 Part III: Viewing Data in Different Ways 73 Chapter 7: Changing Worksheet Views 75 Zoom In or Out 76 Split the Excel Screen 76 Freeze Worksheet Titles 77 Hide an Open Workbook 78 Arrange Windows 78 Compare Spreadsheets 79 View Excel in Full Screen View 79 Add Cell Comments 80 Work with Cell Comments 80 Save as a Template 81 Open a Template 81 Customize Excel Viewing Options 82 Chapter 8: Sorting Data 83 Use the Toolbar to Sort 84 Work with the Sort Command 85 Sort by Multiple Criteria 86 Create a Customized List 87 Sort by Day, Month, or Custom List 88 Search for Data 89 Find All Data Occurrences 90 Locate Cells Based on Format 90 Use the Replace Command 91 Chapter 9: Creating Charts with Excel 93 Create a Basic Chart 94 Work with the Chart Wizard 96 Change the Chart Type 98 Include Titles and Labels 99 Customize the Chart Legend 99 Modify Chart Attributes 100 Add Graphic Images to a Series 100 Change a Chart Location 101 Add a Data Table 101 Enhance a 3-D Chart 102 Add or Delete Data 103 Format the Value Axis 103 Create an Organization Chart 104 Chapter 10: Printing Workbooks 105 Spell Check 106 Preview Before Printing 107 Add a Manual Page Break 108 Set a Specific Area to Print 108 Adjust the Paper Size and Orientation 109 Make Worksheets Fit Better on a Page 109 Set Page Margins 110 Add a Standard Header or Footer 110 Create a Custom Header or Footer 111 Specify Repeating Rows and Columns 112 Print Gridlines and Column Headings 112 Print Worksheets and Charts 113 E-Mail a Workbook 113 Part IV: Analyzing Data with Excel 115 Chapter 11: Working with Outlines 117 Generate a Subtotal 118 Collapse Subtotal Headings 119 Control Individual Subtotals 119 Create Multiple Subtotals 120 Copy Subtotals 121 Remove Subtotals 121 Use AutoOutline 122 Form an Outline Group 123 Remove Items from a Group 123 Chapter 12: Filtering Data 125 Create a Data Entry Screen 126 Filter Data with AutoFilter 127 Perform a Secondary Filter Selection 128 Select Only the Top 10 129 Customize an AutoFilter 130 Find Multiple Criteria 131 Use Advanced Filtering 132 Chapter 13: Creating Pivot Tables 135 Create a PivotTable 136 Select and Manage Pivot Data 139 Change the Calculation Type 140 AutoFormat PivotTables 140 Apply Page Fields 141 Generate Separate PivotTables 141 Rename a Field 142 Format PivotTable Values 142 Generate Multilevel Totals 143 Group Data Together 144 Calculate a Percent of Totals 144 Add Your Own Calculations 145 Create a PivotChart 146 Chapter 14: Building Simple Macros 147 Record a Macro 148 Check Macro Security Level 149 Run a Macro 150 Assign a Macro KeyStroke 150 Create a Macro Toolbar Button 151 Stop a Macro 151 Delete a Macro 152 Delete a Personal Macro 152 Chapter 15: Saving Time with Excel Tools 153 Add Special Characters 154 Create a Custom Toolbar 154 Split Data into Multiple Columns 155 Merge Columns 156 Manage AutoCorrect 157 Check for Formula Errors 157 Work with SmartTags 158 Part V: Practical Applications for Excel 159 Chapter 16: Creating a Commission Calculator 161 Enter Headings 162 Create the Commission Table 162 Define the Sales Data Input Area 163 Total Sales with the SUMIF Function 163 Use the COUNTIF Function to Count Sales 164 Calculate Commission with a Nested IF Statement 164 Create Totals 165 Make It Look Nicer 166 Protect Your Work 166 Chapter 17: Tracking Medical Expenses 167 Enter Text Headings 168 Create Totaling Formulas 168 Calculate the Amount Due 169 Specify Data Validation 169 Format the Worksheet 170 Determine Print Settings 170 Add Protection from Accidental Changes 171 Duplicate the Worksheet for Other Family Members 171 Create a Totals Worksheet 172 Save the Workbook as a Template 174 Chapter 18: Planning for Your Financial Future 175 Plan for a House 176 Prepare to Pay Off a Credit Card Balance 177 Save for College or Retirement 178 Chapter 19: Integrating Excel into Word 179 Copy Excel Cells into Word 180 Insert a Saved Excel Worksheet into Word 181 Edit the Inserted Worksheet 181 Embed an Excel Worksheet into Word 182 Copy a Word Table to Excel 183 Create a Word Mail Merge Form Letter Using an Excel List 184 Make Mailing Labels 186 Chapter 20: Blending Excel and PowerPoint 187 Copy Excel Cells into a PowerPoint Slide 188 Drag an Excel Chart into a PowerPoint Slide 189 Insert a Saved Excel Worksheet or Chart into a PowerPoint Slide 190 Link an Excel Worksheet into a PowerPoint Slide 191 Chapter 21: Using Excel with Access 193 Copy Data from Excel to an Access Table 194 Import Data from Excel to an Access Table 195 Link an Excel Worksheet to an Access Database 198 Analyze Access Data with Microsoft Excel 199 Export Access Data to Excel 200 Index 203