07 Jul On the “Personal Information” worksheet: Concatenate the t
On the “Personal Information” worksheet: Concatenate the two name fields into a single field so that name is displayed as Last Name, First Name. Copy and “paste as values” and delete the original name fields.3. On “Salary” Worksheet: Compute the tenure of each employee from the Hire Date field.5. On “Address” Worksheet: use the “convert text to columns” to divide location field into city and state and transfer to City and State fields in address block. Create fictitious street address and “drag down” to populate for all; do the same for zip code.7. Using “V-Lookup” function, bring the following fields from the other worksheets into the “Master” worksheet: Pay Rate; Tenure; 2013 Bonus; Job Name; Email; Street Address; City; State; and Zip.a. Demographics: Include employee counts by gender and ethnicity. Rename the worksheet with the pivot table “Demographics Summary.” Salary by Job: Include employee counts and average tenure, average salary and average bonus by job title. Rename the worksheet with the pivot table “Job Summary.” On “Master” worksheet: select all and create a separate pivot table for each of the following: Create a copy of the “Personal Information” worksheet and rename it “Master.” On “Address” Worksheet: generate an email for each employee consisting of [email protected]. Retain only one email field. On “Salary” Worksheet: Compute hourly rates for all employees listed with an annual salary (hrly rate = salary/2080). Replace salary values with hourly (retain only one pay rate field).Deliverable: Submit your spreadsheet (a single excel file) as an attachment in the assignment dropbox by the due date. In total, you should have 7 active worksheets (4 original and 3 new) in your file. Retain a copy of your file for use in assignment 3.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.