{"product_id":"excel-workbook-for-dummies-isbn-9781119832157","title":"Excel Workbook For Dummies","description":"\u003cp\u003e\u003cb\u003eGet practical walkthroughs for the most useful Excel features\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eLooking for easy-to-understand, practical guidance on how to go from Excel newbie to number crunching pro? \u003ci\u003eExcel Workbook For Dummies\u003c\/i\u003e is the hands-on tutorial you've been waiting for.\u003c\/p\u003e \u003cp\u003eThis step-by-step guide is packed with exercises that walk you through the basic and advanced functions and formulas included in Excel. At your own speed, you'll learn how to enter data, format your spreadsheet, and apply the mathematical and statistical capabilities of the program.\u003c\/p\u003e \u003cp\u003eWork through the book from start to finish or, if you'd prefer, jump right to the section that's giving you trouble, whether that's data visualization, macros, analysis, or anything else. You can also:\u003c\/p\u003e \u003cul\u003e \u003cli\u003eBrush up on and practice time-saving keyboard shortcuts for popular commands and actions\u003c\/li\u003e \u003cli\u003eGet a handle on multi-functional and practical pivot tables with intuitive practice exercises\u003c\/li\u003e \u003cli\u003eLearn to secure your data with spreadsheet password protections\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003ePerfect for new users of Excel, \u003ci\u003eExcel Workbook For Dummies\u003c\/i\u003e is also the ideal resource for those who know their way around a spreadsheet but need a refresher on some of the more advanced features of this powerful program.\u003c\/p\u003e \u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 1: Building Worksheets 5\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Getting Familiar with the Excel Interface 7\u003c\/p\u003e \u003cp\u003eChapter 2: Entering the Worksheet Data 21\u003c\/p\u003e \u003cp\u003eChapter 3: Formatting the Worksheet 37\u003c\/p\u003e \u003cp\u003eChapter 4: Printing Worksheet Reports 59\u003c\/p\u003e \u003cp\u003eChapter 5: Modifying the Worksheet 79\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 2: Using Formulas and Functions 101\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 6: Building Formulas 103\u003c\/p\u003e \u003cp\u003eChapter 7: Copying and Correcting Formulas 123\u003c\/p\u003e \u003cp\u003eChapter 8: Creating Date and Time Formulas 145\u003c\/p\u003e \u003cp\u003eChapter 9: Financial Formulas and Functions 155\u003c\/p\u003e \u003cp\u003eChapter 10: Using Math Functions 167\u003c\/p\u003e \u003cp\u003eChapter 11: Using Common Statistical Functions 179\u003c\/p\u003e \u003cp\u003eChapter 12: Using Lookup Functions 187\u003c\/p\u003e \u003cp\u003eChapter 13: Using Logical Functions 197\u003c\/p\u003e \u003cp\u003eChapter 14: Text Formulas and Functions 209\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 3: Working with Graphics 217\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 15: Charting Worksheet Data 219\u003c\/p\u003e \u003cp\u003eChapter 16: Adding Graphics to Worksheets 231\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 4: Managing and Securing Data 249\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 17: Building and Maintaining Tables 251\u003c\/p\u003e \u003cp\u003eChapter 18: Protecting Workbooks and Worksheet Data 271\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 5: Doing Data Analysis 283\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 19: Performing What-If Analysis 285\u003c\/p\u003e \u003cp\u003eChapter 20: Generating PivotTables 299\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 6: Macros and Visual Basic for Applications 315\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 21: Using Macros 317\u003c\/p\u003e \u003cp\u003eChapter 22: Using the Visual Basic Editor 327\u003c\/p\u003e \u003cp\u003e\u003cb\u003ePart 7: The Part of Tens 341\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 23: Top Ten Features in Excel 343\u003c\/p\u003e \u003cp\u003eChapter 24: Top Ten Tips for Using Excel Like a Pro 347\u003c\/p\u003e \u003cp\u003eIndex 355\u003c\/p\u003e \u003cp\u003e\u003cb\u003e Paul McFedries\u003c\/b\u003e has published over 100 books, with topics ranging from Windows 10 to Microsoft Office, Apple gadgets, and Amazon Alexa. He is the author of the recently released \u003ci\u003eExcel Data Analysis For Dummies\u003c\/i\u003e and \u003ci\u003eGoogle’s G Suite For Dummies\u003c\/i\u003e.\u003c\/p\u003e \u003cp\u003e\u003cb\u003eGreg Harvey, PhD\u003c\/b\u003e was author of over 30 \u003ci\u003eFor Dummies\u003c\/i\u003e titles covering Excel.  \u003c\/p\u003e\u003cp\u003e\u003cb\u003eElevate your spreadsheet wizardry!\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe best way to learn how to build Excel\u003csup\u003e®\u003c\/sup\u003e spreadsheets is to dive headfirst into the software and let the formulas and functions fly. With the exercises in this book, you’ll get hands-on experience with entering and formatting data, using formulas and functions, creating charts and PivotTables, and writing macros. The ultimate learn-by-doing guide to Microsoft’s best-selling spreadsheet program, this book offers step-by-step lessons on basic and advanced topics to help you master one of the most widely used business apps today!  \u003c\/p\u003e\u003cp\u003e\u003cb\u003e Inside…\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eEnter data and format your spreadsheet\u003c\/li\u003e \u003cli\u003eAdd formulas and functions\u003c\/li\u003e \u003cli\u003eCreate and customize charts\u003c\/li\u003e \u003cli\u003eBuild sophisticated PivotTables\u003c\/li\u003e \u003cli\u003eWrite time-saving macros\u003c\/li\u003e \u003cli\u003eSecure your files with passwords\u003c\/li\u003e \u003cli\u003eShare your work with colleagues\u003c\/li\u003e \u003cli\u003eAvoid common Excel pitfalls\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47989182300389,"sku":"NP9781119832157","price":32.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119832157.jpg?v=1761783117","url":"https:\/\/k12savings.com\/es\/products\/excel-workbook-for-dummies-isbn-9781119832157","provider":"K12savings","version":"1.0","type":"link"}