{"product_id":"excel-2013-bible-isbn-9781118490365","title":"Excel 2013 Bible","description":"\u003cp\u003e\u003cb\u003eExcel at Excel with the help of this bestselling spreadsheet guide\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eJohn Walkenbach's name is synonymous with excellence in computer books that decipher the complexities of Microsoft Excel. Known as \"Mr. Spreadsheet,\" Walkenbach shows you how to maximize the power of Excel 2013 while bringing you up to speed on the latest features. This perennial bestseller is fully updated to cover all the new features of Excel 2013, including how to navigate the user interface, take advantage of various file formats, master formulas, analyze data with PivotTables, and more.\u003c\/p\u003e \u003cp\u003eWhether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this latest edition provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eShares the invaluable insight of Excel guru and bestselling author \"Mr. Spreadsheet\" John Walkenbach as he guides you through every aspect of Excel 2013\u003c\/li\u003e \u003cli\u003eProvides essential coverage of all the newest features of Excel 2013\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\u003eFeatures a website that includes downloadable templates and worksheets from the book\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eChart your path to fantastic formulas and stellar spreadsheets with \u003ci\u003eExcel 2013 Bible\u003c\/i\u003e!\u003c\/p\u003e  Acknowledgments ix  \u003cp\u003eIntroduction xxxvii\u003c\/p\u003e \u003cp\u003eIs This Book for You? xxxvii\u003c\/p\u003e \u003cp\u003eSoftware Versions xxxvii\u003c\/p\u003e \u003cp\u003eConventions Used in This Book xxxviii\u003c\/p\u003e \u003cp\u003eExcel commands xxxviii\u003c\/p\u003e \u003cp\u003eFilenames, named ranges, and your input xxxviii\u003c\/p\u003e \u003cp\u003eKey names xxxviii\u003c\/p\u003e \u003cp\u003eFunctions xxxviii\u003c\/p\u003e \u003cp\u003eMouse conventions xxxix\u003c\/p\u003e \u003cp\u003eHow This Book Is Organized xl\u003c\/p\u003e \u003cp\u003eHow to Use This Book  xl\u003c\/p\u003e \u003cp\u003eWhat’s on the Website 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: Essential Worksheet Operations 49\u003c\/p\u003e \u003cp\u003eChapter 4: Working with Cells and Ranges 69\u003c\/p\u003e \u003cp\u003eChapter 5: Introducing Tables 101\u003c\/p\u003e \u003cp\u003eChapter 6: Worksheet Formatting 119\u003c\/p\u003e \u003cp\u003eChapter 7: Understanding Excel Files 145\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 231\u003c\/p\u003e \u003cp\u003eChapter 12: Working with Dates and Times 251\u003c\/p\u003e \u003cp\u003eChapter 13: Creating Formulas That Count and Sum 285\u003c\/p\u003e \u003cp\u003eChapter 14: Creating Formulas That Look Up Values 313\u003c\/p\u003e \u003cp\u003eChapter 15: Creating Formulas for Financial Applications 333\u003c\/p\u003e \u003cp\u003eChapter 16: Miscellaneous Calculations 359\u003c\/p\u003e \u003cp\u003eChapter 17: Introducing Array Formulas 373\u003c\/p\u003e \u003cp\u003eChapter 18: Performing Magic with Array Formulas 397\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart III: Creating Charts and Graphics 419\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 19: Getting Started Making Charts 421\u003c\/p\u003e \u003cp\u003eChapter 20: Learning Advanced Charting 457\u003c\/p\u003e \u003cp\u003eChapter 21: Visualizing Data Using Conditional Formatting 503\u003c\/p\u003e \u003cp\u003eChapter 22: Creating Sparkline Graphics 525\u003c\/p\u003e \u003cp\u003eChapter 23: Enhancing Your Work with Pictures and Drawings 539\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart IV: Using Advanced Excel Features 561\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 24: Customizing the Excel User Interface 563\u003c\/p\u003e \u003cp\u003eChapter 25: Using Custom Number Formats 573\u003c\/p\u003e \u003cp\u003eChapter 26: Using Data Validation 591\u003c\/p\u003e \u003cp\u003eChapter 27: Creating and Using Worksheet Outlines 603\u003c\/p\u003e \u003cp\u003eChapter 28: Linking and Consolidating Worksheets 613\u003c\/p\u003e \u003cp\u003eChapter 29: Excel and the Internet 631\u003c\/p\u003e \u003cp\u003eChapter 30: Protecting Your Work 643\u003c\/p\u003e \u003cp\u003eChapter 31: Making Your Worksheets Error Free 655\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart V: Analyzing Data with Excel 683\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 32: Importing and Cleaning Data 685\u003c\/p\u003e \u003cp\u003eChapter 33: Introducing Pivot Tables 715\u003c\/p\u003e \u003cp\u003eChapter 34: Analyzing Data with Pivot Tables 739\u003c\/p\u003e \u003cp\u003eChapter 35: Performing Spreadsheet What-If Analysis 777\u003c\/p\u003e \u003cp\u003eChapter 36: Analyzing Data Using Goal Seeking and Solver 793\u003c\/p\u003e \u003cp\u003eChapter 37: Analyzing Data with the Analysis ToolPak 813\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VI: Programming Excel with VBA 825\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 38: Introducing Visual Basic for Applications 827\u003c\/p\u003e \u003cp\u003eChapter 39: Creating Custom Worksheet Functions 855\u003c\/p\u003e \u003cp\u003eChapter 40: Creating UserForms 869\u003c\/p\u003e \u003cp\u003eChapter 41: Using UserForm Controls in a Worksheet 889\u003c\/p\u003e \u003cp\u003eChapter 42: Working with Excel Events 903\u003c\/p\u003e \u003cp\u003eChapter 44: Creating Custom Excel Add-Ins 931\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart VII: Appendixes 941\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAppendix A: Worksheet Function Reference 943\u003c\/p\u003e \u003cp\u003eAppendix B: Excel Shortcut Keys 961\u003c\/p\u003e \u003cp\u003eIndex 967\u003c\/p\u003e \u003cp\u003e\u003cb\u003eJohn Walkenbach\u003c\/b\u003e (aka \"Mr. Spreadsheet\") is a leading authority on spreadsheet software, creator of the award-winning Power Utility Pak, and principal of J-Walk and Associates, Inc. He is a bestselling Excel author who has published more than 50 books about spreadsheets. He maintains the popular Spreadsheet Page at www.spreadsheetpage.com.\u003c\/p\u003e  \u003cp\u003eExcel at Excel with this ultimate guide\u003c\/p\u003e \u003cp\u003eWhether you want to create charts, import and clean data, automate tasks with VBA macros, or work in the cloud—however you want to use Excel, John Walkenbach can show you how. Fully updated for the latest features in Excel 2013, this perennial bestseller is packed with information, techniques, helpful notes, and tips to take your spreadsheet skills to the next level. Beginner, power user, or somewhere in between, this is the ultimate Excel resource you'll turn to again and again.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eGet up to speed on everything new in Excel 2013\u003c\/li\u003e \u003cli\u003eReview Excel basics—worksheets, formulas, functions, and charts\u003c\/li\u003e \u003cli\u003eLearn to handle data in many ways, including importing, cleaning, and analyzing\u003c\/li\u003e \u003cli\u003eMaster useful Excel tools, such as Sparklines, Flash Fill, and Analysis ToolPak\u003c\/li\u003e \u003cli\u003eDiscover the power of Excel's ultimate analysis tool—pivot tables\u003c\/li\u003e \u003cli\u003eCreate VBA macros, add controls, and work with Excel events\u003c\/li\u003e \u003cli\u003eSlice and dice your data to identify trends and patterns\u003c\/li\u003e \u003cli\u003eWork your way through sample workbooks and take advantage of downloadable templates on the companion website\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eUse formulas and functions to create useful forms\u003c\/p\u003e \u003cp\u003eLearn which chart is most suitable for your data\u003c\/p\u003e \u003cp\u003ePivot table slicers make it easy to filter data\u003c\/p\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989181612261,"sku":"NP9781118490365","price":49.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781118490365.jpg?v=1761783114","url":"https:\/\/k12savings.com\/products\/excel-2013-bible-isbn-9781118490365","provider":"K12savings","version":"1.0","type":"link"}