Blog


Show PivotTable Months without Data

If you have ever created a PivotTable report that groups by month, you may have encountered an awkward situation where the PivotTable only displays the months that actually have data in the source. The PivotTable will summarize the data that exists and if there are no transactions for a given month, the PivotTable won’t display it. […]


Icon Sets

If you haven’t checked out Excel’s conditional formatting feature recently, you’re missing out on some nice enhancements. The feature formats a cell based on its value. Excel continuously monitors the cell value and updates the formatting as the cell value changes. Conditional formatting has traditionally been limited to basic cell formatting such as fill and […]


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