Category Archives: Features

Excel 2019 and O365 + ebook

Historically, when it was time for Microsoft to release the next version of Excel, everyone would be buzzing, excited, and talking about the new features, functions, and improvements. I know that my heart would pitter-patter as the new version was installing on my system. But, things are different now. In fact, in a way, the […]

Edit PivotTable Values

In this post, we’ll talk about how to edit the value in a PivotTable cell. Wait…what!? I’ve been using PTs for a long time, and, I’ve always received an error when I try to edit the value in a PivotTable cell. Yes, we’ve been able to edit the label cells, but, not the value cells. […]

Impossible PivotTables 4 – Average of Distinct Count

This is the 4th and final post in the Impossible PivotTables series, where we are exploring Power Pivot by looking at some limitations encountered with traditional PivotTables. In this post, we’ll look at how to compute the average when there are multiple rows per item. That is, where a simple sum divided by the count […]