Video Library

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

Chapter 7

Named References

Chapter 8

Tables

Chapter 9

Data Validation

Chapter 10

Conditional Formatting Basics

Chapter 11

Better Summing

Chapter 12

Skinny Row

Chapter 13

Hide Worksheets

Chapter 14

Highlight Input Cells

Chapter 17

Nested Functions

Chapter 18

Selection Groups

 

Volume 2 Solutions Videos

Chapter 2

Selected Shortcuts

Chapter 3

Conditional Summing Basics

Chapter 4

Remove Duplicates

Chapter 5

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

Chapter 10

The IF Function

Chapter 11

List Comparisons

Chapter 12

The ISERROR Function

Chapter 13

Multicolumn List Comparisons with COUNTIFS

Chapter 14

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 21

Dynamic Headers

Chapter 22

Horizontal Reports

Chapter 23

Mapping Tables

Chapter 24

Data Validation and Reporting

Chapter 25

Improve Error Check

Chapter 26

Concepts Applied

 

Volume 3 Solutions Videos

Chapter 2

Selected Shortcuts

Chapter 3

PivotTable Basics

Chapter 4

Row Fields

Chapter 5

Value Fields

Chapter 6

Column Fields

Chapter 7

Filter Fields

Chapter 8

Updating Data

Chapter 9

Groups and Subtotals

Chapter 10

Value Formats

Chapter 11

Report Type Comparison

Chapter 12

Options

Chapter 13

Report Layout and Design

Chapter 14

Multiple Value Fields

Chapter 15

Calculated Fields

Chapter 16

Calculated Items

Chapter 17

Show Values As

Chapter 18

Sorting

Chapter 19

Filtering

Chapter 20

Hybrid Reports with GETPIVOTDATA

Chapter 21

Web Data

Chapter 22

External Data

Chapter 23

Text Files

Chapter 24

Data Preparation

Chapter 25

Accounting System Data

Chapter 26

Getting Graphic

 

Volume 4 Solutions Videos

Chapter 2

Selected Shortcuts

Chapter 3

Sorting and Filtering

Chapter 4

Outlining

Chapter 5

Formatting

Chapter 6

Printing

Chapter 7

Protecting

Chapter 8

Hyperlink Feature

Chapter 9

HYPERLINK Function

Chapter 10

IF Alternatives

Chapter 11

Lookup Functions

Chapter 12

Text Functions

Chapter 13

Date Functions

Chapter 14

Insert Function

Chapter 15

Ribbon Review

Chapter 16

Conditional Formatting Revisited

Chapter 17

Names Revisited

Chapter 18

Wildcards Revisited

Chapter 19

Tables Revisited

Chapter 20

Start Here Revisited

Chapter 21

JE Preparation

Chapter 22

Budget Ideas

Chapter 23

Common Workpapers