{"product_id":"excel-2016-allinone-for-dummies-9781119077152","title":"Excel 2016 AllinOne For Dummies","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003eYour one-stop guide to all things Excel 2016   Excel 2016 All-in-One For Dummies, the most comprehensive Excel reference on the market, is completely updated to reflect Microsoft's changes in the popular spreadsheet tool.\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003eIntroduction 1    Book I: Excel Basics 11    Chapter 1: The Excel 2016 User Experience 13    Chapter 2: Customizing Excel 2016 43    Book II: Worksheet Design 75    Chapter 1: Building Worksheets 77    Chapter 2: Formatting Worksheets 127    Chapter 3: Editing and Proofing Worksheets 185    Chapter 4: Managing Worksheets 233    Chapter 5: Printing Worksheets 269    Book III: Formulas and Functions 297    Chapter 1: Building Basic Formulas 299    Chapter 2: Logical Functions and Error Trapping 341    Chapter 3: Date and Time Formulas 363    Chapter 4: Financial Formulas 379    Chapter 5: Math and Statistical Formulas 393    Chapter 6: Lookup, Information, and Text Formulas 413    Book IV: Worksheet Collaboration and Review 435    Chapter 1: Protecting Workbooks and Worksheet Data 437    Chapter 2: Using Hyperlinks 459    Chapter 3: Sending Workbooks Out for Review 467    Chapter 4: Sharing Workbooks and Worksheet Data 495    Book V: Charts and Graphics 519    Chapter 1: Charting Worksheet Data 521    Chapter 2: Adding Graphic Objects 553    Book VI: Data Management 581    Chapter 1: Building and Maintaining Data Lists 583    Chapter 2: Filtering and Querying a Data List 607    Book VII: Data Analysis 649    Chapter 1: Performing What-If Scenarios 651    Chapter 2: Performing Large-Scale Data Analysis 675    Book VIII: Macros and VBA 721    Chapter 1: Recording and Running Macros 723    Chapter 2: VBA Programming 735    Index 759","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49083839709527,"sku":"9781119077152","price":23.79,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0817\/1739\/5799\/files\/9781119077152.jpg?v=1725550180","url":"https:\/\/bookcurl.com\/products\/excel-2016-allinone-for-dummies-9781119077152","provider":"Book Curl","version":"1.0","type":"link"}