Excel University Volume 4

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.

Enrollment Links

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!