Manager of an information technology (IT) team

at
Categories
Tags

 

You are the manager of an information technology (IT) team. Your employees go to training workshops and national conferences to keep up-to-date in the field. You created a list of expenses by category for each employee for the last six months. Now you want to subtotal the data to review total costs by employee and then create a PivotTable to look at the data from different perspectives.

 

Sample Solution

Employee | Total Cost
------- | --------
Alice | 1500
Bob | 2250
Charlie | 1800

| Category | Conference | Training |
| --- | --- | ---|
| Alice | 500 | 1000 |
| Bob | 750 | 1500 |
| Charlie | 600 | 1200 |

As you can see, the total cost for all employees is \$5550. Alice has the lowest total cost at \$1500, while Bob has the highest total cost at \$2250. The cost of training is higher than the cost of conferences for all employees.

Here are some additional insights that you can gain from the PivotTable:

  • Alice spent \$500 more on training than on conferences.
  • Bob spent \$750 more on conferences than on training.
  • Charlie spent \$600 more on training than on conferences.

This question has been answered.

Get Answer