Excel 2010 For Dummies - Tapa blanda

Have you just discovered you need to use Excel for the first time? Or are you an Excel veteran who wants to understand the 2010 version in a hurry? Either way, this friendly book has everything you need to know about creating and editing worksheets, formatting cells, using formulas, adding hyperlinks, saving worksheets as Web pages, and more.

• Navigate effectively — see how the Ribbon interface andthe Backstage View give you access to all the tools you need for every task

• It's your Excel — customize the Ribbon and Quick Access toolbar to include the tools you use

• To err is human — but you can easily fix mistakes and make updates with Excel's editing functions

• Easy maintenance — make maintaining your worksheets easier with zoom, comments, cell names, and more

• Pivotal moments — create and format pivot tables to summarize your data effectively

• Making it pretty — include graphics, charts, and clip art to clarify the story your worksheets tell

• Macro magic — automate Excel commands by creating macros you can add to the Ribbon or Quick Access toolbar

• Collaborate online — share your worksheets via Windows Live SkyDrive and edit them from anywhere with Office Web Apps

Open the book and find:

• What's new in Excel 2010, including the Backstage View

• How to launch Excel fromWindows 7, Windows Vista,and Windows XP

• Tips for drag-and-drop editing

• Hints for perfect printouts

• How to use the Insert Function button

• Secrets for securing your data

• How to use Conditional Formatting and Sparklines minigraphs to highlight your data

• How to do "what-if" data analysis

Learn to:

• Create and edit worksheets, format cells, and enter formulas

• Add data tables and sort and filter records

• Create powerful charts with graphics

• Share worksheets via e-mailand SharePoint