Intermediate Microsoft Excel 2013

#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

Exercise: Using Named Ranges in Formulas

Using Formulas That Span Multiple Worksheets

Exercise: Entering a Formula Using Data in Multiple Worksheets

Using the IF Function

Using AND/OR Functions

Using the SUMIF, AVERAGEIF, and COUNTIF Functions

Exercise: Using the IF Function

Using the PMT Function

Exercise: Using the PMT Function

Using the LOOKUP Function

Using the VLOOKUP Function

Exercise: Using the VLOOKUP Function

Using the HLOOKUP Function

Using the CONCATENATE Function

Exercise: Using the CONCATENATE Function

Using the TRANSPOSE Function

Using the PROPER, UPPER, and LOWER Functions

The UPPER Function

The LOWER function

The TRIM Function

Exercise: Using the PROPER Function

Using the LEFT, RIGHT, and MID Functions

The MID Function

Exercise: Using the LEFT and RIGHT Functions

Using Date Functions

Using the NOW and TODAY Functions

Exercise: Using the YEAR, MONTH, and DAY Functions

Creating Scenarios

Utilize the Watch Window

Consolidate Data

Enable Iterative Calculations

What-If Analyses

Use the Scenario Manager

Use Financial Functions

Working with Lists

Converting a List to a Table

Exercise: Converting a List to a Table

Removing Duplicates from a List

Exercise: Removing Duplicates from a List

Sorting Data in a List

Exercise: Sorting Data in a List

Filtering Data in a List

Exercise: Filtering Data in a List

Adding Subtotals to a List

Grouping and Ungrouping Data in a List

Exercise: Adding Subtotals to a List

Working with Illustrations

Working with Clip Art

Exercise: Working with Clip Art

Using Shapes

Exercise: Adding Shapes

Working with SmartArt

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

Visualizing Your Data

Inserting Charts

Exercise: Inserting Charts

Editing Charts

Changing the Layout of a Chart

Changing the Style of a Chart

Adding a Shape to a Chart

Adding a Trendline to a Chart

Adding a Secondary Axis 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

Watching Animation in a Chart

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

Exercise: Editing Charts

Add and Format Objects

Insert a Text Box

Create a Custom Chart Template

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

Exercise: Creating and Modifying a Table in Excel

Advanced Formatting

Applying Conditional Formatting

Exercise: Using Conditional Formatting

Working with Styles

Applying Styles to Tables

Applying Styles to Cells

Exercise: Working with Styles

Creating and Modifying Templates

Modify a Custom Template

Microsoft Excel 2013 New Features

New Functions in Excel 2013

Exercise: Using the New Excel Functions

Using New Chart Tools

Exercise: Using the New Excel 2013 Chart Tools

Using the Quick Analysis Tool

Exercise: Using the Quick Analysis Tool

Using the Chart Recommendation Feature