9780735698802

Microsoft Excel 2016 Step by Step

by
  • ISBN13:

    9780735698802

  • ISBN10:

    0735698805

  • Edition: 1st
  • Format: Paperback
  • Copyright: 10/8/2015
  • Publisher: Microsoft Press

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: $34.99 Save up to $5.25
  • Rent Book $31.49
    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

Now in full color!


The quick way to learn Microsoft Excel 2016!

This is learning made easy. Get more done quickly with Excel 2016. Jump in wherever you need answers--brisk lessons and full-color screen shots show you exactly what to do, step by step.

  • Quickly set up workbooks, enter data, and format it for easier viewing
  • Perform calculations and find and correct errors
  • Filter, sort, summarize, and combine data
  • Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver
  • Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps
  • Build data models and use them in business intelligence analyses
  • Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps
  • Look up just the tasks and lessons you need

Author Biography

Curtis Frye is the author of more than 30 books, including Microsoft Excel 2013 Step by Step for Microsoft Press and Brilliant Excel VBA Programming for Pearson, UK. He has also created and recorded more than three dozen courses for lynda.com, including Excel for Mac 2016 Essential Training and Excel 2013: PivotTables in Depth. In addition to his work as a writer, Curt is a popular conference speaker and performer, both as a solo presenter and as part of the Portland, Oregon ComedySportz improvisational comedy troupe. He lives in Portland with his wife and three cats.

Table of Contents

1. Setting Up a Workbook
2. Working with Data and Excel Tables
3. Performing Calculations on Data
4. Changing Workbook Appearance
5. Focusing on Specific Data by Using Filters
6. Reordering and Summarizing Data
7. Combining Data from Multiple Sources
8. Analyzing Data Sets
9. Creating Charts and Graphics
10. Creating Dynamic Worksheets by Using PivotTables and PivotCharts
11. Printing
12. Automating Repetitive Tasks by Using Macros
13. Working with Other Microsoft Office Programs
14. Collaborating with Colleagues

Rewards Program

Write a Review