How to make a conditional running total in Excel At this point, you’ve not really gained much; the PivotTable isn’t really any better than the Table and its simple expressions.

You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

Excel offers three functions for calculating the internal rate of return, and I recommend you use all three.