Excel 2016 Bible / John Walkenbach.

Format:

Book

Author/Creator:

Walkenbach, John, author.

Series:

Bible

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Electronic spreadsheets--Computer programs.

Electronic spreadsheets.

Physical Description:

1 online resource (1 volume) : illustrations

Edition:

1st edition

Other Title:

Excel 2016 bible

Place of Publication:

Hoboken, New Jersey : John Wiley & Sons, Inc., [2015]

System Details:

text file

Summary:

The complete guide to Excel 2016, from Mr. Spreadsheet himself Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2016 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2016's new features and tools Customize downloadable templates and worksheets Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2016 Bible has you covered with complete coverage and clear expert guidance.

Contents:

Cover

Title Page

Copyright

Contents

Acknowledgments

Introduction

Part I: Getting Started with Excel

Chapter 1: Introducing Excel

Identifying What Excel Is Good For

Seeing What's New in Excel 2016

Understanding Workbooks and Worksheets

Moving Around a Worksheet

Navigating with your keyboard

Navigating with your mouse

Using the Ribbon

Ribbon tabs

Contextual tabs

Types of commands on the Ribbon

Accessing the Ribbon by using your keyboard

Using Shortcut Menus

Customizing Your Quick Access Toolbar

Working with Dialog Boxes

Navigating dialog boxes

Using tabbed dialog boxes

Using Task Panes

Creating Your First Excel Workbook

Getting started on your worksheet

Filling in the month names

Entering the sales data

Formatting the numbers

Making your worksheet look a bit fancier

Summing the values

Creating a chart

Printing your worksheet

Saving your workbook

Chapter 2: Entering and Editing Worksheet Data

Exploring Data Types

Numeric values

Text entries

Formulas

Entering Text and Values into Your Worksheets

Entering Dates and Times into Your Worksheets

Entering date values

Entering time values

Modifying Cell Contents

Deleting the contents of a cell

Replacing the contents of a cell

Editing the contents of a cell

Learning some handy data-entry techniques

Automatically moving the cell pointer after entering data

Using navigation keys instead of pressing Enter

Selecting a range of input cells before entering data

Using Ctrl+Enter to place information into multiple cells simultaneously

Entering decimal points automatically

Using AutoFill to enter a series of values

Using AutoComplete to automate data entry

Forcing text to appear on a new line within a cell

Using AutoCorrect for shorthand data entry.

Entering numbers with fractions

Using a form for data entry

Entering the current date or time into a cell

Applying Number Formatting

Using automatic number formatting

Formatting numbers by using the Ribbon

Using shortcut keys to format numbers

Formatting numbers by using the Format Cells dialog box

Adding your own custom number formats

Chapter 3: Essential Worksheet Operations

Learning the Fundamentals of Excel Worksheets

Working with Excel windows

Moving and resizing windows

Switching among windows

Closing windows

Activating a worksheet

Adding a new worksheet to your workbook

Deleting a worksheet you no longer need

Changing the name of a worksheet

Changing a sheet tab color

Rearranging your worksheets

Hiding and unhiding a worksheet

Controlling the Worksheet View

Zooming in or out for a better view

Viewing a worksheet in multiple windows

Comparing sheets side by side

Splitting the worksheet window into panes

Keeping the titles in view by freezing panes

Monitoring cells with a Watch Window

Working with Rows and Columns

Inserting rows and columns

Deleting rows and columns

Changing column widths and row heights

Changing column widths

Changing row heights

Hiding rows and columns

Chapter 4: Working with Cells and Ranges

Understanding Cells and Ranges

Selecting ranges

Selecting complete rows and columns

Selecting noncontiguous ranges

Selecting multisheet ranges

Selecting special types of cells

Selecting cells by searching

Copying or Moving Ranges

Copying by using Ribbon commands

Copying by using shortcut menu commands

Copying by using shortcut keys

Copying or moving by using drag-and-drop

Copying to adjacent cells

Copying a range to other sheets

Using the Office Clipboard to paste.

Pasting in special ways

Using the Paste Special dialog box

Performing mathematical operations without formulas

Skipping blanks when pasting

Transposing a range

Using Names to Work with Ranges

Creating range names in your workbooks

Using the Name box

Using the New Name dialog box

Using the Create Names from Selection dialog box

Managing names

Adding Comments to Cells

Formatting comments

Changing a comment's shape

