Say I have an Excel worksheet with 100 rows. Each row in column 1 has the name of a manager and each product has 10 employees. I want to use Excel to group those so I can just see 10 rows, and click ...

When it comes to data analysis, pivot tables are very useful, and many Excel pros vouch for them. However, they do not automatically update when the data changes, placing that easy-to-forget job on ...