If you notice, Excel has taken the sum of amount as the default calculation but we require the average of values in our analysis. So let us see how can we do this.

If you’re looking to improve your skills in creating an amazing Excel dashboard and reports, this Excel book by Michael Alexander and John Walkenbach is a must. Choose the field you want to use as a filter. As we require the total amount earned for each category, we will filter data on the field – Category:

Pivot Table Trick #4 – Add Number Format

Here is a list of 10 amazing Excel books that have been thoughtfully written (and reviewed multiple times over the years). In this Excel book, you will find 70 excel macros that you can customize according to your wish for immediate use.

If you want to learn the pivot table only, then go for Power Pivot and Power BI. This is how you can buy Best Excel Books via this post. Thanks!! This Excel book is meant for people who want to develop applications using Excel and .NET. It isn’t meant for you if you use Excel for your day-to-day work and is geared towards developers. STEP 2: In the ROWS section put in the Sales Month field, in the COLUMNS put in the Financial Year field and in the VALUES area you need to put in the Sales field twice, I explain why below: STEP 4: In the VALUES area put in the Salesfield, for the COLUMNS area put in the Financial Year field, and for the ROWS area put in the Sales Month field VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel by S. Christian AlbrightTopics such as financial functions, complex formula creation, PowerPivot, modeling with Excel, and much much more – are covered in the books below. After going through these books diligently, your productivity in Excel will be maximized, optimized, and enhanced.