Excel Tips
Drag Fields to the Pivot Table »
January 19, 2023
I want to go back to dragging fields around the pivot table like I did back in Excel 97-2003.
Reduce Size 50% Before Sending »
January 18, 2023
I have to upload a file over my aunt’s 56 baud modem. Can I reduce the size of the workbook?
Grouping 1 Pivot Table Groups Them All »
January 17, 2023
I am building two pivot tables. One will show daily sales detail. The other will summarize by month. I arranged the pivot tables side by side. I use the Group feature to group the second pivot table by month.
Create a Frequency Distribution »
January 16, 2023
The VP of sales wants to stop accepting small orders. I need to see how many orders are “small” orders and the impact to our revenue.
Group Employees Into Age Bands »
January 13, 2023
I work in Human Resources. I need to calculate the number of employees and average salary by groups of ages. Initially, I get a pivot table with one row per age. How do I group this into groups like 25-29, 30-34, and so on?
Run Many Pivot Tables From one Slicer »
January 11, 2023
You can see that slicers are better than Report Filters. Another major advantage is that you can filter many pivot tables from one set of slicers. This allows you to create dashboard-like reports.
Add Visual Filters to a Pivot Table or Regular Table »
January 10, 2023
Excel 2007 added the ability to select multiple items from a filter. But when I do this, it uses the ambiguous (Multiple Items) heading. When I print this report, no one knows which customers are in the report.
Create a Report for Every Customer »
January 6, 2023
I need to print a report for each of my customers. Using the Report Filter field is tedious: I spend my whole morning selecting a customer, clicking Print, selecting a customer, clicking Print, and so on.