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.
Table of contents
- About This eBook
- Title Page
- Copyright Page
- Contents at a Glance
- Table of Contents
- About the Author
- Dedication
- Acknowledgments
- We Want to Hear from You!
- Reader Services
- Introduction
- 1. Understanding the Microsoft Excel Interface
- 2. Working with Workbooks and Templates
- 3. Working with Sheets
-
4. Getting Data onto a Sheet
- Entering Different Types of Data into a Cell
- Using Lists to Quickly Fill a Range
- Using Paste Special
- Using Text to Columns to Separate Data in a Single Column
- Using Data Validation to Limit Data Entry in a Cell
- Using Web Queries to Get Data onto a Sheet
- Editing Data
- Clearing the Contents of a Cell
- Clearing an Entire Sheet
- Working with Tables
- Fixing Numbers Stored as Text
- Spell Checking a Sheet
- Finding Data on a Sheet
- 5. Selecting and Moving Data on a Sheet
-
6. Formatting Sheets and Cells
- Changing the Font Settings of a Cell
- Adjusting the Row Height
- Adjusting the Column Width
- Aligning Text in a Cell
- Merging Two or More Cells
- Centering Text Across Multiple Cells
- Wrapping Text in a Cell to the Next Line
- Reflowing Text in a Paragraph
- Indenting Cell Contents
- Applying Number Formats
- Adding a Border Around a Range
- Coloring the Inside of a Cell
- 7. Advanced Formatting
- 8. Using Formulas
- 9. Using Functions
- 10. Sorting Data
- 11. Filtering and Consolidating Data
-
12. Distributing and Printing a Workbook
- Using Cell Comments to Add Notes to Cells
- Allowing Multiple Users to Edit a Workbook at the Same Time
- Hiding and Unhiding Sheets
- Using Freeze Panes
- Configuring the Page Setup
- Creating a Custom Header or Footer
- Printing Sheets
- Protecting a Workbook from Unwanted Changes
- Protecting the Data on a Sheet
- Preventing Changes by Marking a File as Final
- Sharing Files Between Excel Versions
- Recovering Lost Changes
- Sending an Excel File as an Attachment
- Sharing a File Online
- 13. Inserting Subtotals and Grouping Data
- 14. Creating Charts and Sparklines
-
15. Summarizing Data with PivotTables
- Creating a PivotTable
- Changing the PivotTable Layout
- PivotTable Sorting
- Expanding and Collapsing Fields
- Grouping Dates
- Filtering Data in a PivotTable
- Creating a Calculated Field
- Hiding Totals
- Viewing the Records Used to Calculate a Value
- Unlinking PivotTables
- Refreshing the PivotTable
- Working with Slicers
- 16. Inserting SmartArt, WordArt, and Pictures
- 17. Introducing the Excel Web App
- Index
Product information
- Title: My Excel 2016
- Author(s):
- Release date: October 2015
- Publisher(s): Que
- ISBN: 9780134217192
You might also like
book
John Walkenbach's Favorite Excel 2010 Tips and Tricks
Build robust Excel 2010 apps quickly and efficiently Known as "Mr. Spreadsheet," John Walkenbach's name is …
book
iWork '09: The Missing Manual
With iWork '09, Apple's productivity applications have come of age. Unfortunately, their user guides are stuck …
book
Word 2013 Bible
Top-to-bottom coverage of the top-selling Microsoft Office application If you want to use Microsoft Word to …
book
Microsoft® SharePoint® Designer 2010 Unleashed
Microsoft has transformed SharePoint Designer into a free download: now, here's the first comprehensive guide to …