Microsoft Excel 2016 Step by Step

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

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.

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

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.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Microsoft Excel 2016 Step by Step

Summary

Author Biography

Table of Contents

Supplemental Materials