Intermediate Microsoft Excel 2016

#text-block-10 { margin-bottom:0px; text-align:left; }

Advanced Formulas

Using Named Ranges in Formulas

Naming a Single Cell

Naming a Range of Cells

Naming Multiple Single Cells Quickly

Using Formulas That Span Multiple Worksheets

Using the IF Function

Using the SUMIF, AVERAGEIF, and COUNTIF Functions

Using the PMT Function

Using the VLOOKUP Function

Using the HLOOKUP Function

Using the CONCATENATE Function

Using the PROPER, UPPER, and LOWER Functions

The UPPER Function

The LOWER function

The TRIM Function

Using the LEFT, RIGHT, and MID Functions

The MID Function

Using Date Functions

Working with Lists

Converting a List to a Table

Removing Duplicates from a List

Sorting Data in a List

Filtering Data in a List

Adding Subtotals to a List

Grouping and Ungrouping Data in a List

#text-block-11 { margin-bottom:0px; text-align:left; }

Working with Illustrations

Working with Clip Art

Using Shapes

Working with SmartArt

Visualizing Your Data

Inserting Charts

Editing Charts

Changing the Layout of a Chart

Changing the Style of a Chart

Adding a Shape to a Chart

Adding Additional Data Series to a Chart

Switch between Rows and Columns in a Chart

Positioning a Chart

Modifying Chart and Graph Parameters

Showing, Hiding, or Changing the Location of the Legend in a Chart

Show or Hiding the Title of a Chart

Changing the Title of a Chart

Show, Hiding, or Changing the Location of Data Labels in a Chart

Changing the Style of Pieces of a Chart

Add and Format Objects

Insert a Text Box

Working with Tables

Format Data as a Table

Move between Tables and Ranges

Modify Tables

Add and Remove Cells within a Table

Define Titles

Band Rows and Columns

Remove Styles from Tables

Advanced Formatting

Applying Conditional Formatting

Working with Styles

Applying Styles to Tables

Applying Styles to Cells

Microsoft Excel New Features

New Functions in Excel

Using New Chart Tools

Using the Quick Analysis Tool

Using the Chart Recommendation Feature