Table of Contents
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