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.