Author Archives: Jeff Lenning

Impossible PivotTables 2 – Show Values As

This is the second post in the Impossible PivotTables series, where we are exploring Power Pivot. In the first post, we examined the limitation of calculated field references in a traditional PivotTable. In this post, we’ll address the limitation of using the Show Values As option for subsequent calculations. If we use the Show Values […]

Impossible PivotTables 1 – Calculated Fields

This is the first post in a series called Impossible PivotTables. The purpose of this series is to explore Power Pivot. I thought a fun way to do that would be to demonstrate how using the data model enables us to build PivotTables that are either impossible with traditional PivotTables or that require workarounds. I […]

Create Dynamic Rows for an Amortization Schedule with Power Query

Sometimes in Excel, we want to use formulas to compute row values, but, the number of rows is dynamic and changes periodically. For example, let’s say we want to create an amortization schedule and use it for a variety of loans. Some loans are paid in 36 months, some in 120 months, and some in […]

Power Pivot CalCPA Article

I’m assuming you love PivotTables. I mean, who doesn’t, right? Well, traditional PivotTables are amazing, but they’re not without limits. Instead of using a traditional table as the PivotTable source, you can take your PivotTables to the next level when you use Power Pivot instead. In this California CPA Magazine article, I talk about a […]

Excel Breakout Puzzle 4

It is time for another breakout puzzle … yay! Have you ever played Sudoku? My family loves doing these puzzles, in fact, last week we had a full-on Sudoku race and competition. Who won? Not me. My daughter totally crushed it. I’d get like 5 squares done, and she’d be like, “done!” Again and again. […]