Register your product to gain access to bonus material or receive a coupon.
My Excel 2016
- By Tracy Syrstad
- Published Oct 8, 2015 by Que. Part of the My... series.
EPUB (Watermarked)
- Sorry, this book is no longer in print.
- About Watermarked eBooks
This EPUB will be accessible from your Account page after purchase.
This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.
Description
- Copyright 2016
- Dimensions: 6" x 9"
- Edition: 1st
- EPUB (Watermarked)
- ISBN-10: 0-13-421720-9
- ISBN-13: 978-0-13-421720-8
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.
- 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
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.
Sample Content
Table of Contents
Introduction 1
What’s in This Book 2
Guidance for Beginners 2
Chapter 1: Understanding the Microsoft Excel Interface 5
Identifying Parts of the Excel Window 6
Using the Built-in Help 8
Perform a Search 9
Making Selections from the Ribbon 10
Customizing the Ribbon 10
Minimize the Ribbon Size 11
Add More Commands to the Ribbon 12
Customizing the QAT 15
Move the QAT to a New Location 15
Add More Commands to the QAT 15
Viewing Multiple Sheets at the Same Time 16
Arrange Multiple Sheets 17
Scroll Two Sheets Side by Side 18
Changing the Zoom on a Sheet 19
Use Excel’s Zoom Controls 19
Moving Around on a Sheet 20
Keyboard Shortcuts for Quicker Navigation 20
Selecting a Range of Cells 21
Select a Range Using the Mouse 21
Chapter 2: Working with Workbooks and Templates 25
Managing Workbooks 25
Create a New Workbook 26
Open an Existing Workbook 26
Use the Recent Workbooks List 27
Save a Workbook 28
Close a Workbook 30
Using Templates to Quickly Create New Workbooks 30
Use Microsoft’s Online Templates 31
Save a Template 32
Open a Locally Saved Template to Enter Data 33
Edit the Design of a Locally Saved Template 34
Change Personal Templates Location 35
Chapter 3: Working with Sheets 37
Adding and Deleting Sheets 37
Add a New Sheet 38
Delete a Sheet 38
Navigating and Selecting Sheets 39
Activate Another Sheet 39
Select Multiple Sheets 40
Moving or Copying Sheets 40
Move or Copy a Sheet in the Same Workbook 41
Move or Copy a Sheet Between Workbooks 42
Renaming a Sheet 43
Change a Sheet’s Name 43
Chapter 4: Getting Data onto a Sheet 45
Entering Different Types of Data into a Cell 46
Type Numbers or Text into a Cell 46
Enter Numbers as Text 47
Type Dates and Times into a Cell 48
Undo an Entry 49
Using Lists to Quickly Fill a Range 50
Extend a Series Containing Text 50
Extend a Numerical Series 51
Create Your Own List 53
Using Paste Special 55
Paste Values Only 55
Combine Multiple Paste Special Options 57
Multiply the Range by a Specific Value 60
Use Paste to Merge a Noncontiguous Selection 63
Using Text to Columns to Separate Data in a Single Column 64
Work with Delimited Text 64
Using Data Validation to Limit Data Entry in a Cell&nb
More Information
Other Things You Might Like
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot
- eBook $35.19