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

About the Author

Greg Harvey has authored tons of computer books, the most recent being Excel Timesaving Techniques For Dummies and Roxio Easy Media Creator For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, he went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.

His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience, the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.

Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.