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

Features

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

Functions

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

Techniques

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

Applications

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

Excel is not what it used to be.

You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.

Want to learn Excel?

Our training programs start at $29 and will help you learn Excel quickly.

6 Comments

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

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

Leave a Comment