Category Archives: Training

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 […]


Three Excel University Announcements

I have three exciting Excel University announcements! They are about QBConnect, Top 10 CPE Courses, and Volume 4. First up, QBConnect! QBConnect I’ll be presenting an Excel session at the QBConnect conference in San Jose, and if you are going, I’d love to see you there! The title of the session is Excel: The Power […]


Hyperlinks Article

Back in the old days, when I used workpapers that were made with, you know, paper, I used a red pencil to create cross-references that made it easy to navigate to related documents. Today, I use Excel hyperlinks instead. Check out this CalCPA Technology and Business Resource Guide article where I describe how to use Excel hyperlinks to cross-reference digital […]


Interview

I recently had the immense pleasure of being a guest on the My Excel Online Podcast with John Michaloudis. He is a PivotTable master and an Excel friend. If you’d like to listen to the audio interview, I’ve provided the link below. While you are there, be sure to subscribe to John’s podcast, he does an amazing […]


Xtreme PivotTables Guest Lecture

I’m happy to announce the immediate availability of Excel University’s next guest lecture: Xtreme PivotTables by John Michaloudis. Earn 16 CPE hours while learning more about PivotTables…what could be better? This course provides a comprehensive examination of Excel’s PivotTable feature and explores many powerful capabilities. This course digs into so many details that even experienced PivotTable […]


Excel University Volume 4 Update

Alright friends, I have an update about Excel University Volume 4. I’ve just about completed the initial draft, and am very pleased with how it is shaping up so far. Volume 1 is the foundations volume. Volume 2 is where we discuss formula-based reports. Volume 3 is where we cover PivotTable reports. Volume 4 is […]


PivotTable Month Groups Article

PivotTable article by Jeff Lenning

Did you know that PivotTables can automatically group date fields by month? And by quarter and year? This date group capability makes it easy to summarize data in monthly columns without writing a single formula. Check out my recent California CPA Magazine article for the details. Publication: California CPA Magazine Author: Jeff Lenning CPA Date: May 2015 […]


Announcing Excel University Scholarships

I’m excited to announce the Excel University scholarship program! Excel University will recognize outstanding accounting students enrolled in an accredited college or university in the US, and will provide a $500 cash award as well as free enrollment into our online training program. These scholarships are awarded annually.  Please help me spread the word by forwarding […]


Announcing Guest Lectures

I’m pleased to announce the introduction of Excel University guest lectures! Until now, all of the Excel University courses were written by a single instructor (me). Moving forward, Excel University will also offer guest lectures by my Excel friends and recognized Excel experts. They will be talking about their areas of interest and expertise. Guest […]


Excel University V3 Course is Available!

I am pleased to announce the immediate availability of the Excel University Volume 3 online course! This online course teaches the content of Volume 3 through online videos, homework activities, quizzes, and includes instructor-moderated forums in case you get stuck. It picks up right where Volume 2 ends. More Info   The topics include PivotTables, external […]