Volume 4 Available!

Alright…Excel University Volume 4 is available!

Well, this volume has taken two years to create, but, I believe the time spent was well worth it. It is, without a doubt, my favorite volume in the Excel University series. We mainly focus on internal-use workpapers, and how to get them done the fast way! I think I love this volume the most because we are able to use all of the Excel skills developed in previous volumes, and see how they all fit together.


Here is a short preview video of Volume 4.

If you enroll into the V1-4 Bundle, please note that CPE Hours are earned incrementally, upon completion of each volume, as follows:

  • Volume 1: 9 CPE
  • Volume 2: 11 CPE
  • Volume 3: 15 CPE
  • Volume 4: 20 CPE

View Entire Course List

General information about Excel University training

Volume 4 Contents at a Glance


  • 1 Overview
  • 2 Shortcuts
  • 3 Sorting and Filtering
  • 4 Outlining
  • 5 Formatting
  • 6 Printing
  • 7 Protecting
  • 8 Hyperlink Feature


  • 9 HYPERLINK Function
  • 10 IF Alternatives
  • 11 Lookup Functions
  • 12 Text Functions
  • 13 Date Functions
  • 14 Insert Function


  • 15 Ribbon Review
  • 16 Conditional Formatting Revisited
  • 17 Names Revisited
  • 18 Wildcards Revisited
  • 19 Tables Revisited
  • 20 Start Here Revisited


  • 21 JE Preparation
  • 22 Budget Ideas
  • 23 Common Workpapers

If you decide to enroll, I hope that you enjoy it, but more importantly, I hope that Excel University is able to help you get your work done faster!

Get a quick email notice when a new Excel article is available

  • This field is for validation purposes and should be left unchanged.

This article was written by Jeff Lenning


  1. Emily W.

    Jeff, Is there a big difference between the version featuring 2016 and the version featuring 2013?

    1. Jeff Lenning Post author

      Nope…it is the same content, just the screenshots correspond to the version.

  2. Craig

    Hi Jeff, will a kindle version of volume 4 book be available?

    1. Jeff Lenning Post author

      Probably, but I don’t have any timelines on that at this point…and I promise I’m working as fast as I can πŸ™‚

  3. Susan Glasgow

    I have a new employee starting early next year, may I purchase / enroll her now to take advantage of the 12/30/16 discount? What is the non-discounted price going to be?

    1. Jeff Lenning Post author

      Yes! The enrollment period is one year from the date of purchase. After the launch discount, the price bump will be consistent with the other volumes.

Leave a Reply

Your email address will not be published. Required fields are marked *

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.