9780789755421

My Excel 2016 (includes Content Update Program)

by
  • ISBN13:

    9780789755421

  • ISBN10:

    0789755424

  • Edition: 1st
  • Format: Paperback
  • Copyright: 10/9/2015
  • Publisher: Que Publishing

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

Purchase Benefits

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

    TERM
    PRICE
    DUE

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 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.

Summary

Book + Content Update Program

My Excel 2016 is your must-have companion for getting most out of Excel 2016. This friendly, quick, full-color, 100% practical tutorial walks you through every task you'll want to do with Excel 2016.
  • Get productive fast with Excel 2016’s updated interface
  • Save time and make your data easier to work with
  • Efficiently enter, insert, move, and manage data
  • Use templates to reuse work and get a jumpstart on new projects
  • Format worksheets and charts to make them clearer and more useful
  • Use intuitive sparkline charts that fit in a single cell
  • Build custom formulas using powerful built-in functions
  • Sort, filter, and consolidate data and eliminate duplication
  • Instantly group data and generate subtotals
  • Quickly summarize huge data sets with PivotTables
  • Find, fix, and avoid errors that break spreadsheets or cause inaccuracies
  • Communicate more powerfully using visual tools such as SmartArt and WordArt
  • Precisely control what you print and how it looks
  • Securely share and distribute your workbooks
  • Use Excel on the Web wherever you have Internet access
Every task is presented step-by-step, using carefully annotated, colorful screenshots, all numbered so there's no chance of getting lost or confused. Everything's clearly organized in modular, self-contained chapters designed to help you get started quickly. Throughout, the book is packed with helpful tips, lists, and quick solutions to the problems you're most likely to encounter.

In addition, this book is part of Que’s exciting new Content Update Program. As Microsoft updates features of Excel 2016, sections of this book will be updated or new sections will be added to match the updates to the software. The updates will be delivered to you via a FREE Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit www.quepublishing.com/CUP.

How to access the web edition: Follow the instructions in the book to learn how to register your book to access the FREE Web Edition.

Author Biography

Tracy Syrstad is a Microsoft Excel developer and author of eight Excel books. She has been helping people with Microsoft Office issues since 1997 when she discovered free online forums where anyone could ask and answer questions. Tracy discovered she enjoyed teaching others new skills, and when she began working as a developer, she was able to integrate the fun of teaching with one-on-one online desktop sharing sessions. Tracy lives on an acreage in eastern South Dakota with her husband, one dog, two cats, one horse (two soon), and a variety of wild foxes, squirrels, and rabbits.

Table of Contents

Chapter 1 Understanding the Microsoft Excel Interface
Chapter 2 Working with Workbooks and Templates
Chapter 3 Getting Data Onto A Sheet
Chapter 4 Selecting and Moving Data On a Sheet
Chapter 5 Formatting Sheets and Cells
Chapter 6 Using Formulas
Chapter 7 Using Functions
Chapter 8 Sorting Data
Chapter 9 Filtering and Consolidating Data
Chapter 10 Distributing and Printing a Workbook
Chapter 11 Inserting SubTotals and Grouping Data
Chapter 12 Creating Charts and Sparklines
Chapter 13 Summarizing Data with PivotTables
Chapter 14 Inserting SmartArt, WordArt and Pictures
Chapter 15 An Introduction to Using Macros
Chapter 16 Using the Excel Web App to Collaborate on a Workbook
Appendix A: Q&A / FAQ
Appendix B:  Installing Optional Components
Appendix C: Troubleshooting the Excel Options

Rewards Program

Write a Review