Once you learn how to edit the values, you’ll open up even more possibilities with PivotTables! 2. Then, you’ll learn how to add a Calculated Item and have it compute a value to populate the “quarterly bonus” field in our example. In this post, we use a quarterly bonus scenario to demonstrate how someone would export payroll data, store it in a table, and then create a PivotTable to provide the totals. If that’s a problem you run into on a regular basis, you’re about to learn how to fix it. Edit PivotTable Valuesĭid you know that you can edit the value in a PivotTable? Chances are, you’ve tried to do just that and received an error message. Since we work with PivotTables all the time, we wanted to give them a special shout out and highlight the posts that Excel enthusiasts have appreciated the most! Without further ado, these are our Top 5 most popular PivotTable posts. If you haven’t used the PivotTable feature before, you get plenty of tutorials and fun, hands-on practice with an Excel University Campus Pass. Once you know the basics of how to use pivot tables in Excel, so many new (and efficient!) doors are opened. They allow you to spot similarities, patterns, and trends – especially useful for anyone who works with large amounts of data on a regular basis. If you’re a little unfamiliar with them, you’re in for a treat! PivotTables are powerful tools for calculating, summarizing, and analyzing data. PivotTables are one of Excel’s most useful features.