read the data an explain pivot table and what steps to follow in excel sheep thank you

M29 + EMPLOYEE PIVOT TABLE The folowing data come from an employee data for Husker Industries. You have been asked to a worksheet fle of this information (file name EMPLOYEE). See Appendix C in Excel complete. Print the worksheet when done. No check figure provided. Test your model (and your pivot table skills) as follows: Ms. Husker would like three more reports. 1. Printout of a table showing total salaries by gender. 2. Printout of a table showing total salaries by gender and by department. 3. Printout of a table showing employee name and bonus by gender for the Accounting department. There is no chart for this worksheet