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!

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. Emily W. on December 23, 2016 at 9:48 am

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

    • Jeff Lenning on December 23, 2016 at 9:55 am

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

  2. Craig on December 28, 2016 at 10:52 am

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

    • Jeff Lenning on December 29, 2016 at 6:39 pm

      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 on December 29, 2016 at 8:36 am

    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?

    • Jeff Lenning on December 29, 2016 at 8:38 am

      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 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.