My Excel 2016

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

Content

Chapter 1. Understanding the Microsoft Excel Interface
Chapter 2. Working with Workbooks and Templates
Chapter 3. Working with Sheets
Chapter 4. Getting Data onto a Sheet
Chapter 5. Selecting and Moving Data on a Sheet
Chapter 6. Formatting Sheets and Cells
Chapter 7. Advanced Formatting
Chapter 8. Using Formulas
Chapter 9. Using Functions
Chapter 10. Sorting Data
Chapter 11. Filtering and Consolidating Data
Chapter 12. Distributing and Printing a Workbook
Chapter 13. Inserting Subtotals and Grouping Data
Chapter 14. Creating Charts and Sparklines
Chapter 15. Summarizing Data with PivotTables
Chapter 16. Inserting SmartArt, WordArt, and Pictures
Chapter 17. Introducing the Excel Web App