{"product_id":"excel-2019-bible-isbn-9781119514787","title":"Excel 2019 Bible","description":"\u003cb\u003eThe complete guide to Excel 2019\u003c\/b\u003e \u003cp\u003eWhether you are just starting out or an Excel novice, the \u003ci\u003eExcel 2019 Bible\u003c\/i\u003e is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities 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 2019 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 2019's new features and tools\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eWhether you need a walkthrough tutorial or an easy-to-navigate desk reference, the \u003ci\u003eExcel 2019 Bible\u003c\/i\u003e has you covered with complete coverage and clear expert guidance.\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 29\u003c\/p\u003e \u003cp\u003eChapter 3: Performing Basic Worksheet Operations 51\u003c\/p\u003e \u003cp\u003eChapter 4: Working with Excel Ranges and Tables 71\u003c\/p\u003e \u003cp\u003eChapter 5: Formatting Worksheets 117\u003c\/p\u003e \u003cp\u003eChapter 6: Understanding Excel Files and Templates 153\u003c\/p\u003e \u003cp\u003eChapter 7: Printing Your Work 173\u003c\/p\u003e \u003cp\u003eChapter 8: Customizing the Excel User Interface 195\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart II: Working with Formulas and Functions 205\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 9: Introducing Formulas and Functions 207\u003c\/p\u003e \u003cp\u003eChapter 10: Using Formulas for Common Mathematical Operations 239\u003c\/p\u003e \u003cp\u003eChapter 11: Using Formulas to Manipulate Text 253\u003c\/p\u003e \u003cp\u003eChapter 12: Using Formulas with Dates and Times 269\u003c\/p\u003e \u003cp\u003eChapter 13: Using Formulas for Conditional Analysis 295\u003c\/p\u003e \u003cp\u003eChapter 14: Using Formulas for Matching and Lookups 315\u003c\/p\u003e \u003cp\u003eChapter 15: Using Formulas for Financial Analysis 333\u003c\/p\u003e \u003cp\u003eChapter 16: Using Formulas for Statistical Analysis 365\u003c\/p\u003e \u003cp\u003eChapter 17: Using Formulas with Tables and Conditional Formatting 385\u003c\/p\u003e \u003cp\u003eChapter 18: Understanding and Using Array Formulas 399\u003c\/p\u003e \u003cp\u003eChapter 19: Making Your Formulas Error-Free 423\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Creating Charts and Other Visualizations 443\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 20: Getting Started with Excel Charts 445\u003c\/p\u003e \u003cp\u003eChapter 21: Using Advanced Charting Techniques 489\u003c\/p\u003e \u003cp\u003eChapter 22: Creating Sparkline Graphics 523\u003c\/p\u003e \u003cp\u003eChapter 23: Visualizing with Custom Number Formats and Shapes 537\u003c\/p\u003e \u003cp\u003eChapter 24: Implementing Excel Dashboarding Best Practices 567\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Managing and Analyzing Data 577\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 25: Importing and Cleaning Data 579\u003c\/p\u003e \u003cp\u003eChapter 26: Using Data Validation 613\u003c\/p\u003e \u003cp\u003eChapter 27: Creating and Using Worksheet Outlines 627\u003c\/p\u003e \u003cp\u003eChapter 28: Linking and Consolidating Worksheets 637\u003c\/p\u003e \u003cp\u003eChapter 29: Introducing PivotTables. 655\u003c\/p\u003e \u003cp\u003eChapter 30: Analyzing Data with PivotTables 679\u003c\/p\u003e \u003cp\u003eChapter 31: Performing Spreadsheet What-If Analysis 715\u003c\/p\u003e \u003cp\u003eChapter 32: Analyzing Data Using Goal Seeking and Solver r 733\u003c\/p\u003e \u003cp\u003eChapter 33: Analyzing Data with the Analysis ToolPak 755\u003c\/p\u003e \u003cp\u003eChapter 34: Protecting Your Work 769\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Understanding Power Pivot and Power Query 781\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 35: Introducing Power Pivot 783\u003c\/p\u003e \u003cp\u003eChapter 36: Working Directly with the Internal Data Model 807\u003c\/p\u003e \u003cp\u003eChapter 37: Adding Formulas to Power Pivot 817\u003c\/p\u003e \u003cp\u003eChapter 38: Introducing Power Query. y 835\u003c\/p\u003e \u003cp\u003eChapter 39: Transforming Data with Power Query. 859\u003c\/p\u003e \u003cp\u003eChapter 40: Making Queries Work Together r 887\u003c\/p\u003e \u003cp\u003eChapter 41: Enhancing Power Query Productivity 903\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: Automating Excel 915\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 42: Introducing Visual Basic for Applications 917\u003c\/p\u003e \u003cp\u003eChapter 43: Creating Custom Worksheet Functions 947\u003c\/p\u003e \u003cp\u003eChapter 44: Creating UserForms 961\u003c\/p\u003e \u003cp\u003eChapter 45: Using UserForm Controls in a Worksheet 983\u003c\/p\u003e \u003cp\u003eChapter 46: Working with Excel Events 997\u003c\/p\u003e \u003cp\u003eChapter 47: Seeing Some VBA Examples 1011\u003c\/p\u003e \u003cp\u003eChapter 48: Creating Custom Excel Add-Ins 1027\u003c\/p\u003e \u003cp\u003eIndex x 1037\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eMichael Alexander\u003c\/b\u003e is a Microsoft MVP and author of several books on advanced business analysis. He shares his wisdom from more than fifteen years consulting and developing reporting solutions for a variety of industries as the principle contributor at DataPigTechnologies.com, where he offers free video tutorials with the Microsoft Excel and Access communities. \u003cb\u003eDick Kusleika\u003c\/b\u003e is a twelve-time Microsoft Excel MVP and principle contributor at the \u003ci\u003eDaily Dose of Excel \u003c\/i\u003e\u003cb\u003eblog. John 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 including all previous editions of the \u003ci\u003eExcel Bible\u003c\/i\u003e.   \u003c\/p\u003e\u003cp\u003e\u003cb\u003eEncyclopedic coverage on the most widely used platform spreadsheet in the world\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e\u003ci\u003eExcel\u003csup\u003e®\u003c\/sup\u003e 2019 Bible\u003c\/i\u003e is the must-have for everyone using Excel—from beginners and intermediate users to actual power users. Even if you think in spreadsheets, this one-of-a-kind resource offers hundreds of pages of Excel tips, tricks, and techniques you can't find anywhere else. In addition to providing everything you don't know about the new updates and features in the latest release of Excel, it opens levels of higher productivity, faster, with valuable hacks to creating formulas, charts, and other visualizations, as well as managing and analyzing data. \u003c\/p\u003e\u003cul\u003e \u003cli\u003eGet the most out of Excel 2019's powerful new features and start  making functional spreadsheets that work\u003c\/li\u003e \u003cli\u003eCustomize downloadable templates and worksheets to streamline  your transition\u003c\/li\u003e \u003cli\u003eWork from an authoritative reference of best practices for optimizing  formulas, data analysis, pivot tables, and more\u003c\/li\u003e \u003cli\u003eMaximize all the features of Excel 2019 by following the tutorial chapter  by chapter or diving in for specific information\u003c\/li\u003e \u003cli\u003eEnhance your capabilities and performance on the job and managing  your home\u003c\/li\u003e \u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989181808869,"sku":"NP9781119514787","price":55.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119514787.jpg?v=1761783116","url":"https:\/\/k12savings.com\/products\/excel-2019-bible-isbn-9781119514787","provider":"K12savings","version":"1.0","type":"link"}