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 10
Conditional Formatting Basics
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 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 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 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 9
Groups and Subtotals
Chapter 11
Report Type Comparison
Chapter 13
Report Layout and Design
Chapter 14
Multiple Value Fields
Chapter 15
Calculated Fields
Chapter 16
Calculated Items
Chapter 20
Hybrid Reports with GETPIVOTDATA
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 8
Hyperlink Feature
Chapter 9
HYPERLINK Function
Chapter 10
IF Alternatives
Chapter 11
Lookup Functions
Chapter 14
Insert Function
Chapter 16
Conditional Formatting Revisited
Chapter 17
Names Revisited
Chapter 18
Wildcards Revisited
Chapter 19
Tables Revisited
Chapter 20
Start Here Revisited
Chapter 23
Common Workpapers