Attached are the instructions and all the information for the assignment. What I will am looking for is someone to complete the assignment but to also give me instructions on how to do each step so I know how to do it for my test. I would like a step-by-step instruction for each individual instruction in this assignment. I am starting the bid low to discuss things with you before we come up on an agreed price.0o
Johnson Equipment, the medium-sized laboratory equipment manufacturing company
where you work, is in the process of acquiring Sloan Manufacturing, a smaller equipment
manufacturer in the same industry.
Because operaTons between your company and Sloan
overlap, you need to merge the data from the new company with similar data for your
±he text Fle you received from Sloan contains categories, product numbers, and
in addiTon to the on-hand quanTty for each product and the number
of products produced during each month of the past year.
You need to add preFxes to the
category names so that the data will match the exisTng data that your company uses.
will use Excel to organize and summarize the data.
workbook Johnson-Sloan from the Appendix A folder.
2) Convert the informaTon in the worksheet into columns.
You need to use text funcTons here.
Sort the data by category and then by product number in ascending order.
Use the Concatenate funcTon to add the appropriate preFx and a dash to each category
using the list on the right.
²or example, the Analyzer category would begin with 600,
followed by a dash and the
category name (600-Analyzer).
Change the data set into an Excel table.
Use the ±otal row to calculate the number of units on hand and the number of units
produced in each month.
±hen add a new column named ±otal to the right of the
December column that calculates the number of units produced for the year for each part.
Display the top 20 items based on the values in the ±otal column to show the parts
with the highest producTon by month.
Save and close the Johnson-Sloan.xlsx notebook.