My Excel 2016 : 9780789755421

My Excel 2016

Published by
Pearson Higher Ed USA
Available on demand
Title type
Title type

Full-color, step-by-step tasks walk you through everything you want to do with Excel 2016.

Step-by-step instructions with callouts to Excel 2016 screenshots that show you exactly what to do.

Help when you run into Excel 2016 problems or limitations.

Tips and Notes to help you get the most from Excel 2016.

  • Quickly find and use the Excel 2013 features you’re looking for
  • Create, save, and organize your spreadsheets
  • Build custom formulas using Excel’s powerful built-in functions
  • Master time-saving techniques to find, replace, move, filter, and sort data
  • Find, fix, and avoid errors that break spreadsheets or cause inaccuracies
  • Create a unique look and feel for your spreadsheets with formatting
  • Generate powerful charts and visualizations with Excel’s new tools
  • Insert images, shapes, SmartArt, and even org charts
  • Precisely control what you print and how it looks
  • Secure your spreadsheets and control who can view or edit them
  • Use improved PivotTables to analyze huge amounts of data
  • Store and share workbooks on the Web with SkyDrive
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
New to this edition
New author and coverage of features new to Excel 2016.
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.
Sample Pages
Download the sample pages (includes Chapter 10 and Index)