SmartSellTM - The New Way to Sell Online

Shop over a million Toys in our Huge New Range

Excel 2016 All-In-One for Dummies


Product Description
Product Details

Table of Contents

Introduction 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

About the Author

Greg Harvey, PhD, is the president of Mind Over Media, LLC., and a bestselling author of books on Excel, including all editions of Excel For Dummies and Excel Workbook For Dummies. He began teaching business users about computers back in the 1980s, and has been a dedicated educator ever since.

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Excel 2016 All-In-One for Dummies on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond World Ltd.
Back to top