# Excel University Video Library

This video library accompanies the Excel University series. The videos provide the solutions to the various exercise workbooks provided with each volume. Click the play icon to view the desired video. The exercise workbooks can be downloaded from the Excel University download library. The videos are best viewed by setting the Change Quality icon in the player to HD (720p).

## Volume 1 Solutions Videos

#### Chapter 6

Selected Shortcuts

Named References

Tables

Data Validation

#### Chapter 10

Conditional Formatting Basics

Better Summing

Skinny Row

Hide Worksheets

#### Chapter 14

Highlight Input Cells

Nested Functions

Selection Groups

## Volume 2 Solutions Videos

#### Chapter 2

Selected Shortcuts

#### Chapter 3

Conditional Summing Basics

#### Chapter 4

Remove Duplicates

Lookup Basics

#### Chapter 6

Improve VLOOKUP with MATCH

#### Chapter 7

Improve VLOOKUP with TEXT and VALUE

#### Chapter 8

Moving Beyond VLOOKUP with INDEX

#### Chapter 9

Trap Errors with IFERROR

The IF Function

List Comparisons

#### Chapter 12

The ISERROR Function

#### Chapter 13

Multicolumn List Comparisons with COUNTIFS

Indentation

#### Chapter 15

Perform Lookups with SUMIFS

#### Chapter 16

Determine the Last Day of the Month with EOMONTH

#### Chapter 17

Date Parts – MONTH and YEAR

#### Chapter 18

Build Your Own Date with DATE

#### Chapter 19

Concatenation Basics

#### Chapter 20

Improve SUMIFS with CONCATENATE

#### Chapter 22

Horizontal Reports

Mapping Tables

#### Chapter 24

Data Validation and Reporting

#### Chapter 25

Improve Error Check

Concepts Applied

## Volume 3 Solutions Videos

#### Chapter 2

Selected Shortcuts

#### Chapter 3

PivotTable Basics

Row Fields

Value Fields

Column Fields

Filter Fields

Updating Data

#### Chapter 9

Groups and Subtotals

Value Formats

#### Chapter 11

Report Type Comparison

Options

#### Chapter 13

Report Layout and Design

#### Chapter 14

Multiple Value Fields

#### Chapter 15

Calculated Fields

Calculated Items

Show Values As

Sorting

Filtering

#### Chapter 20

Hybrid Reports with GETPIVOTDATA

Web Data

External Data

Text Files

Data Preparation

#### Chapter 25

Accounting System Data

Getting Graphic

## Volume 4 Solutions Videos

#### Chapter 2

Selected Shortcuts

#### Chapter 3

Sorting and Filtering

Outlining

Formatting

Printing

Protecting

IF Alternatives

Lookup Functions

Text Functions

Date Functions

Insert Function

Ribbon Review

#### Chapter 16

Conditional Formatting Revisited

Names Revisited

#### Chapter 18

Wildcards Revisited

Tables Revisited

#### Chapter 20

Start Here Revisited

JE Preparation

Budget Ideas

#### Chapter 23

Common Workpapers