Excel 2016 All–In–One For Dummies
Samenvatting
Your 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. 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.
Written 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.
Serves as the ideal reference for solving common questions and Excel pain points quickly and easily
Helps to increase productivity and efficiency when working in Excel
Fully updated for the new version of Excel
Covers basic and more advanced Excel topics
If 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.
Specificaties
Inhoudsopgave
<p>Book I: Excel Basics 11</p>
<p>Chapter 1: The Excel 2016 User Experience 13</p>
<p>Chapter 2: Customizing Excel 2016 43</p>
<p>Book II: Worksheet Design 75</p>
<p>Chapter 1: Building Worksheets 77</p>
<p>Chapter 2: Formatting Worksheets 127</p>
<p>Chapter 3: Editing and Proofing Worksheets 185</p>
<p>Chapter 4: Managing Worksheets 233</p>
<p>Chapter 5: Printing Worksheets 269</p>
<p>Book III: Formulas and Functions 297</p>
<p>Chapter 1: Building Basic Formulas 299</p>
<p>Chapter 2: Logical Functions and Error Trapping 341</p>
<p>Chapter 3: Date and Time Formulas 363</p>
<p>Chapter 4: Financial Formulas 379</p>
<p>Chapter 5: Math and Statistical Formulas 393</p>
<p>Chapter 6: Lookup, Information, and Text Formulas 413</p>
<p>Book IV: Worksheet Collaboration and Review 435</p>
<p>Chapter 1: Protecting Workbooks and Worksheet Data 437</p>
<p>Chapter 2: Using Hyperlinks 459</p>
<p>Chapter 3: Sending Workbooks Out for Review 467</p>
<p>Chapter 4: Sharing Workbooks and Worksheet Data 495</p>
<p>Book V: Charts and Graphics 519</p>
<p>Chapter 1: Charting Worksheet Data 521</p>
<p>Chapter 2: Adding Graphic Objects 553</p>
<p>Book VI: Data Management 581</p>
<p>Chapter 1: Building and Maintaining Data Lists 583</p>
<p>Chapter 2: Filtering and Querying a Data List 607</p>
<p>Book VII: Data Analysis 649</p>
<p>Chapter 1: Performing What–If Scenarios 651</p>
<p>Chapter 2: Performing Large–Scale Data Analysis 675</p>
<p>Book VIII: Macros and VBA 721</p>
<p>Chapter 1: Recording and Running Macros 723</p>
<p>Chapter 2: VBA Programming 735</p>
<p>Index 759</p>