Excel University Volume 2 Table of Contents

We are getting close to the release of Excel University Volume 2!  I’m absolutely excited about this volume.  We cover the mechanics for setting up hands-free reports.

The manuscript is with the publisher now, going through a round of copy-editing.  I expect it to be released in July or August on Amazon.  I want to share the table of contents now, just to provide a little sneak peak:

Opening Information

  • Chapter 1: Overview
  • Chapter 2: Selected Shortcuts

Conditional Summing

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


  • 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

I will keep you posted as we get closer to the launch date!

Posted in ,

Jeff Lenning

I love sharing the things I've learned about Excel, and I built Excel University to help me do that. My motto is: Learn Excel. Work Faster.

Stay Connected

If you'd like to be notified when I write a new Excel article, enter your name and email and click SUBSCRIBE. You can unsubscribe anytime, and I will never sell your email address.

Want to learn Excel?

Our Campus Pass includes access to our entire Undergrad and Masters catalog. Gamification ensures it is the most fun you can have learning Excel :)


  1. Paul on January 24, 2015 at 7:36 pm

    Is the university excel volume 2 out on the market

    • jefflenning on January 24, 2015 at 8:07 pm

      Yep! It is available on amazon, and, v3 is available as well 🙂

    • jefflenning on January 24, 2015 at 8:12 pm

      The related online courses are available as well, store.excel-university.com

Leave a Comment

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.