January 27, 2023 - by Bill Jelen
Problem: As shown in the previous topic, adding calculated items causes the totals to be wrong. I want to test grouping offices into territories. How can I do it?
Strategy: In Build a Better Top 5 Using Groups you learned how to group text in a pivot table. Building territories works in a similar fashion. Follow these steps:
Add a Calculated Item to Group Items in a Pivot Table »
January 26, 2023 - by Bill Jelen
I’m working with the small data set shown here.
Calculated Fields in a Pivot Table »
January 25, 2023 - by Bill Jelen
I need to include in a pivot table a calculation that is not in my underlying data. My data includes quantity sold, revenue, and cost. I would like to report gross profit and average price.
Pivot Ranks Don’t Match RANK() »
January 24, 2023 - by Bill Jelen
I set up a pivot table and showed the values as a rank, using Rank Largest to Smallest. Why is the fourth product assigned a rank of #3?
Excel and the World Wide Web Straight to the Point
February 2021
If you have an Excel workbook that needs to regularly harvest data from a web page, this book is for you. The book covers various methods for getting data from the web, from VBA to Selenium to Power Query.
March 2021
Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems.
Microsoft Excel Inside Out (Office 2021 and Microsoft 365)
December 2021
Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions.
April 2022
The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.