My Excel 2016

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

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.

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



Updates

Submit Errata

