Project III: Decision Making in Excel
RedRocks Consulting is a large computer consulting firm in Denver, Colorado. Don
McCubbrey, the CEO and founder of the firm, is well-known for his philanthropic efforts. He believes that many of his employees also contribute to nonprofit organizations and wants to reward them for their efforts while encouraging others to contribute to charities. He started a program in which RedRocks Consulting matches 50 percent of each donation an employee makes to the charity of his or her choice.
Don has started an Excel file to record the firm’s donations. Included in this file are the employee’s name and ID number, the name of the charity, the dollar amount contributed, and the date the contribution was sent. Don wants you to help him create several worksheets with the following criteria. For Part 1, use the data in the worksheets RedRocks and Month:
Produce a pivot table that summarises the total amount donated by organization. Create a slicer using the month field. This table will allow Don to compare the total amount of money received by organization filtered by month. Apply the tools we covered in class to solve the problem. This one should be quick and easy. It’s crunch time in the semester so let’s make this one short so you can spend more time on your projects.
Submit your excel files (with all functions) on Blackboard. Due date: Nov 3, 2013. Los angeles time