Käynnissä

Excel Assignment

Easy for someone who knows excel. I attached the instruction below.

Part 1: For the work pages labeled "Chicago, IL" and “San Francisco, CA” perform the following steps: make sure you are consistent on both sheets.

1. Add 2 columns to the right of the Full Name column. Label the first new column "First" and the second new column "Last." Using either spreadsheet functions (e.g., Left, Right, Len, or Find) or text-to-columns (this is easier, but does not work on earlier versions of Excel), split the Full Name column into a First Name column and a Last Name column.

2. Next change the contents of the Full Name column to be in "Last Name, First Name" order. You may have to create another column to do this and then hide the column.

3. Add another column after the “Job Title, and label it "Location." Place the worksheet name in each row of this column for each employee. Use either Copy and Paste or Fill Down operations.

4. Change the Manager column contents to be in "Last Name, First Name" format. You may add temporary columns to do this and then delete them afterward. (If you use formulas that reference temporary columns, you cannot delete the temporary columns. Hint: Copy the calculated formula results, and paste values on top of them.)

5. Adjust column widths for the best fit of all data.

Part 2: For the worksheet labeled "Tokyo, Japan," perform the following steps:

1. Add a column to the left of the First column. Label it "Full Name."

2. Using spreadsheet functions or operations populate the Full Name column using the format "Last Name, First Name."

3. Add another column after the “Job Title”, and label it "Location." Place the worksheet name in each row of this column for each employee.

4. Change the job titles to match Chicago/San Francisco job titles using the following information: You will need nest IFs inside an IF’s.

Tokyo Title Chicago/San Francisco Title

Assistant Administrative Assistant

Customer Service Level 1 Customer Service Representative

Customer Service Level 2 Software Analyst

5. Convert the Salary column contents from Japanese yen to U.S. dollars using the conversion rate 1 U.S. dollar = [url removed, login to view] Japanese Yen. You may add temporary columns to do this and delete them afterward.

6. Add a column, and label it "Manager." Populate this new column. All employees report to the manager in Tokyo. The manager in Tokyo reports to the CEO in Chicago. Use the format "Last Name, First Name" for this column.

Part 3: Create a new worksheet, and call it "Combined."

1. Copy the data rows from the other three sheets into the new worksheet. Make sure the merged data columns align (i.e., contain the correct data). You may need to Paste Special or Paste Values to get the correct data into the correct columns.

2. Sort the worksheet labeled "Combined" by the following levels:

o Location Ascending

o Manager Ascending

o Job Description

o Full Name

3. Turn on Filtering. Use Filtering tools to eliminate the job titles. (You may want to wait on steps 3 and 4 until after Part 4)

o CEO

o Finance

o Office Manager

o Assistant Office Manager

o Administrative Assistant

o Manager

o Any blanks that may be in your data

4. Using the Subtotal tool, and at each change in job title, do the following:

o Use the Average function.

o Add Subtotal to Salary (and nothing else).

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: top chicago, temporary office work, report conversion tool, order entry representative, order entry job description, operations manager salary, office manager job, make data entry easier, japan data entry job, want find employees, operations manager job description, need find name employee, need finance manager, find right employee, find new employees, find data entry employees, finance manager, excel special, entry level salary, entry level office job, entry level finance, data manager job description, data entry tools excel, ceo manager

About the Employer:
( 1 review ) Franklin Park, United States

Projektin tunnus: #4265093

Myönnetty käyttäjälle:

ITDLVR

Easy Excel requirement. I present myself as an EXCEL specialist. My Excel skills are tested out in the Top 1% of all elance and freelance users. You can expect 100% Quality satisfaction and best price from me. Look Lisää

30 $ USD 1 päivässä
(1 arvostelu)
1.0

8 freelanceria on tarjonnut keskimäärin 96 $ tähän työhön

datasolutions6

Hi,Excel expert here...Lets start...More at Private message...

150 $ USD 1 päivässä
(44 arvostelua)
5.7
djain01

Hi, Lets do it now. I have done many Excel Assignments for College students. Pls check the feedback. Thanks djain01

145 $ USD 1 päivässä
(20 arvostelua)
4.8
thetechie13

Excel Expert here

30 $ USD 5 päivässä
(1 arvostelu)
4.0
rahulrahangdale

Thanks....Waiting for your response.

80 $ USD 2 päivässä
(4 arvostelua)
3.4
Sandra03

This is similar to work I've been doing in my recent temp job. I would love to do this for you

100 $ USD 3 päivässä
(0 arvostelua)
0.0
jessicama0216

Hi, I am available for this work, please contact me when you can.

180 $ USD 2 päivässä
(0 arvostelua)
0.0
najilla88

I am having 5 years experience in data entry field i can do this process with a Team if u give me a chance.

50 $ USD 3 päivässä
(0 arvostelua)
0.0