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