Excel 2016: Up To Speed

The Excel 2016: Up To Speed guide helps you to get up and running quickly with the world’s most popular spreadsheet application. This handy step-by-step guide is written from scratch, starting with basic Excel topics and moving on to more advanced features of application, designed to help you to become more productive more quickly. Though comprehensive, the information in this book is presented in a clear, concise manner with screenshots providing helpful visual guidance all along the way.

In no time at all you’re be importing and exporting data, creating formulas, modifying and formatting spreadsheets, setting up and formatting data in tables, creating beautiful charts, adding and subtracting dates, creating impressive PivotTables, and much more.

Examining the Excel Environment

Opening an Existing Workbook

Navigating a Worksheet

Creating a New Workbook

Saving a New Workbook

Moving Between Workbooks

Setting Excel Options

Switching between Views

Using Tell Me to Obtain Help

Closing a Workbook and Exiting Excel

Entering Text and Numbers

Entering Numbers as Text

Changing Column Width:

Entering Simple Formulas

Choosing Formula Cell References

Using AutoSum

Total rows and columns at the same time using AutoSum

Changing & Deleting Data

Using Undo/Redo

Using Find and Replace

Using the Go To Command

Spell Checking Your Worksheet

Inserting Symbols

Using Smart Lookup

Working with Ranges

Copying and Pasting Data

Using the Office Clipboard

Cutting and Pasting Data

Copying and Moving Cells using Drag-And-Drop

Changing Column Width

Autofit

Changing Row Height

Inserting and Removing Rows and Columns

Copying Data and Formulas with AutoFill

Using AutoFill to Create a Series

Filling in Cells using Flash Fill

Formatting Text

Using the Format Cells Dialog Box

Formatting Values from the Ribbon

Formatting Numbers

Fractions

Using the Format Painter Button

Formatting Cells

Hiding and Freezing Rows and Columns

Inserting Headers and Footers

Working with Formulas & Functions

Using a Formula to Join the Contents of Multiple Cells

Combine Cells using the Ampersand

Combine cells using the CONCATENATE Function

Combine cells using the CONCAT Function

Joining Text with the TEXTJOIN Function

Pasting as Values

Modifying Workbooks

Adding and Deleting Worksheets

Copying Worksheets

Renaming Worksheets

Repositioning Worksheets

Grouping Worksheets

Changing Worksheet Tab Colors

Using 3-D Formulas & References

Creating a Table

Enter Data into a Table

Deleting Rows and Columns

Formatting a Table

Totaling Data in a Table

Sorting Data in a Table

Sorting Multiple Columns

Filtering Data using AutoFilter

Creating Custom Filters

Creating a Chart

Moving a Chart

Resizing a Chart

Changing the Layout and Style

Labeling Chart Elements

Formatting Chart Text

Formatting Chart Elements

Changing the Chart Type

Showing or Hiding Gridlines

Customizing Axes

Creating a Pie Chart

Changing a Chart’s Source Data

Moving a Chart to a Different Worksheet

Saving a Chart Template

Filtering Chart Data

Using Sparklines

Customizing Sparklines

Adding Pictures

Inserting Online Images

Adding Shapes

Formatting Drawing Objects

Inserting WordArt & SmartArt

Inserting & Modifying an Organization Chart

Taking a Screenshot

Using the IF Function

Using Nested Functions

The COUNTIF Function

Using the PMT Function

Using the FV Function

Using AutoCalculate

Understanding Date/Time Functions

And much more….

Table of Contents

Chapter 1 – Excel Basics
Chapter 2 – Working with Data
Chapter 3 – Editing a Worksheet
Chapter 4 – Formatting a Worksheet
Chapter 5 – Page Setup and Printing
Chapter 6 – Formulas and Functions
Chapter 7 – Using a Formula to Join the Contents of Multiple Cells
Chapter 8 – Modifying Workbooks
Chapter 9 – Working with Tables
Chapter 10 – Working with Charts
Chapter 11 – Working With Graphics
Chapter 12 – Financial & Logical Functions
Chapter 13 – Date and Time Functions
Chapter 14 – Managing Workbooks
Chapter 15 – Importing & Exporting Data
Chapter 16 – Formatting Numbers
Chapter 17 – Working with Ranges
Chapter 18 – Working with Macros
Chapter 19 – Data Analysis Tools
Chapter 20 – Summarizing Data
Chapter 21 – Analyzing Your Data
Chapter 22 – Collaborating with Others