Overview:
This assignment creates the basic table that you will be working off of for assignments two and four. You will be taking the raw data in the base data Excel document and combining it in a way that you are able to do some basic analytics on. Good luck and have fun!
Some of the Excel videos show Excel 2013. If you have 2010, the Pivot Table Analysis tab is called Options. Some features shown in the video will not be included in Excel 2010; none of these features will be required for any of the assignments, so your ability to complete these assignments will not be compromised at all.
If you run into trouble with the assignments, please use the Watercooler Tab and ask your classmates. I will be monitoring this board to lend a hand as well. Your grade is not dependent on whether you can figure out something on your own; you are graded on your abilities to use the resources you have (within reason) available to you to execute on what needs to be completed.
Instructions:
Using vlookups, display the item name, area, and period month on the All Items tab. Hint: You will need to use at least two vlookups to link series_id to area code and then to area.
The end product will display Item_code, Item_Name, Area_Code, Area and Period_Name on the all_Items tab next to each row of data. Please ensure that your sheet is free of errors (N/A or ref!) when it is turned in. VLookups can be a challenge for those who are not accustom to them, please give yourself time to troubleshoot or reach out for help.
Requirements:
For this and future excel assignments, repeating the action of the tutorials should be done at a minimum. For full credit, make adjustments to formatting, use of other formulas and other additional manipulations that demonstrate that you are gaining the understanding needed in Excel to be a leader in managing analytics.
Please upload your entire Excel workbook to Blackboard when completed.All_Items
series_id
Year
period value
value
APU0000FD2101
2013
M01
2.693
APU0000FD2101
2013
M02
2.633
APU0000FD2101
2013
M03
2.777
APU0000FD2101
2013
M04
2.69
APU0000FD2101
2013
M05
2.743
APU0000FD2101
2013
M06
2.869
APU0000FD2101
2013
M07
2.837
APU0000FD2101
2013
M08
2.906
APU0000FD2101
2013
M09
2.921
APU0000FD2101
2013
M10
2.947
APU0000FD2101
2013
M11
2.805
APU0000FD2101
2013
M12
2.725
APU0100FD2101
2013
M01
2.487
APU0100FD2101
2013
M02
2.551
APU0100FD2101
2013
M03
2.508
APU0100FD2101
2013
M04
2.43
APU0100FD2101
2013
M05
2.546
APU0100FD2101
2013
M06
2.686
APU0100FD2101
2013
M07
2.576
APU0100FD2101
2013
M08
2.603
APU0100FD2101
2013
M09
2.665
APU0100FD2101
2013
M10
2.653
APU0100FD2101
2013
M11
2.537
APU0100FD2101
2013
M12
2.386
APU0000FD2101
2014
M01
2.794
APU0000FD2101
2014
M02
2.825
APU0000FD2101
2014
M03
2.934
APU0000FD2101
2014
M04
2.847
APU0000FD2101
2014
M05
2.976
APU0000FD2101
2014
M06
3.02
APU0000FD2101
2014
M07
3.125
APU0000FD2101
2014
M08
3.281
APU0000FD2101
2014
M09
3.389
APU0000FD2101
2014
M10
3.433
APU0000FD2101
2014
M11
3.331
APU0000FD2101
2014
M12
3.217
APU0100FD2101
2014
M01
2.532
APU0100FD2101
2014
M02
2.567
APU0100FD2101
2014
M03
2.627
APU0100FD2101
2014
M04
2.55
APU0100FD2101
2014
M05
2.651
APU0100FD2101
2014
M06
2.718
APU0100FD2101
2014
M07
2.815
APU0100FD2101
2014
M08
3.089
APU0100FD2101
2014
M09
3.297
APU0100FD2101
2014
M10
3.479
APU0100FD2101
2014
M11
3.302
APU0100FD2101
2014
M12
2.997
APU0000FD2101
2015
M01
3.211
APU0000FD2101
2015
M02
3.221
APU0000FD2101
2015
M03
3.176
APU0000FD2101
2015
M04
2.971
APU0000FD2101
2015
M05
3.045
APU0000FD2101
2015
M06
3.02
APU0000FD2101
2015
M07
3.031
APU0000FD2101
2015
M08
3.103
APU0000FD2101
2015
M09
3.124
APU0000FD2101
2015
M10
3.155
APU0000FD2101
2015
M11
3.015
APU0000FD2101
2015
M12
2.901
APU0100FD2101
2015
M01
3.001
APU0100FD2101
2015
M02
2.994
APU0100FD2101
2015
M03
2.862
APU0100FD2101
2015
M04
2.76
APU0100FD2101
2015
M05
2.908
APU0100FD2101
2015
M06
2.838
APU0100FD2101
2015
M07
2.866
APU0100FD2101
2015
M08
2.862
APU0100FD2101
2015
M09
2.963
APU0100FD2101
2015
M10
2.97
APU0100FD2101
2015
M11
2.859
APU0100FD2101
2015
M12
2.751
APU0000FD2101
2016
M01
2.937
APU0000FD2101
2016
M02
2.928
APU0000FD2101
2016
M03
2.95
APU0000FD2101
2016
M04
2.882
APU0000FD2101
2016
M05
2.909
APU0000FD2101
2016
M06
3.076
APU0000FD2101
2016
M07
3.072
APU0000FD2101
2016
M08
3.098
APU0000FD2101
2016
M09
3.135
APU0000FD2101
2016
M10
3.105
APU0000FD2101
2016
M11
3.037
APU0000FD2101
2016
M12
2.906
APU0100FD2101
2016
M01
2.877
APU0100FD2101
2016
M02
2.849
APU0100FD2101
2016
M03
2.73
APU0100FD2101
2016
M04
2.807
APU0100FD2101
2016
M05
2.796
APU0100FD2101
2016
M06
2.982
APU0100FD2101
2016
M07
3.098
APU0100FD2101
2016
M08
3.075
APU0100FD2101
2016
M09
3.178
APU0100FD2101
2016
M10
3.094
APU0100FD2101
2016
M11
3.042
APU0100FD2101
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.