Microsoft Excel 2013: Full Coverage of Excel 2013 s Top Features and Functions

Description

Microsoft® Excel® can be an overwhelming and intimidating software product to use, but armed with the right book, anyone can master the basics. Packed full of color screen shots and illustrations, Idiot's Guides: Microsoft® Excel® 2013 will teach any novice how to perform all of the essential functions, including how to create a spreadsheet from scratch; build and edit basic formulas and functions; manage, sort, and edit data cleanly and efficiently; create and insert graphics; work with tables; generate readable reports; and much more. Contents iii......Page 5 Getting Started with Excel 2013 1......Page 11 Exploring Excel 2013 2......Page 12 Exploring the Excel Web App 4......Page 14 Creating a New Blank Spreadsheet 6......Page 16 Creating a New Spreadsheet from a Template 8......Page 18 Saving Your Spreadsheet 10......Page 20 Opening an Existing Spreadsheet 12......Page 22 Changing Views 14......Page 24 Customizing the Ribbon 16......Page 26 Personalizing the Quick Access Toolbar 18......Page 28 Configuring Other Important Options 20......Page 30 Entering and Editing Data 23......Page 33 Understanding the Spreadsheet Layout 24......Page 34 Entering Numbers 26......Page 36 Entering Dates and Times 28......Page 38 Entering Text 30......Page 40 Editing Cell Data 32......Page 42 Deleting Data from a Cell 34......Page 44 Finding and Replacing Text 36......Page 46 Copying Cells 38......Page 48 Moving Cells 40......Page 50 Formatting Data 43......Page 53 Applying Bold, Italic, and Other Font Effects 44......Page 54 Changing Font and Font Size 46......Page 56 Aligning Text 48......Page 58 Aligning Text Vertically 50......Page 60 Wrapping Text Within a Cell 52......Page 62 Centering Text Across Multiple Columns 53......Page 63 Rotating Text 54......Page 64 Applying a Background Color 56......Page 66 Applying Number Formats 58......Page 68 Changing Currency Formats 60......Page 70 Displaying Decimal Places 61......Page 71 Using Automatic Number Formats 62......Page 72 Using Conditional Formatting 64......Page 74 Applying Cell Styles 66......Page 76 Creating a New Cell Style 67......Page 77 Adding Borders 68......Page 78 Copying Cell Formatting 70......Page 80 Working with Rows and Columns 73......Page 83 Understanding Rows and Columns 74......Page 84 Naming Cells, Rows, and Columns 76......Page 86 Changing Column Width 78......Page 88 Changing Row Height 79......Page 89 Inserting a New Row 80......Page 90 Inserting a New Column 81......Page 91 Deleting a Row 82......Page 92 Deleting a Column 83......Page 93 Inserting a Single Cell 84......Page 94 Deleting a Single Cell 86......Page 96 Copying a Row or Column 88......Page 98 Moving a Row or Column 90......Page 100 Hiding and Unhiding a Row or Column 92......Page 102 Freezing a Row or Column 94......Page 104 Merging Two or More Cells 96......Page 106 Splitting a Merged Cell 97......Page 107 Formatting Rows and Columns 98......Page 108 Sorting Data 100......Page 110 Working with worksheet 105......Page 115 Understanding Worksheets and Workbooks 106......Page 116 Creating a New Worksheet 108......Page 118 Changing the Default Number of Worksheets 109......Page 119 Copying a Worksheet 110......Page 120 Moving a Worksheet 111......Page 121 Moving or Copying a Worksheet to a Different Workbook 112......Page 122 Renaming a Worksheet 113......Page 123 Changing the Tab Color 114......Page 124 Deleting a Worksheet 115......Page 125 Grouping Worksheets 116......Page 126 Splitting a Worksheet into Panes 118......Page 128 Hiding and Unhiding Worksheets 120......Page 130 Formatting Worksheets and Workbooks 123......Page 133 Changing Gridline Color 124......Page 134 Showing or Hiding Gridlines 125......Page 135 Showing or Hiding Row and Column Headings 126......Page 136 Formatting a Worksheet’s Background Color 127......Page 137 Adding a Background Picture to a Worksheet 128......Page 138 Copying Formatting Between Worksheets 130......Page 140 Applying Visual Effects to a Workbook 131......Page 141 Changing Workbook Colors 132......Page 142 Setting Workbook Fonts 134......Page 144 Applying a Workbook Theme 136......Page 146 Working with Ranges 139......Page 149 Selecting a Range of Cells 140......Page 150 Naming a Range 142......Page 152 Navigating with Range Names 144......Page 154 Managing Names in a Workbook 145......Page 155 Moving a Range of Cells 146......Page 156 Copying a Range of Cells 148......Page 158 Deleting a Range 150......Page 160 Filling a Range of Cells with AutoFill 152......Page 162 Flash Filling a Range 154......Page 164 Using Quick Analysis to Format or Analyze a Range 156......Page 166 Using Formulas and Functions 159......Page 169 How Formulas Work 160......Page 170 Creating a Formula162......Page 172 Editing a Formula 164......Page 174 Using Absolute Cell References in a Formula 166......Page 176 Using Ranges in a Formula 168......Page 178 Referencing Other Worksheets in a Formula 170......Page 180 Showing and Hiding Formulas 172......Page 182 Checking for Errors in Formulas 173......Page 183 Understanding Functions 174......Page 184 Using Functions in Formulas 176......Page 186 Using the AutoSum Function 178......Page 188 Using the AVERAGE Function 180......Page 190 Using the COUNT Function 181......Page 191 Creating Charts 183......Page 193 Exploring Excel’s Chart Types184......Page 194 Creating a Chart186......Page 196 Moving and Resizing a Chart 188......Page 198 Moving a Chart to Its Own Chart Sheet 189......Page 199 Changing the Chart Type 190......Page 200 Changing a Chart’s Source Data 192......Page 202 Adding and Removing Chart Elements 194......Page 204 Changing Chart Style and Color 196......Page 206 Formatting Chart Elements 198......Page 208 Formatting the Chart Area 200......Page 210 Formatting the Plot Area 201......Page 211 Formatting Axes 202......Page 212 Formatting Axis Titles 203......Page 213 Formatting the Chart Title 204......Page 214 Formatting Data Labels 205......Page 215 Formatting a Data Table 206......Page 216 Formatting Gridlines 207......Page 217 Formatting the Legend 208......Page 218 Formatting 3-D Rotation 209......Page 219 Formatting Data Series 210......Page 220 Formatting a Pie Chart 211......Page 221 Adding Graphics 213......Page 223 Inserting a Photo 214......Page 224 Inserting a Clip Art Image 216......Page 226 Inserting SmartArt 218......Page 228 Inserting a Shape 220......Page 230 Inserting a Text Box 222......Page 232 Inserting WordArt 223......Page 233 Working with Tables 225......Page 235 Converting a Range to a Table 226......Page 236 Adding New Data to a Table 228......Page 238 Removing Rows from a Table 230......Page 240 Inserting Table Columns 232......Page 242 Deleting Table Columns233......Page 243 Sorting a Table 234......Page 244 Filtering Data in a Table 235......Page 245 Adding Column Totals 236......Page 246 Converting a Table to a Range 237......Page 247 Applying Table Styles 238......Page 248 Working with PivotTables 241......Page 251 How PivotTables Work 242......Page 252 Creating a PivotTable 246......Page 256 Adding Fields to a PivotTable 250......Page 260 Changing Value Calculations 252......Page 262 Changing the Source Data 254......Page 264 Sorting a PivotTable 255......Page 265 Filtering PivotTable Data with Slicers 256......Page 266 Filtering by Date with Timelines 258......Page 268 Other Ways to Filter PivotTable Data 260......Page 270 Creating a PivotChart 262......Page 272 Analyzing Data 265......Page 275 Using Goal Seek for What-If Analysis 266......Page 276 Using Scenario Manager 268......Page 278 Producing a Scenario Summary Report 270......Page 280 Showing Trends with Sparklines 272......Page 282 Printing 275......Page 285 Printing One or More Worksheets 276......Page 286 Printing Part of a Worksheet 278......Page 288 Changing Page Orientation 280......Page 290 Scaling the Spreadsheet to Fit 281......Page 291 Inserting Page Breaks 282......Page 292 Configuring Other Print Options 284......Page 294 Printing Row and Column Titles 285......Page 295 Adding a Header and Footer 286......Page 296 Sharing and Collaborating 289......Page 299 Sharing Online with SkyDrive 290......Page 300 Sharing a Workbook via Email 292......Page 302 Enabling Change Tracking 293......Page 303 Accepting and Rejecting Changes 294......Page 304 Adding Comments 296......Page 306 Collaborating Online with the Excel Web App 298......Page 308 Glossary 300......Page 310 Keyboard Shortcuts 302......Page 312 Index 306......Page 316