Topics Covered

Here are the contents at a glance for each Excel University volume.

 

Excel University – Volume 1

Opening Information

• Chapter 1: Overview
• Chapter 2: Book Conventions
• Chapter 3: Excel Conventions
• Chapter 4: How to Make the Most

Foundations

• Chapter 5: Foundations Overview
• 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 15: Workbook Organization
• Chapter 16: Worksheet Organization
• Chapter 17: Nested Functions
• Chapter 18: Selection Groups
• Chapter 19: Workbook Design Principles

 

Excel University – Volume 2

Opening Information

• Chapter 1: Overview
• Chapter 2: Selected Shortcuts

Conditional Summing

• Chapter 3: Conditional Summing Basics with SUMIFS
• Chapter 4: Remove Duplicates

Lookups

• Chapter 5: Lookup Basics
• Chapter 6: Improving VLOOKUP with MATCH
• Chapter 7: Improving VLOOKUP with VALUE and TEXT
• 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

Date and Text Function Basics

• 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

Hands-Free Reporting

• 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: Improving Error Check with Boolean Values and the Logical AND Function
• Chapter 26: Concepts Applied