Can you please help me?

1. PART 6 (ASSIGNMENT ADDITION #1): Create a Pivot table that tabulates the number of employees by department & gender. Name the worksheet for this "Employees by DeptGender". HINT: What data element do you need to COUNT in order to generate this pivot table? It would obviously have to be a data element whose value was different (unique, like a database table key) for every row in the table in order to insure an appropriate tabulation of employees by department). After you have created this pivot table, name the worksheet "Employees by DeptGender".

2. PART 7 (ASSIGNMENT ADDITION #2): Finally, go back to the worksheet named "Employees by DeptGender". Find the cell that displays the number of female employees in the management department. Click on this to reveal the audit trail of raw data (employee records) that was used in calculating this tally. Use conditional formatting to display in red (or brown) the hire dates of those female employees in management who were hired after 1/1/1993. Rename the worksheet upon which this audit trail has appeared "Fs in Mgmt".

A3 fx 2956 B C D E F G H SSSS 1 2 ID First Name Last Name Department Title 3 2956 Michael Goldstein Engineering Engineer 4 4123 Steve Ballmer Engineering Engineer 5 3117 Frederich Bednarczyk Engineering Engineer 6 2122 Yuan Chang Engineering Engineer 7 2451 Francine Detweiler Engineering Engineer 8 2896 Samuel Gates Engineering Engineer 9 2768 Phyllis Leonard Engineering Engineer 10 1119 Sharad Manispour Engineering Manager 11 2344 Nemesha Mehta Engineering Engineer 12 3210 Carmen Ortega-Molina Engineering Engineer 13 2002 Edgar Rothrock Engineering Engineer 14 3015 Patti Stonesifer Engineering Engineer 15 2678 Koshi Yamamoto Engineering Engineer 16 2733 John Zumkowski Engineering Staff 17 3314 Svetlana Kartashev Human Resources Staff 18 4006 Alice Rovik Human Resources Manager 19 2042 Hillary Cushner Management Staff 20 1851 Melinda English Management Manager 21 1355 Barbara Grabowski Management Manager 22 1173 Roberta Kurzweil Management Manager 23 1441 James Van Horn Management Manager 24 1042 Maria Andretti Marketing CSR 25 1032 Hillary Flintsteel Marketing Staff 26 1009 Kevin Grundies Marketing CSR 27 1614 Artie Lambros Marketing CSR 28 2105 Luca Pacioli Marketing Staff 29 1016 Oscar Gomez Marketing CSR 30 31 32 Salary 51,000 42,900 56,700 46,540 56,700 66,300 59,800 54,500 65,000 46,000 53,300 64,300 49,600 33,000 38,000 43,000 32,000 62,040 75,700 63,000 66,500 42,500 34,500 38,900 41,000 42,300 43,500 Hire Date Birth Date Gender Clearance 4/11/97 3/7/63 TS 5/1/02 4/14/70 5/14/99 5/27/70 9/5/95 3/4/64 M TS 10/10/95 4/29/70 S 1/28/97 4/10/74 M S 12/13/96 7/2/70 F TS 10/13/90 2/4/69 M S 10/1/95 2/12/65 F S 9/16/99 3/28/52 F S 2/8/94 3/21/70 M S 7/6/98 3/10/66 F S 11/16/95 1/24/63 F S 4/18/96 12/12/72 M TS 11/5/01 5/3/82 N 12/1/01 1/26/55 . S 8/26/94 5/6/61 TS 10/1/93 2/14/56 TS 10/13/92 4/10/65 6/16/92 12/22/58 F S 12/18/92 2/3/58 M 3/21/90 8/20/70 F N 3/21/90 8/22/58 F N 12/24/89 3/4/61 M 5/16/93 7/13/70 M N 8/26/95 5/6/50 M S 2/16/90 4/29/67 M N 33 Employee Data 0