Filtering RedRocks Consulting Contributions

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. The only guidelines are that the char- ity must be a nonprofit organization and the firms donation per employee may not exceed $500 a year.

Don has started an Excel file, T3_RedRocks_Data.xls, to record the firms donations. Included in this file are the dates the request for a donation was submitted, the employees name and ID number, the name of the charity, the dollar amount contributed by the firm, and the date the contribution was sent. Don wants you to help him create several work- sheets with the following criteria:

Oneworksheetthatsortsthelistalphabeticallybyorganizationandthenbyemployees last name.

One worksheet that totals the contribution made per employee for the month of December.

One worksheet that sorts the list by donation value by lowest amount to highest amount.

Submitted	Employee ID	Last Name	First Name	Organization	Amount	Donation Sent
11/29/11	688	Abbs	Don	Habitat for Humanity	$ 50	12/1/11
12/5/11	08T	Adams	David	Red Cross	$ 100	12/6/11
12/9/11	Y7CA	Ascott	Karen	Red Cross	$ 100	12/18/11
12/5/11	M5NA	Bagby	Sharon	Rotary Club	$ 25	12/6/11
12/3/11	39N	Butler	Barry	Rotary Club	$ 250	12/10/11
12/3/11	0NNA	Clark	Jolene	Toastmasters	$ 20	12/5/11
12/2/11	0NNA	Clark	Jolene	Make a Wish Foundation	$ 75	12/4/11
12/6/11	0NNA	Clark	Jolene	Leukemia Society	$ 60	12/19/11
12/16/11	CT8A	Donovan	Gary	Make a Wish Foundation	$ 130	12/21/11
12/12/11	1XBA	Doster	Glenn	Amnisty International	$ 200	12/21/11
12/16/11	L3H	Dunn	Elaine	Make a Wish Foundation	$ 225	12/29/11
12/4/11	56NA	Foster	Scott	Rotary Club	$ 125	12/10/11
12/2/11	56NA	Foster	Scott	Meals on WHeels	$ 125	12/26/11
12/17/11	1F9A	Hughes	Gary	Red Cross	$ 50	12/22/11
12/27/11	J5M	Johnson	Les	Foster Children's Fund	$ 25	12/30/11
12/10/11	44JA	Kelleher	George	Romania Relief	$ 180	12/14/11
12/20/11	57XA	Lomstein	Thomas	Meals on WHeels	$ 115	12/22/11
12/12/11	FA5A	Peters	Roger	Toastmasters	$ 35	12/15/11
12/14/11	FA5A	Peters	Roger	Foster Children's Fund	$ 80	12/19/11
12/6/11	R9M	Simpson	Joseph	Red Cross	$ 50	12/19/11
12/13/11	R9M	Simpson	Jospeh	Habitat for Humanity	$ 150	12/23/11
12/6/11	08A	Thimsen	Timothy	Rotary Club	$ 50	12/14/11
12/3/11	C3P	Warren	James	Lion's Club	$ 60	12/13/11
12/27/11	R45A	Womak	Anthony	Habitat for Humanity	$ 100	12/29/11