Reading comments

Printing comments

Hiding and showing comments

Selecting comments

Editing comments

Deleting comments

Chapter 5: Introducing Tables

What Is a Table?

Creating a Table

Changing the Look of a Table

Working with Tables

Navigating in a table

Selecting parts of a table

Adding new rows or columns

Deleting rows or columns

Moving a table

Working with the Total Row

Removing duplicate rows from a table

Sorting and filtering a table

Sorting a table

Filtering a table

Filtering a table with slicers

Converting a table back to a range

Chapter 6: Worksheet Formatting

Getting to Know the Formatting Tools

Using the formatting tools on the Home tab

Using the Mini toolbar

Using the Format Cells dialog box

Using Different Fonts to Format Your Worksheet

Changing Text Alignment

Choosing horizontal alignment options

Choosing vertical alignment options

Wrapping or shrinking text to fit the cell

Merging worksheet cells to create additional text space

Displaying text at an angle

Controlling the text direction

Using Colors and Shading

Adding Borders and Lines

Adding a Background Image to a Worksheet

Using Named Styles for Easier Formatting

Applying styles

Modifying an existing style

Creating new styles

Merging styles from other workbooks

Controlling styles with templates.

Understanding Document Themes

Applying a theme

Customizing a theme

Chapter 7: Understanding Excel Files

Creating a New Workbook

Opening an Existing Workbook

Filtering filenames

Choosing your file display preferences

Saving a Workbook

Using AutoRecover

Recovering versions of the current workbook

Recovering unsaved work

Configuring AutoRecover

Password-Protecting a Workbook

Organizing Your Files

Other Workbook Info Options

Protect Workbook options

Check for Issues options

Manage Versions options

Browser View options

Compatibility Mode section

Closing Workbooks

Safeguarding Your Work

Excel File Compatibility

Checking compatibility

Recognizing the Excel 2016 file formats

Saving a file for use with an older version of Excel

Chapter 8: Using and Creating Templates

Exploring Excel Templates

Viewing templates

Creating a workbook from a template

Modifying a template

Understanding Custom Excel Templates

Working with the default templates

Using the workbook template to change workbook defaults

Creating a worksheet template

Editing your template

Resetting the default workbook

Creating custom templates

Saving your custom templates

Using custom templates

Getting ideas for creating templates

Chapter 9: Printing Your Work

Basic Printing

Changing Your Page View

Normal view

Page Layout view

Page Break Preview

Adjusting Common Page Setup Settings

Choosing your printer

Specifying what you want to print

Changing page orientation

Specifying paper size

Printing multiple copies of a report

Adjusting the page margins

Understanding page breaks

Inserting a page break

Removing manual page breaks

Printing row and column titles

Scaling printed output

Printing cell gridlines.

Printing row and column headers

Using a background image

Adding a Header or a Footer to Your Reports

Selecting a predefined header or footer

Understanding header and footer element codes

Other header and footer options

Other Print-Related Topics

Copying Page Setup settings across Sheets

Preventing certain cells from being printed

Preventing objects from being printed

Creating custom views of your worksheet

Creating PDF files

Part II: Working with Formulas and Functions

Chapter 10: Introducing Formulas and Functions

Understanding Formula Basics

Using operators in formulas

Understanding operator precedence in formulas

Using functions in your formulas

Examples of formulas that use functions

Function arguments

More about functions

Entering Formulas into Your Worksheets

Entering formulas manually

Entering formulas by pointing

Pasting range names into formulas

Inserting functions into formulas

Function entry tips

Editing Formulas

Using Cell References in Formulas

Using relative, absolute, and mixed references

Changing the types of your references

Referencing cells outside the worksheet

Referencing cells in other worksheets

Referencing cells in other workbooks

Using Formulas in Tables

Summarizing data in a table

Using formulas within a table

Referencing data in a table

Correcting Common Formula Errors

Handling circular references

Specifying when formulas are calculated

Using Advanced Naming Techniques

Using names for constants

Using names for formulas

Using range intersections

Applying names to existing references

Working with Formulas

Not hard-coding values

Using the Formula bar as a calculator

Making an exact copy of a formula

Converting formulas to values.

Chapter 11: Creating Formulas That Manipulate Text.

Notes:

Description based on print version record.

ISBN:

9781523110704

1523110708

9781119067498

1119067499

OCLC:

952493356