Excel 2010 For Dummies, Portable Edition

Crunch numbers, create spreadsheets, and get up to speed on Excel 2010! This friendly book gets you started with the basics of Excel 2010, such as creating a spreadsheet from scratch, selecting commands from the Ribbon, customizing the Quick Access toolbar, creating simple formulas, moving and copying data with drag and drop, using the AutoCorrect and AutoFill features, and more. Navigate effectively see how the Ribbon interface and the Backstage View give you access to all the tools you need for every task Be a mover and a shaker move and copy data with cut, copy, and paste or drag and drop Summing up total columns and rows of numbers with the AutoSum button Making it pretty format data tables, adjust column widths and row heights, hide columns and rows, and format with Styles or the Format Painter Safety net save your work and recover spreadsheets after a computer crash Open the book and find: What's new in Excel 2010 How to surf an Excel 2010 worksheet and workbook Instructions for entering data in a worksheet Tips for keeping your data secure How to enter and edit formulas with built-in functions Tips for undoing or deleting data entry mistakes Learn to: Get comfortable with Excel 2010 and Backstage View Create and edit spreadsheets Format cells, create formulas, and fix data entry errors Copy, cut, move, paste, or delete data

Crunch numbers, create spreadsheets, and get up to speed onExcel 2010!This friendly book gets you started with the basics of Excel2010, such as creating a spreadsheet from scratch, selectingcommands from the Ribbon, customizing the Quick Access toolbarcreating simple formulas, moving and copying data with drag anddrop, using the AutoCorrect and AutoFill features, and more.* Navigate effectively -- see how the Ribbon interface andthe Backstage View give you access to all the tools you need forevery task* Be a mover and a shaker -- move and copy data with cutcopy, and paste or drag and drop* Summing up -- total columns and rows of numbers with theAutoSum button* Making it pretty -- format data tables, adjust columnwidths and row heights, hide columns and rows, and format withStyles or the Format Painter* Safety net -- save your work and recover spreadsheets aftera computer crashOpen the book and find:* What's new in Excel 2010* How to surf an Excel 2010 worksheet and workbook* Instructions for entering data in a worksheet* Tips for keeping your data secure* How to enter and edit formulas with built-in functions* Tips for undoing or deleting data entry mistakesLearn to:* Get comfortable with Excel 2010 and Backstage View* Create and edit spreadsheets* Format cells, create formulas, and fix data entry errors* Copy, cut, move, paste, or delete data

Introduction 1Chapter 1: The Excel 2010 User Experience 7Chapter 2: Creating a Spreadsheet from Scratch 33Chapter 3: Editing a Spreadsheet 85Chapter 4: Formatting a Spreadsheet 115Chapter 5: Printing a Spreadsheet 169Chapter 6: Top Ten Features in Excel 2010 197Index 201