{"product_id":"excel-2016-bible-isbn-9781119067511","title":"Excel 2016 Bible","description":"\u003cp\u003e\u003cb\u003eThe complete guide to Excel 2016, from Mr. Spreadsheet himself\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhether you are just starting out or an Excel novice, the \u003ci\u003eExcel 2016 Bible\u003c\/i\u003e is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more.\u003c\/p\u003e \u003cp\u003eNavigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2016 Bible.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eCreate functional spreadsheets that \u003ci\u003ework\u003c\/i\u003e\n\u003c\/li\u003e \u003cli\u003eMaster formulas, formatting, pivot tables, and more\u003c\/li\u003e \u003cli\u003eGet acquainted with Excel 2016's new features and tools\u003c\/li\u003e \u003cli\u003eCustomize downloadable templates and worksheets\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eWhether you need a walkthrough tutorial or an easy-to-navigate desk reference, the \u003ci\u003eExcel 2016 Bible\u003c\/i\u003e has you covered with complete coverage and clear expert guidance.\u003c\/p\u003e \u003cp\u003eAcknowledgments ix\u003c\/p\u003e \u003cp\u003eIntroduction xli\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 Data 9\u003c\/p\u003e \u003cp\u003eChapter 3: Essential Worksheet Operations 51\u003c\/p\u003e \u003cp\u003eChapter 4: Working with Cells and Ranges 73\u003c\/p\u003e \u003cp\u003eChapter 5: Introducing Tables 109\u003c\/p\u003e \u003cp\u003eChapter 6: Worksheet Formatting 129\u003c\/p\u003e \u003cp\u003eChapter 7: Understanding Excel Files 157\u003c\/p\u003e \u003cp\u003eChapter 8: Using and Creating Templates 171\u003c\/p\u003e \u003cp\u003eChapter 9: Printing Your Work 181\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Working with Formulas and Functions 205\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 10: Introducing Formulas and Functions 207\u003c\/p\u003e \u003cp\u003eChapter 11: Creating Formulas That Manipulate Text 243\u003c\/p\u003e \u003cp\u003eChapter 12: Working with Dates and Times 263\u003c\/p\u003e \u003cp\u003eChapter 13: Creating Formulas That Count and Sum 297\u003c\/p\u003e \u003cp\u003eChapter 14: Creating Formulas That Look Up Values 327\u003c\/p\u003e \u003cp\u003eChapter 15: Creating Formulas for Financial Applications 349\u003c\/p\u003e \u003cp\u003eChapter 16: Miscellaneous Calculations 381\u003c\/p\u003e \u003cp\u003eChapter 17: Introducing Array Formulas 395\u003c\/p\u003e \u003cp\u003eChapter 18: Performing Magic with Array Formulas 421\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Creating Charts and Graphics 445\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 19: Getting Started Making Charts 447\u003c\/p\u003e \u003cp\u003eChapter 20: Learning Advanced Charting 491\u003c\/p\u003e \u003cp\u003eChapter 21: Visualizing Data Using Conditional Formatting 539\u003c\/p\u003e \u003cp\u003eChapter 22: Creating Sparkline Graphics 563\u003c\/p\u003e \u003cp\u003eChapter 23: Enhancing Your Work with Pictures and Drawings 579\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Using Advanced Excel Features 601\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 24: Customizing the Excel User Interface 603\u003c\/p\u003e \u003cp\u003eChapter 25: Using Custom Number Formats 613\u003c\/p\u003e \u003cp\u003eChapter 26: Using Data Validation 633\u003c\/p\u003e \u003cp\u003eChapter 27: Creating and Using Worksheet Outlines 647\u003c\/p\u003e \u003cp\u003eChapter 28: Linking and Consolidating Worksheets 657\u003c\/p\u003e \u003cp\u003eChapter 29: Excel and the Internet 677\u003c\/p\u003e \u003cp\u003eChapter 30: Protecting Your Work 689\u003c\/p\u003e \u003cp\u003eChapter 31: Making Your Worksheets Error Free 701\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Analyzing Data with Excel 731\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 32: Importing and Cleaning Data 733\u003c\/p\u003e \u003cp\u003eChapter 33: Introducing Pivot Tables 763\u003c\/p\u003e \u003cp\u003eChapter 34: Analyzing Data with Pivot Tables 785\u003c\/p\u003e \u003cp\u003eChapter 35: Performing Spreadsheet What-If Analysis 823\u003c\/p\u003e \u003cp\u003eChapter 36: Analyzing Data Using Goal Seeking and Solver 841\u003c\/p\u003e \u003cp\u003eChapter 37: Analyzing Data with the Analysis ToolPak 863\u003c\/p\u003e \u003cp\u003eChapter 38: Working with Get \u0026amp; Transform 877\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: Programming Excel with VBA 907\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 39: Introducing Visual Basic for Applications 909\u003c\/p\u003e \u003cp\u003eChapter 40: Creating Custom Worksheet Functions 939\u003c\/p\u003e \u003cp\u003eChapter 41: Creating UserForms 955\u003c\/p\u003e \u003cp\u003eChapter 42: Using UserForm Controls in a Worksheet 977\u003c\/p\u003e \u003cp\u003eChapter 43: Working with Excel Events 993\u003c\/p\u003e \u003cp\u003eChapter 44: VBA Examples 1005\u003c\/p\u003e \u003cp\u003eChapter 45: Creating Custom Excel Add-Ins 1021\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VII: Appendixes 1031\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix A: Worksheet Function Reference 1033\u003c\/p\u003e \u003cp\u003eAppendix B: Excel Shortcut Keys 1053\u003c\/p\u003e \u003cp\u003eIndex 1061\u003c\/p\u003e \u003cp\u003e\u003cb\u003eJohn Walkenbach,\u003c\/b\u003e principal of J-Walk and Associates, Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books and 300 articles and reviews for publications including \u003ci\u003ePC World\u003c\/i\u003e,\u003ci\u003e InfoWorld\u003c\/i\u003e, and \u003ci\u003eWindows\u003c\/i\u003e.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eThe bestselling guide to the world's most popular spreadsheet\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWritten by Mr. Spreadsheet himself, \u003ci\u003eExcel 2016\u003c\/i\u003e \u003ci\u003eBible\u003c\/i\u003e guides you through the program's powerful new features and capabilities and shows you how to take full advantage of what the latest version has to offer. From learning to incorporate templates and implementing formulas to creating pivot tables and analyzing data—and so much more—this authoritative guide will be a trusted reference you'll refer to again and again.\u003c\/p\u003e \u003cp\u003eHowever you want to use Excel, guru John Walkenbach will show you how. Fully updated to reflect the latest changes and features in Excel 2016, this perennial bestseller is packed with all the information, techniques, helpful notes, and tips you need to enhance your spreadsheet skills.\u003c\/p\u003e \u003cp\u003e\u003ci\u003eExcel 2016 Bible\u003c\/i\u003e shows you how to:\u003c\/p\u003e \u003cul\u003e \u003cli\u003eCreate an Excel workbook\u003c\/li\u003e \u003cli\u003eWork with formulas and functions\u003c\/li\u003e \u003cli\u003eMake charts and incorporate graphics\u003c\/li\u003e \u003cli\u003eVisualize data using conditional formatting\u003c\/li\u003e \u003cli\u003eUse advanced Excel features\u003c\/li\u003e \u003cli\u003eCustomize your Excel user interface\u003c\/li\u003e \u003cli\u003eMake the most of add-ins in your spreadsheets\u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989181776101,"sku":"NP9781119067511","price":54.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119067511.jpg?v=1761783116","url":"https:\/\/k12savings.com\/products\/excel-2016-bible-isbn-9781119067511","provider":"K12savings","version":"1.0","type":"link"}