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