I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into Values. It will also be nicely formatted. However, if I change anything in ...

That all changed when I discovered two features in Excel most people don't know about: Watch Window and Custom Views. Together, they provided me with a way to track the numbers that matter without ...

In January 1993, a gunman murdered seven people in a fast-food restaurant in Palatine, a suburb of Chicago. In his dual roles as an administrative executive and spokesperson for the police department, ...