{"product_id":"excel-2010-bible-isbn-9780470474877","title":"Excel 2010 Bible","description":"\u003cb\u003eA comprehensive reference to the newest version of the world’s most popular spreadsheet application: Excel 2010\u003c\/b\u003e  \u003cp\u003eJohn Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as \"Mr. Spreadsheet,\" Walkenbach shows you how to maximize the power of all the new features of Excel 2010.\u003c\/p\u003e \u003cp\u003eAn authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won’t find anywhere else.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eExcel guru and bestselling author John Walkenbach (\"Mr. Spreadsheet\") guides you through every aspect of Excel\u003c\/li\u003e \u003cli\u003eDelivers essential coverage of all the newest features of Excel 2010\u003c\/li\u003e \u003cli\u003ePresents material in a clear, concise, logical format that is ideal for all levels of Excel experience\u003c\/li\u003e \u003cli\u003eIncludes a CD that contains all the templates and worksheets used in the book plus John Walkenbach's award-winning Power Utility Pak\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003ci\u003eExcel 2010 Bible\u003c\/i\u003e serves as an excellent resource on all things Excel!\u003c\/p\u003e \u003cp\u003e\u003cb\u003eNote:\u003c\/b\u003e CD-ROM\/DVD and other supplementary materials are not included as part of eBook file.\u003c\/p\u003e  \u003cp\u003e\u003ci\u003eAcknowledgments xxxvii\u003c\/i\u003e\u003c\/p\u003e \u003cp\u003e\u003ci\u003eIntroduction xxxviii\u003c\/i\u003e\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart I: Getting Started with Excel 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Introducing Excel 3\u003c\/p\u003e \u003cp\u003eChapter 2: Entering and Editing Worksheet Data29\u003c\/p\u003e \u003cp\u003eChapter 3: Essential Worksheet Operations 49\u003c\/p\u003e \u003cp\u003eChapter 4: Working with Cells and Ranges 69\u003c\/p\u003e \u003cp\u003eChapter 5: Introducing Tables 99\u003c\/p\u003e \u003cp\u003eChapter 6: Worksheet Formatting 115\u003c\/p\u003e \u003cp\u003eChapter 7: Understanding Excel Files 141\u003c\/p\u003e \u003cp\u003eChapter 8: Using and Creating Templates 161\u003c\/p\u003e \u003cp\u003eChapter 9: Printing Your Work 171\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Working with Formulas and Functions 193\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 10: Introducing Formulas and Functions 195\u003c\/p\u003e \u003cp\u003eChapter 11: Creating Formulas That Manipulate Text  229\u003c\/p\u003e \u003cp\u003eChapter 12: Working with Dates and Times 249\u003c\/p\u003e \u003cp\u003eChapter 13: Creating Formulas That Count and Sum 281\u003c\/p\u003e \u003cp\u003eChapter 14: Creating Formulas That Look Up Values 309\u003c\/p\u003e \u003cp\u003eChapter 15: Creating Formulas for Financial Applications 329\u003c\/p\u003e \u003cp\u003eChapter 16: Introducing Array Formulas 355\u003c\/p\u003e \u003cp\u003eChapter 17: Performing Magic with Array Formulas 379\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Creating Charts and Graphics 401\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 18: Getting Started Making Charts 403\u003c\/p\u003e \u003cp\u003eChapter 19: Learning Advanced Charting 437\u003c\/p\u003e \u003cp\u003eChapter 20: Visualizing Data Using Conditional Formatting 481\u003c\/p\u003e \u003cp\u003eChapter 21: Creating Sparkline Graphics 503\u003c\/p\u003e \u003cp\u003eChapter 22: Enhancing Your Work with Pictures and Drawings 517\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Using Advanced Excel Features 539\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 23: Customizing the Excel User Interface 541\u003c\/p\u003e \u003cp\u003eChapter 24: Using Custom Number Formats 551\u003c\/p\u003e \u003cp\u003eChapter 25: Using Data Validation 569\u003c\/p\u003e \u003cp\u003eChapter 26: Creating and Using Worksheet Outlines 581\u003c\/p\u003e \u003cp\u003eChapter 27: Linking and Consolidating Worksheets 589\u003c\/p\u003e \u003cp\u003eChapter 28: Excel and the Internet 605\u003c\/p\u003e \u003cp\u003eChapter 29: Sharing Data with Other Office Applications 615\u003c\/p\u003e \u003cp\u003eChapter 30: Using Excel in a Workgroup 627\u003c\/p\u003e \u003cp\u003eChapter 31: Protecting Your Work 637\u003c\/p\u003e \u003cp\u003eChapter 32: Making Your Worksheets Error-Free 649\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Analyzing Data with Excel 675\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter Chapter 34: Introducing Pivot Tables 695\u003c\/p\u003e \u003cp\u003eChapter 33: Getting Data from External Database Files 677\u003c\/p\u003e \u003cp\u003eChapter 35: Analyzing Data with Pivot Tables 715\u003c\/p\u003e \u003cp\u003eChapter 36: Performing Spreadsheet What-If Analysis 745\u003c\/p\u003e \u003cp\u003eChapter 37: Analyzing Data Using Goal Seeking and Solver 761\u003c\/p\u003e \u003cp\u003eChapter 38: Analyzing Data with the Analysis ToolPak 781\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: Programming Excel with VBA 793\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 39: Introducing Visual Basic for Applications 795\u003c\/p\u003e \u003cp\u003eChapter 40: Creating Custom Worksheet Functions 823\u003c\/p\u003e \u003cp\u003eChapter 41: Creating UserForms 837\u003c\/p\u003e \u003cp\u003eChapter 42: Using UserForm Controls in a Worksheet 859\u003c\/p\u003e \u003cp\u003eChapter 43: Working with Excel Events 873\u003c\/p\u003e \u003cp\u003eChapter 44: VBA Examples 887\u003c\/p\u003e \u003cp\u003eChapter 45: Creating Custom Excel Add-Ins 903\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VII: Appendixes 915\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003e\u003ci\u003eAppendix A: Worksheet Function Reference 917\u003c\/i\u003e\u003c\/p\u003e \u003cp\u003e\u003ci\u003eAppendix B: What’s on the CD-ROM 933\u003c\/i\u003e\u003c\/p\u003e  \u003cp\u003e\"... comprehensive and authoritative... gives a user at any level the confidence to self-teach Excel 2010... thorough and genuinely helpful.\" (Software Latest.com, December 2010)  \u003cb\u003eJohn Walkenbach aka \"Mr. Spreadsheet\"\u003c\/b\u003e is the principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and the creator of the award-winning Power Utility Pak. John has written more than 50 books, as well as articles and reviews for publications including \u003ci\u003ePC World\u003c\/i\u003e, \u003ci\u003eInfoWorld\u003c\/i\u003e, and \u003ci\u003eWindows\u003c\/i\u003e. He also maintains the popular Spreadsheet Page at spreadsheetpage.com.  \"John Walkenbach's writing style makes the difficult seem easy in this book that can be used as a reference or read cover to cover. You won't find a more comprehensive book on Excel 2010 than this!\"\u003cbr\u003e —\u003cb\u003eDick Kusleika\u003c\/b\u003e, Microsoft MVP, DailyDoseOfExcel.com  \u003c\/p\u003e\u003cp\u003e\u003cb\u003eIf Excel can do it, John Walkenbach can show you how\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhat better way to learn Excel 2010 than from \"Mr. Spreadsheet\" himself? Excel guru, Microsoft MVP, and author of all the previous top-selling editions of Excel Bible, John Walkenbach provides more than 1,000 pages packed with techniques, tips, and tricks for beginners as well as Excel power users. Discover what's new in Excel 2010, learn shortcuts you didn't know, make the Ribbon interface work for you, and master all the latest ins-and-outs with this must-have guide.\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eGet up to speed on everything new in Excel 2010\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eUnderstand functions, charts, worksheets, and workbooks\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003ePerform magic with array formulas—and even more with Sparklines\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eMaster \"what-if\" analysis, Goal Seeking, external database files, and pivot tables\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eDevelop custom functions, program with VBA, and create UserForms\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eTry new slice-and-dice tools to dynamically filter your data\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003e\u003cb\u003eWhat's on the CD-ROM?\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eFollow the examples in the book, chapter by chapter, using the bonus materials on the CD-ROM:\u003c\/p\u003e \u003cul\u003e \u003cli\u003e \u003cp\u003eAll the examples and workbook files used in the book\u003c\/p\u003e \u003c\/li\u003e \u003cli\u003e \u003cp\u003eSearchable PDF of the book\u003c\/p\u003e \u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eSystem Requirements: See the CD Appendix in the book for details and complete system requirements.\u003c\/p\u003e \u003cul\u003e \u003cli\u003ePreview how your copied text will look\u003c\/li\u003e \u003cli\u003eSpot trends in your data with Sparklines\u003c\/li\u003e \u003cli\u003eChart your data using Excel's different chart types\u003c\/li\u003e \u003cli\u003eMaster Excel formulas for useful worksheets\u003c\/li\u003e \u003cli\u003eCreate effective charts suitable for the boardroom\u003c\/li\u003e \u003cli\u003eAnalyze and present data with pivot tables\u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989181513957,"sku":"NP9780470474877","price":44.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780470474877.jpg?v=1761783116","url":"https:\/\/k12savings.com\/products\/excel-2010-bible-isbn-9780470474877","provider":"K12savings","version":"1.0","type":"link"}