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 Auto Correct and Auto Fill 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
Auto Sum 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
Daftar Isi
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
Tentang Penulis
Greg Harvey, Ph D, 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.