About this product

Product Identifiers

PublisherWiley & Sons, Incorporated, John

ISBN-100470489537

ISBN-139780470489536

eBay Product ID (ePID)102925090

Product Key Features

Number of Pages416 Pages

LanguageEnglish

Publication NameExcel 2010 for Dummies

Publication Year2010

SubjectDesktop Applications / Spreadsheets, Enterprise Applications / General

TypeTextbook

AuthorGreg Harvey

Subject AreaComputers

FormatTrade Paperback

Dimensions

Item Height1 in

Item Weight18.4 Oz

Item Length9 in

Item Width7.4 in

Additional Product Features

Intended AudienceTrade

LCCN2010-923559

Dewey Edition22

IllustratedYes

Dewey Decimal005.54

Table Of ContentIntroduction 1 Part I: Getting In on the Ground Floor 9 Chapter 1: The Excel 2010 User Experience 11 Chapter 2: Creating a Spreadsheet from Scratch 49 Part II: Editing without Tears 95 Chapter 3: Making It All Look Pretty 97 Chapter 4: Going Through Changes 145 Chapter 5: Printing the Masterpiece 175 Part III: Getting Organized and Staying That Way 199 Chapter 6: Maintaining the Worksheet 201 Chapter 7: Maintaining Multiple Worksheets 229 Part IV: Digging Data Analysis 253 Chapter 8: Doing What-If Analysis 255 Chapter 9: Playing with Pivot Tables 267 Part V: Life beyond the Spreadsheet 283 Chapter 10: Charming Charts and Gorgeous Graphics 285 Chapter 11: Getting on the Data List 319 Chapter 12: Linking, Automating, and Sharing Spreadsheets 345 Part VI: The Part of Tens 363 Chapter 13: Top Ten Features in Excel 2010 365 Chapter 14: Top Ten Beginner Basics 369 Chapter 15: The Ten Commandments of Excel 2010 371 Index 373

SynopsisThe bestselling Excel book on the market, updated for Excel 2010 As the world's leading spreadsheet application, Excel has a huge user base. The release of Office 2010 brings major changes to Excel, so Excel For Dummies comes to the rescue once more In the friendly and non-threatening For Dummies style, this popular guide shows beginners how to get up and running with Excel and helps more experienced users get comfortable with new features. Excel is the number one spreadsheet application worldwide, and Excel For Dummies is the number one guide to using it With the major changes in Microsoft Office 2010, Excel has new features and a new interface design; users need help to get up to speed The book includes everything you need to know to perform basic Excel 2010 tasks Covers creating and editing worksheets and charts, formatting cells, entering formulas, inserting graphs, designing database forms, and adding database records Also covers printing, adding hyperlinks to worksheets, saving worksheets as Web pages, adding existing worksheet data to an existing Web page, and much more Whether you're new to Excel or just need to understand the 2010 version, Excel 2010 For Dummies provides what you need to know., The bestselling Excel book on the market, updated for Excel 2010 As the worlds leading spreadsheet application, Excel has a huge user base., 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-mail and SharePoint Get up to speed on Excel 2010and discover a whole new way to crunch numbers! 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 and the Backstage View give you access to all the tools you need for every task Its 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 Excels 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(tm) SkyDrive and edit them from anywhere with Office Web Apps Open the book and find: Whats new in Excel 2010, including the Backstage View How to launch Excel from Windows 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, The bestselling Excel book on the market, updated for Excel 2010 As the world's leading spreadsheet application, Excel has a huge user base. The release of Office 2010 brings major changes to Excel, so Excel For Dummies comes to the rescue once more! In the friendly and non-threatening For Dummies style, this popular guide shows beginners how to get up and running with Excel and helps more experienced users get comfortable with new features. Excel is the number one spreadsheet application worldwide, and Excel For Dummies is the number one guide to using it With the major changes in Microsoft Office 2010, Excel has new features and a new interface design; users need help to get up to speed The book includes everything you need to know to perform basic Excel 2010 tasks Covers creating and editing worksheets and charts, formatting cells, entering formulas, inserting graphs, designing database forms, and adding database records Also covers printing, adding hyperlinks to worksheets, saving worksheets as Web pages, adding existing worksheet data to an existing Web page, and much more Whether you're new to Excel or just need to understand the 2010 version, Excel 2010 For Dummies provides what you need to know.

LC Classification NumberHF5548.4.M523