Blog

Excel 2016

Tree map by Jeff Lenning

Microsoft recently released Office 2016, and with it, the next version of my favorite program, Excel. If you would like to get a quick overview of some of the enhancements, please check out this CalCPA Magazine article where I describe the Excel 2016 improvements that caught my eye. Excel 2016 – CalCPA Magazine Article With […]





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