Excel 2010 For Dummies

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

Auteur
Greg Harvey, PhD, is president of Mind Over Media, Inc., and the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference.

Résumé
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

Contenu
Introduction 1 Chapter 1: The Excel 2010 User Experience 7

Chapter 2: Creating a Spreadsheet from Scratch 33

Chapter 3: Editing a Spreadsheet 85

Chapter 4: Formatting a Spreadsheet 115

Chapter 5: Printing a Spreadsheet 169

Chapter 6: Top Ten Features in Excel 2010 197

Index 201