Overview: This assignment creates the basic table that you will



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.


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.


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.

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Table of Contents

Calculate your order
Pages (275 words)
Standard price: $0.00

Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

(Answered) Strategic 5 year plan

0 (0) Based on research/ data where available develope strategic planning for a University for the next 5 years to address the following 6 specific

Environmental Autobiography

0 (0) Overview In this assignment, you will be using information from the readings, videos, and your past assignments (specifically, your short paragraphs on of

Project 2- Bare Escentuals

0 (0)  Project 2 – Bare Escentuals Hide Assignment Information Instructions Project 2 – Bare Escentuals (Week 5) Purpose: The purpose of this project is

New questions

Don't Let Questions or Concerns Hold You Back - Make a Free Inquiry Now!