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