did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9781119077152

Microsoft Excel 2016

by
  • ISBN13:

    9781119077152

  • ISBN10:

    111907715X

  • Format: Paperback
  • Copyright: 2015-11-16
  • Publisher: For Dummies

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $39.99 Save up to $15.30
  • Rent Book $24.69
    Add to Cart Free Shipping Icon Free Shipping

    TERM
    PRICE
    DUE
    USUALLY SHIPS IN 24-48 HOURS
    *This item is part of an exclusive publisher rental program and requires an additional convenience fee. This fee will be reflected in the shopping cart.

Supplemental Materials

What is included with this book?

Summary

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.

Author Biography

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.

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

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program