My Excel 2016 (includes Content Update Program)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.
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. |
Contents
Introduction Chapter 1 Understanding the Microsoft Excel Interface | |
Working with Workbooks and Templates | |
Changing the Zoom on a Sheet | |
Working with Workbooks and Templates | |
Working with Sheets | |
Getting Data onto a Sheet | |
Getting Data onto a Sheet Chapter 5 Selecting and Moving Data on a Sheet Chapter 6 Formatting Sheets and Cells | |
Selecting and Moving Data on a Sheet | |
Advanced Formatting | |
Using Formulas | |
Using Functions | |
Sorting Data Chapter 11 Filtering and Consolidating Data Chapter 12 Distributing and Printing a Workbook | |
Inserting Subtotals and Grouping Data Chapter 14 Creating Charts and Sparklines | |
Summarizing Data with PivotTables | |
Inserting SmartArt WordArt and Pictures | |
Other editions - View all
Common terms and phrases
appears apply array formula arrow automatically calculate cell address chart choose click and drag Click File Click OK color column heading Conditional Formatting create Data tab dataset default delete Design tab dialog box doubleclick drop Edit error example field File to open fill handle Filter folder Format dropdown formula bar function Go Further header Hide Highlight Home tab Hyperlink icon Insert keyboard Keyboard Shortcuts merged cells Microsoft Excel mouse button Number Format OneDrive open Backstage view overwrite pane Paste Special pivot tables PivotTable Press Enter Quick Sort range you want resize ribbon Rightclick row height rows and columns rows or columns Save Select a cell select Sort Select the cell Select the desired Select the range selected range SmartArt Sort sparkline specific style subtotals theme Tools Total Row update WordArt workbook you’re