Excel Tips
See Detail Behind One Number in a Pivot Table »
November 25, 2022
One number in my pivot table seems to be wrong. Air Canada does not typically buy XYZ, yet it is shown with that product in the report.
Move or Change Part of a Pivot Table »
November 24, 2022
If I try to insert a row in a pivot table, I am greeted with a message saying that I cannot change, move, or insert cells in a pivot table.
Why Does the Pivot Table Field List Keep Disappearing? »
November 23, 2022
The pivot table tools are there, then they are gone. What is Microsoft’s problem?
Summarize Pivot Table Data by Three Measures »
November 22, 2022
I want to summarize data by region, product, and customer. How can I use a two-dimensional report to show three dimensions of data?
Add or Remove Fields from an Existing Pivot Table »
November 21, 2022
I’ve seen how easy it is to rearrange an existing pivot table by swapping Region and Product fields. Now, what if I want to replace the Region field with the Customer field?
Your Manager Wants Your Report Changed »
November 18, 2022
I presented my first pivot table report, shown previously, to my manager. He said, “This is almost perfect, but could you have the products going across the top and the regions going down the side?”
Use a Pivot Table to Summarize Detailed Data »
November 17, 2022
I have many rows of sales data. I want to produce a summary report that shows sales by region and product.
Flash Fill and Ambiguous Data »
November 16, 2022
How will Flash Fill get this right? Even I wouldn’t know what to fill in next?
November 15, 2022
Flash Fill won’t fill dates. When I use Ctrl+E, it won’t get them right.