{"product_id":"excel-2016-all-in-one-for-dummies-isbn-9781119077152","title":"Excel 2016 All-in-One For Dummies","description":"\u003cb\u003eYour one-stop guide to all things Excel 2016\u003c\/b\u003e \u003cp\u003e\u003ci\u003eExcel 2016 All-in-One For Dummies\u003c\/i\u003e, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool. It offers you everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic—and beyond. In no time, your Excel skills will go from 'meh' to excellent. \u003c\/p\u003e\u003cp\u003eWritten by expert Greg Harvey, who has sold more than 4.5 million copies of his previous books combined and has taught and trained extensively in Microsoft Excel, this all-encompassing guide offers everything you need to get started with Excel. From generating pivot tables and performing financial functions to performing error trapping and building and running macros—and everything in between—this hands-on, friendly guide makes working with Excel easier than ever before. \u003c\/p\u003e\u003cul\u003e \u003cli\u003eServes as the ideal reference for solving common questions and Excel pain points quickly and easily\u003c\/li\u003e \u003cli\u003eHelps to increase productivity and efficiency when working in Excel\u003c\/li\u003e \u003cli\u003eFully updated for the new version of Excel\u003c\/li\u003e \u003cli\u003eCovers basic and more advanced Excel topics\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eIf working in Excel occasionally makes you want to scream, this will be the dog-eared, dust-free reference you'll turn to again and again. \u003c\/p\u003e\u003cp\u003eIntroduction 1\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook I: Excel Basics 11\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: The Excel 2016 User Experience 13\u003c\/p\u003e \u003cp\u003eChapter 2: Customizing Excel 2016 43\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook II: Worksheet Design 75\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Building Worksheets 77\u003c\/p\u003e \u003cp\u003eChapter 2: Formatting Worksheets 127\u003c\/p\u003e \u003cp\u003eChapter 3: Editing and Proofing Worksheets 185\u003c\/p\u003e \u003cp\u003eChapter 4: Managing Worksheets 233\u003c\/p\u003e \u003cp\u003eChapter 5: Printing Worksheets 269\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook III: Formulas and Functions 297\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Building Basic Formulas 299\u003c\/p\u003e \u003cp\u003eChapter 2: Logical Functions and Error Trapping 341\u003c\/p\u003e \u003cp\u003eChapter 3: Date and Time Formulas 363\u003c\/p\u003e \u003cp\u003eChapter 4: Financial Formulas 379\u003c\/p\u003e \u003cp\u003eChapter 5: Math and Statistical Formulas 393\u003c\/p\u003e \u003cp\u003eChapter 6: Lookup, Information, and Text Formulas 413\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook IV: Worksheet Collaboration and Review 435\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Protecting Workbooks and Worksheet Data 437\u003c\/p\u003e \u003cp\u003eChapter 2: Using Hyperlinks 459\u003c\/p\u003e \u003cp\u003eChapter 3: Sending Workbooks Out for Review 467\u003c\/p\u003e \u003cp\u003eChapter 4: Sharing Workbooks and Worksheet Data 495\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook V: Charts and Graphics 519\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Charting Worksheet Data 521\u003c\/p\u003e \u003cp\u003eChapter 2: Adding Graphic Objects 553\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook VI: Data Management 581\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Building and Maintaining Data Lists 583\u003c\/p\u003e \u003cp\u003eChapter 2: Filtering and Querying a Data List 607\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook VII: Data Analysis 649\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Performing What-If Scenarios 651\u003c\/p\u003e \u003cp\u003eChapter 2: Performing Large-Scale Data Analysis 675\u003c\/p\u003e \u003cp\u003e\u003cb\u003eBook VIII: Macros and VBA 721\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eChapter 1: Recording and Running Macros 723\u003c\/p\u003e \u003cp\u003eChapter 2: VBA Programming 735\u003c\/p\u003e \u003cp\u003eIndex 759\u003c\/p\u003e   \u003cp\u003e\u003cb\u003eGreg Harvey, PhD,\u003c\/b\u003e is the president of Mind Over Media, LLC., and a bestselling author of books on Excel, including all editions of \u003ci\u003eExcel For Dummies\u003c\/i\u003e and \u003ci\u003eExcel Workbook For Dummies\u003c\/i\u003e. He began teaching business users about computers back in the 1980s, and has been a dedicated educator ever since.     \u003c\/p\u003e\u003cp\u003e\u003cb\u003e8 BOOKS IN 1\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eExcel Basics\u003c\/li\u003e \u003cli\u003eWorksheet Design\u003c\/li\u003e \u003cli\u003eFormulas and Functions\u003c\/li\u003e \u003cli\u003eWorksheet Collaboration and Review\u003c\/li\u003e \u003cli\u003eCharts and Graphics\u003c\/li\u003e \u003cli\u003eData Management\u003c\/li\u003e \u003cli\u003eData Analysis\u003c\/li\u003e \u003cli\u003eMacros and VBA \u003c\/li\u003e \u003c\/ul\u003e  \u003cp\u003e\u003cb\u003eGet up to speed right away with the all-new, all-powerful Excel 2016\u003c\/b\u003e  \u003c\/p\u003e\u003cp\u003eExcel, the #1 spreadsheet tool used by millions, has undergone a massive makeover. Each of the self-contained minibooks in this easy-to-follow guide covers one important area of Excel 2016. Find out how to make the most of your worksheets, create eye-popping charts, analyze data like a pro, and even customize Excel with VBA programming!  \u003c\/p\u003e\u003cul\u003e \u003cli\u003e\n\u003cb\u003eStart here\u003c\/b\u003e — if you're new to Excel, Book I covers all the essentials\u003c\/li\u003e  \u003cli\u003e\n\u003cb\u003eWorksheet 101\u003c\/b\u003e — learn to enter data and build, format, print, and manage worksheets in Book II\u003c\/li\u003e  \u003cli\u003e\n\u003cb\u003eGetting functional\u003c\/b\u003e — Book III shows you how to build formulas to calculate just about anything\u003c\/li\u003e  \u003cli\u003e\n\u003cb\u003eLet's team up\u003c\/b\u003e — see how to share spreadsheets safely with other people and programs in Book IV\u003c\/li\u003e  \u003cli\u003e\n\u003cb\u003eCharts and graphs\u003c\/b\u003e — in Book V, find out how to choose and create the ideal visual representation for your data\u003c\/li\u003e  \u003cli\u003e\n\u003cb\u003eWhat to do with it\u003c\/b\u003e — discover in Book VI how to maintain, filter, query, and manage volumes of data\u003c\/li\u003e  \u003cli\u003e\n\u003cb\u003eAnalyze everything\u003c\/b\u003e — Book VII shows you amazing ways to analyze data and summarize it with pivot tables\u003c\/li\u003e  \u003cli\u003e\n\u003cb\u003eMacro mania\u003c\/b\u003e — learn to automate common tasks with macros and create custom user-defined functions in Book VIII\u003c\/li\u003e  \u003c\/ul\u003e  \u003cp\u003e\u003cb\u003eOpen the book and find:\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e \u003cli\u003eTips for using Excel on a touchscreen device\u003c\/li\u003e \u003cli\u003eHow to customize the Ribbon and the Quick Access toolbar\u003c\/li\u003e \u003cli\u003eAdvice on editing spreadsheets\u003c\/li\u003e \u003cli\u003eWays to find and eliminate formula errors\u003c\/li\u003e \u003cli\u003eSecrets of sharing on OneDrive\u003ci\u003e\u003csup\u003e®\u003c\/sup\u003e\u003c\/i\u003e\n\u003c\/li\u003e \u003cli\u003eSteps for querying your data\u003c\/li\u003e \u003cli\u003eAll about Office and Excel Add-ins\u003c\/li\u003e \u003c\/ul\u003e","brand":"For Dummies","offers":[{"title":"Default Title","offer_id":47989181710565,"sku":"NP9781119077152","price":39.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9781119077152.jpg?v=1761783116","url":"https:\/\/k12savings.com\/products\/excel-2016-all-in-one-for-dummies-isbn-9781119077152","provider":"K12savings","version":"1.0","type":"link"}