EXCEL Project

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

Habilidades: Excel

Veja mais: make money with excel, consulting excel, it consulting los angeles, pivot table excel, excel tools, excel project, excel PIVOT, excel pivot table, excel consulting, denver, crunch, Charities, excel submit, compare large file, nov 2013, pivot using, tools compare excel files, compare table data, slicer excel, project program using class, project organization excel, Excel slicer, excel record project, create pivot table using data table, started consulting

Acerca do Empregador:
( 1 comentário ) Los angeles, United States

ID do Projeto: #5090807

Concedido a:


Hi! I understand what you need and can do it right now. I have 12 years of extensive Excel experience.

$30 USD em 0 dias
(10 Comentários)