# Advanced Excel Functionality| Online Assignment Help

Objective: After the completion of this assignment, you will be able to:

Don't use plagiarized sources. Get Your Assignment on
Advanced Excel Functionality| Online Assignment Help
Just from \$13/Page
•  Employ the v-lookup function to merge data from multiple spreadsheets into a single, useable worksheet·         Calculate various metrics using formulas·         Convert text in a single cell into multiple cells
• Use the concatenate function to merge data from multiple cells into a single cell
• Merge and Unmerge cells
• Utilize pivot tables to synthesize data from a spreadsheet

Background: Technology is key to data management and reporting, and Excel is an indispensible tool which allows for the manipulation of data and complex data analysis. This assignment assumes you have a basic working knowledge of Excel and will explore more advanced features that will greatly expand your ability to utilize spreadsheets in the context of HR administration.

Instructions: View the tutorial labeled “Advanced Excel” (linked here (Links to an external site.)Links to an external site. and housed in the “Tutorials Folder” on the course content page).  Then complete the following tasks within the spreadsheet.

1. 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.”
2. 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.”
3. On “Master” worksheet: select all and create a separate pivot table for each of the following:
4. Create a copy of the “Personal Information” worksheet and rename it “Master.”
5. On “Address” Worksheet: generate an email for each employee consisting of EID@companyx.com. Retain only one email field.
6. 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.

Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

At Myhomeworkwriters.com, we always aim at 100% customer satisfaction. As such, we never compromise o the quality of our homework services. Our homework helpers ensure that they craft each paper carefully to match the requirements of the instruction form.

With Myhomeworkwriters.com, every student is guaranteed high-quality, professionally written papers. We ensure that we hire individuals with high academic qualifications who can maintain our quality policy. These writers undergo further training to sharpen their writing skills, making them more competent in writing academic papers.

Affordable Prices

Our company maintains a fair pricing system for all academic writing services to ensure affordability. Our pricing system generates quotations based on the properties of individual papers.

On-Time delivery

My Homework Writers guarantees all students of swift delivery of papers. We understand that time is an essential factor in the academic world. Therefore, we ensure that we deliver the paper on or before the agreed date to give students ample time for reviewing.

100% Originality

Myhomeworkwriters.com maintains a zero-plagiarism policy in all papers. As such, My Homework Writers professional academic writers ensure that they use the students’ instructions to deliver plagiarism-free papers. We are very keen on avoiding any chance of similarities with previous papers.

Our customer support works around the clock to provide students with assistance or guidance at any time of the day. Students can always communicate with us through our live chat system or our email and receive instant responses. Feel free to contact us via the Chat window or support email: support@myhomeworkwriters.com.

Try it now!

## Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Our Homework Writing Services

My Homework Writers holds a reputation for being a platform that provides high-quality homework writing services. All you need to do is provide us with all the necessary requirements of the paper and wait for quality results.

## Essay Writing Services

At My Homework Writers, we have highly qualified academic gurus who will offer great assistance towards completing your essays. Our homework writing service providers are well-versed with all the aspects of developing high-quality and relevant essays.