fbpx

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
Order Now
  •  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.

Calculate your paper price
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.

Professional Academic Writers

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.

Customer Support 24/7

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?

Follow these simple steps to get your paper done

Place your order

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

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

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.

Essays

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.

Admissions

Admission and Business Papers

With Myhomeworkwriters.com, we will help you secure a position at your desired institution. Our essay writing services include the crafting of admissions papers. We will still help you climb your career ladder by helping you write the official papers that will help you secure a job. We will guide you on how to write an outstanding portfolio or resume.

Editing

Editing and Proofreading

Myhomeworkwriters.com has a professional editorial team that will help you organize your paper, paraphrase it, and eliminate any possible mistakes. Also, we will help you check on plagiarism to ensure that your final paper posses quality and originality.

Coursework

Technical papers

My Homework Writers harbors professional academic writers from diverse academic disciplines. As such, we can develop homework writing services in all academic areas. The simplicity or complexity of the paper does not affect the quality of homework writing services.